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 | Description | Default Value | |
---|---|---|---|
EBS SQL LDR Root Source Directory | FDEBS_SQL_LDR_ROOT_SOURCE_DIR | Source folder for control (ctl) files (e.g. control). | sqlldr |
EBS SQL LDR Root Destination Directory | FDEBS_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 Directory | FDEBS_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 Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
...