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.