Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. The project object will be passed in as the control file.

Object Type Identification

...

Name
DescriptionDefault Value
EBS SQL LDR Root Source DirectoryFDEBS_SQL_LDR_ROOT_SOURCE_DIRSource folder for control (ctl) files (e.g. control).sqlldr
EBS SQL LDR Root Destination DirectoryFDEBS_SQL_LDR_ROOT_DESTINATION_DIRTarget directory for control (ctl) files (e.g. $XXHR_TOP/admin/bin).

(Only used for full deploy projectsNot used currently)

$<PROD_TOP>/admin/bin
EBS Data Root Destination DirectoryFDEBS_DAT_ROOT_DESTINATION_DIR

Target directory for Dat files (e.g. $XXHR_TOP/admin/import).

(Only used for full deploy projects)

$<PROD_TOP>/patch/115/import
File PermissionsFDEBS_FILE_PERMISSIONSTarget File Permission. Will be set to target file after deployment using chmod. eg: 755

...