SQL LOADER(Control File to send the .csv file dynamically from the front end through EBS Suite)

LOAD DATA 
INFILE '$FILE'
TRUNCATE INTO TABLE CMG_TEST2
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(PPA_SUBCLASS_ID,
GL_number,
REMARKS,
BIPAD,
ISSUE_CODE,
AMOUNT,
CUR_CODE)

1.)Then Place the '.CSV' file in the above mentioned Location.
('/hdgstg01/prodapps/plsql/incoming/Canadian_Exchange_201701.csv')
2.)Then always Place the .ctl (control file ) in the Bin folder depending upon the application..

(/bo/201/app/oracle/product/appsdev/appl/fnd/11.5.0/bin/LOAD_TEST.ctl)

3.)Then create the executable file according to the Control file i.e call the LOAD_test file as executablie file and assign it to the concurrent job.

4.Then Look for log and output file to find the errors if we have any....