Versions Compared

Version Old Version 6 New Version Current
Changes made by

Karl Henselin

Emily Simon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.

Table of Contents
minLevel2

Object Type Identification

...

NameDescription
.ldtLoader Data files containing entity definitions, parent-child relationships, input parameters and data.

...

Object Type

NameCode
Application Object Library (AOL)AOL

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM (**populating from SCM)

EBS (**manual creation)

SCM | EBS
App Short NameAPP_SHORT_NAMEApplication Short NameProject Property FDEBS_APPLICATION_SHORT_NAME is the default. If that is unset, the default is the root folder name from SCM
TypeTYPEAOL Object TypePROGRAM (derived when populating from SCM)
PROGRAM
ALR_ALERTS |
FND
AME_
LOOKUP
ACTION_
TYPE
USAGES |
REQUEST
AME_APPROVAL_GROUP_CONFIG |
REQ
AME_APPROVAL_
SET
GROUPS |
REQ
AME_
SET
ATTRIBUTE_
LINKS
USAGES |
DESC
AME_
FLEX
ATTRIBUTES |
KEY
AME_CALLING_
FLEX
APPS |
MENU | PRINTER | PRINTER_STYLE | PROFILE | FND_USER
AME_CONDITIONS | AME_RULES | DESC_FLEX | FND_ATTACHMENT_FUNCTIONS | FND_
RESPONSIBILITY
CURRENCY | FND_DOC_
NEW
SEQUENCE_
MESSAGES
CATEGORIES | FND_
ATTACHMENT_FUNCTIONS
FOLDERS | FND_FORM_CUSTOM_
CURRENCY
RULES | FND_LANGUAGE | FND_
TERRITORY
LOOKUP_TYPE | FND_NEW_
TABLE
MESSAGES | FND_
VIEW
PRINTER |
GRANT
FND_RESPONSIBILITY | FND_SEQUENCE | FND_
DOC_SEQUENCE_CATEGORIES | VALUE_SET | VALUE_SET_VALUE | VALUE_SECURITY_RULE | VALUE_ROLLUP_GROUP | SCHEDULE | FND_FORM_CUSTOM_RULES | FORM | FUNCTION | ALR_ALERTS | WF_ROLE | XDO_DS_DEFINITIONS | JTF_GRID_DATASOURCES | AME_CONDITIONS | AME_APPROVAL_GROUPS | AME_APPROVAL_GROUP_CONFIG | AME_RULES | AME_ACTION_USAGES | AME_CALLING_APPS | AME_ATTRIBUTES | AME_ATTRIBUTE_USAGES | OTHERName
TABLE | FND_TERRITORY | FND_USER | FND_VIEW | FORM | FUNCTION | GRANT | INTEGRATION_REPOSITORY | JTF_GRID_DATASOURCES | KEY_FLEX | MENU | MENU_ENTRY | OTHER | PRINTER | PRINTER_STYLE | PROFILE | PROGRAM | QUEUE | REQ_SET | REQ_SET_LINKS | REQUEST_GROUP | REQUEST_GROUP_ENTRY | SCHEDULE | VALUE_ROLLUP_GROUP | VALUE_SECURITY_RULE | VALUE_SET | VALUE_SET_VALUE | WF_ROLE | XDO_DS_DEFINITIONS
NameNAMEAOL Object Name

<File Name> (**without path/extension)


Target LocationTARGET_LOCATIONPath to where the file should be deployed to.$<PROD_TOP>/patch/115/import/
Control FileCONTROL_FILEConfiguration file used to download/upload data.$FND_TOP/patch/115/import/afcpprog.lct
NLS LanguageNLS_LANGSpecifies the current language of the session.AMERICAN_AMERICA.US7ASCIIAny valid language name using the OLAP DML syntax.
Upload ModeUPLOAD_MODE

NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS.

REPLACEREPLACE | NLS
Custom ModeCUSTOM_MODE

To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE.

FORCENONE | FORCE
Additional ParametersADDITIONAL_PARAMSOptional parameters to supply to the FNDLOAD command.

...



Target File PermissionsFILE_PERMISSIONSPermissions to apply to the file after it is deployedDefaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

NameCodeDescriptionDefault Value
EBS
AOL Root Destination Directory
Sub-directory within project's SCM source path which contains AOLs
FDEBS_AOL_ROOT_DESTINATION_DIRTarget directory for AOL objects.$<PROD_TOP>/patch/115/import

...

File PermissionsFDEBS_FILE_PERMISSIONSTarget File Permission. Will be set to target file after deployment using chmod. eg: 755

Sample Build Commands 

Code Block
languagebash
themeRDark
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct "$SOURCE_FILE" PROGRAM APPLICATION_SHORT_NAME=XXHR CONCURRENT_PROGRAM_NAME=XXHRCP01

...

Sample Deploy Commands 
 Code Block
languagebash
themeRDark
cp $SOURCE_FILE $XXHR_TOP/patch/115/import/;
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD  $FND_TOP/patch/115/import/afcpprog.lct "$XXHR_TOP/patch/115/import/XXHR_Second_CP.ldt" - UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE ;
Examples
 Tip
Request group name is actual name and not code. Unit Name is Code instead of Name. This is due to how FNDLOAD command works.
 Child pages (Children Display)
sorttitle