A 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
Name | Description |
|---|---|
.ldt | Loader Data files containing entity definitions, parent-child relationships, input parameters and data. |
Object Type
Name | Code |
|---|---|
Application Object Library (AOL) | AOL |
Object Type Attributes
Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
Source | SOURCE | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
App Short Name | APP_SHORT_NAME | Application Short Name | Project Property FDEBS_APPLICATION_SHORT_NAME is the default. If that is unset, the default is the root folder name from SCM | |
Type | TYPE | AOL Object Type | PROGRAM (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 |
Name | NAME | AOL Object Name |
| |
Target Location | TARGET_LOCATION | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/import/ | |
Control File | CONTROL_FILE | Configuration file used to download/upload data. | $FND_TOP/patch/115/import/afcpprog.lct | |
NLS Language | NLS_LANG | Specifies the current language of the session. | AMERICAN_AMERICA.US7ASCII | Any valid language name using the OLAP DML syntax. |
Upload Mode | UPLOAD_MODE | NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS. | REPLACE | REPLACE | NLS |
Custom Mode | CUSTOM_MODE | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE. | FORCE | NONE | FORCE |
Additional Parameters | ADDITIONAL_PARAMS | Optional parameters to supply to the FNDLOAD command. | ||
Target File Permissions | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
Related Project Properties
Name | Code | Description | Default Value |
|---|---|---|---|
AOL Root Destination Directory | FDEBS_AOL_ROOT_DESTINATION_DIR | Target directory for AOL objects. | $<PROD_TOP>/patch/115/import |
File Permissions | FDEBS_FILE_PERMISSIONS | Target 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.