Oracle R12 Register SQL*Loader as a Concurrent Program
Step 1:
Create the SQL*Loader Control and Data file and place them in Server(ex: $CUSTOM_TOP/bin). Create or check the interface table structures in the backend.
Step 2:
Go to Application Developer => Concurrent => Executables. Define a Concurrent Program Executable.
Choose the Execution Method as SQL*Loader and give the Execution File Name as the name of the SQL*Loader control file.
Step 3:
Go to Application Developer > Concurrent > Program. Define the Concurrent Program. Attach the executable defined above.
Step 4:
Go to parameters of the concurrent program. Create a parameter to take the server path of the data file. You can also place the default value.
Step 5:
Added the Concurrent Program to a Custom Responsibility through a Request Group.
Step 6:
Go to that Custom Responsibility and Run the Concurrent Program. If successful check the output file that have all data uploading information.
Step 7:
Check in the backend whether the tables got updated or not.
The Bad and Discard files will be created in /conc/out file of the server or you set in control file .
Note:
Bad file: The bad file contains rows that were rejected because of errors.
Discard file: The discard file contains rows that were discarded because they were filtered out control file.