EBS Object Types - Web ADI

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

  • Files loaded from SCM are not automatically identified as Web ADI files. They need to be moved to the Web ADI type manually.

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";