EBS Object Types - Application Object Library (AOL)

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

Object Type Identification

  • Files with extensions .ldt, .ildt are included regardless of location
  • The file content is also analyzed by the populate process to determine the type.

File Extensions

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)ALR_ALERTS | AME_ACTION_USAGES | AME_APPROVAL_GROUP_CONFIG | AME_APPROVAL_GROUPS | AME_ATTRIBUTE_USAGES | AME_ATTRIBUTES | AME_CALLING_APPS | AME_CONDITIONS | AME_RULES | DESC_FLEX | FND_ATTACHMENT_FUNCTIONS | FND_CURRENCY | FND_DOC_SEQUENCE_CATEGORIES | FND_FOLDERS | FND_FORM_CUSTOM_RULES | FND_LANGUAGE | FND_LOOKUP_TYPE | FND_NEW_MESSAGES | FND_PRINTER | FND_RESPONSIBILITY | FND_SEQUENCE | FND_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
AOL Root Destination DirectoryFDEBS_AOL_ROOT_DESTINATION_DIRSub-directory within project's SCM source path which contains AOLs.$<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 

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 

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

Request group name is actual name and not code. Unit Name is Code instead of Name. This is due to how FNDLOAD command works.

Request Group - all entries

Request Group for one entry

Request Group for entries matching wildcard pattern