Web 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

File Extensions

NameDescription
.ldtLoader Data files for Oracle Web Applications Desktop Integrator. 

Object Type

NameCode
Web ADIWEB_ADI

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM (**populating from SCM)

EBS (**manual creation)

SCM | EBS
TypeTYPEObject TypeIntegrators Integrators | Layouts | Mappings | Contents
CodeCodeObject Name

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


Application Short CodeAPP_SHORT_CDApp short name (e.g. XXAR)

It is taken from the Project Property

FDEBS_APPLICATION_SHORT_NAME.

If that is not filled in, the root folder name from SCM is used.


Control FileCONTROL_FILEThe lct file to use such as bneintegrator.lctThe default is set based on Type.
Target LocationTARGET_LOCATIONFinal location the file will be placed before importing when deploying or will be exported from when building$APP_SHORT_CD_TOP/patch/115/import/
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
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 $BNE_TOP/patch/115/import/bneintegrator.lct "$SOURCE_FILE" BNE_INTEGRATORS INTEGRATOR_ASN=XXHR INTEGRATOR_CODE=webRepoT22

Sample Deploy Commands 

cp "$SOURCE_FILE" "$XXHR_TOP/patch/115/import/";
FNDLOAD $FDEBS_DB_USER/$FDEBS_DB_PASSWORD 0 Y UPLOAD "$BNE_TOP/patch/115/import/bneintegrator.lct $XXHR_TOP/patch/115/import/webRepoT22";