Running a SQL Loader as a concurrent program

There are few steps to register a control file in Oracle Applications R12.

Step I:

Place the test.ctl script under the “bin” directory in application top directory e.g“$FND_TOP/bin”.

Also place the data.csv file on the server and give the complete path of csv in ctl file. e-g: /opt/oracle/FND_TOP/bin/data.csv

Step II:

   Login to Oracle Application  > System Administrator responsibility
   Navigate Concurrent > Program > Executable and enter a new one:
   Executable: test
   Short Name: test
   Application: Application Object Library (or if you place it in any other top then give its name)
   Description: SQL Loader
   Execution Method: SQL*Loader
   Execution File Name: test

Step III:

   Navigate to: Concurrent > Program > Define and enter a new one:

   Program: SQL Loader Program
   Short Name: test
   Application: Application Object Library
   Description: SQL Loader
   Name: test
   Method: SQL*Loader

   Output Format: Text

Step IV:  

   Navigate Security > Responsibility > Request
   Query for Group: System Administrator Reports and add one request
   Type: Program, Name:  SQL Loader program