SQL LOADER

Control File
===========
LOAD DATA 
INFILE '/hdgstg01/prodapps/plsql/incoming/Canadian_Exchange_201701.csv'
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....

This kind of Sql loader takes the parameter if not it will take the default File chargeback.csv



LOAD DATA
 INFILE 'chargeback.csv'
 BADFILE 'chargeback.bad'
 DISCARDFILE 'chargeback.dsc'
TRUNCATE INTO TABLE  HDG_CHARGEBACK_STG_TBL
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(CUSTOMER_NUMBER ,
 BIPAD,
 ISSUE_CODE,
 QUANTITY,

 CUSTOMER_REF_NR)