DescriptionWeb Application Desktop Integrator or Web ADI is a tool that brings Oracle E-Business Suite functionality to a spreadsheet, where familiar data entry and modeling techniques can be used to complete Oracle E-Business Suite tasks.
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 typeFiles loaded from SCM are not automatically identified as Web ADI files. They need to be moved to the Web ADI type manually.
File Extensions
| Name | Description |
|---|---|
| .ldt | Loader Data files containing entity definitions, parent-child relationships, input parameters and data.for Oracle Web Applications Desktop Integrator. |
Attributes
| Name | Description | Default Value | Supported Values | ||||
|---|---|---|---|---|---|---|---|
| Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS | ||||
| 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_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 | AOLIntegrators | Integrators | Layouts | Mappings | Contents | |
| Code | Object Name |
| Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/import/ | Control File | |
| Application Short Code | App short name (e.g. XXAR) | It is taken from the Project Property
| |||||
| Target Location | Configuration file used to download/upload data. | $FND$<PROD_TOPTOP>/patch/115/import/afcpprog.lctNLS Language | Specifies the current language of the session. | AMERICAN_AMERICA.US7ASCII | Any valid language name using the OLAP DML syntax. | ||
| Upload Mode | NLS data uploads for translated columns are supported - use UPLOAD_MODE= NLS. | REPLACE | REPLACE | NLS | ||||
| Custom Mode | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE. | FORCE | NONE | FORCE | Additional Parameters | Optional parameters to supply to the FNDLOAD command. | ||
Related Project Properties
| Name | Description | Default Value | EBS AOL Root Destination Directory | Sub-directory within project's SCM source path which contains AOLs. | $<PROD_TOP>/patch/115/import|
|---|---|---|---|---|---|
Sample Build Commands
| Code Block | ||||
|---|---|---|---|---|
| ||||
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y DOWNLOAD $FND$BNE_TOP/patch/115/import/afcpprogbneintegrator.lct $SOURCE_FILE PROGRAMBNE_INTEGRATORS APPLICATIONINTEGRATOR_SHORT_NAMEASN=XXHR CONCURRENTINTEGRATOR_PROGRAM_NAMECODE=XXHRCP01webRepoT22 |
Sample Deploy Commands
| Code Block | ||||
|---|---|---|---|---|
| ||||
cp $SOURCE_FILE $XXHR_TOP/patch/115/import/; FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD $FND$BNE_TOP/patch/115/import/afcpprogbneintegrator.lct $XXHR_TOP/patch/115/import/XXHR_Second_CP.ldt - UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE webRepoT22; |