Hi,
here is my control file :
OPTIONS (skip = 1)
LOAD DATA
INFILE '/public/reworks/XXBC_BU_REBATE_BALANCE.csv'
INSERT INTO TABLE CUSTOM.XXBC_BU_REBATE_BAL_HISTORY
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( PERIOD_NAME "TRIM(:PERIOD_NAME)",
RBT_NO "TRUNC(:RBT_NO)",
RBT_DESC "TRIM(:RBT_DESC)",
GL_ACCOUNT "TRUNC(:GL_ACCOUNT)",
PR_MONTH_RBT_AMT "TRUNC(:PR_MONTH_RBT_AMT)",
PR_MONTH_DED "TRUNC(:PR_MONTH_DED)",
CR_MONTH_RBT_AMT "TRUNC(:CR_MONTH_RBT_AMT)",
CR_MONTH_DED "TRUNC(:CR_MONTH_DED)",
DEBIT_ACCOUNT "TRUNC(:DEBIT_ACCOUNT)",
START_DATE "TRIM(:START_DATE)",
END_DATE "TRIM(:END_DATE)",
SET_OF_BOOKS_ID "TRUNC(:SET_OF_BOOKS_ID)",
CHANNEL "TRIM(:CHANNEL)",
RBT_TYPE "TRIM(:RBT_TYPE)",
RBT_AMOUNT "TRUNC(:RBT_AMOUNT))",
COMMENTS "TRIM(:COMMENTS)",
REGION_CODE "TRIM(:REGION_CODE)",
REGION_NAME "TRIM(:REGION_NAME)"
)
Here is my data file,
PERIOD,RBT_NO,RBT_DESC,GL_ACCOUNT,PR_MONTH_RBT_AMT,PR_MONTH_DED,CR_MONTH_RBT_AMT,CR_MONTH_DED,DEBIT_ACCOUNT,START_DATE,END_DATE,SET_OF_BOOKS_ID,CHANNEL,RBT_TYPE,RBT_AMOUNT,COMMENTS,REGION_CODE,REGION_NAME
13-Sep,56161,AMAZON.COM - 2012 - U - MDF - D.BRATCHER/D.VASEN - CATEGORY 0100 - 20%,12301,"-265,071.24",,,0,40302,1-Jan-12,31-Dec-12,1,CHECM1,FR,"-265,071.24",TESTING,,
But when running this SQL LOADER, I am getting below error :
SQL*Loader-929: Error parsing insert statement for table CUSTOM.XXBC_BU_REBATE_BAL_HISTORY.
ORA-00947: not enough values
Program exited with status 1
Concurrent Manager encountered an error while running SQL*Loader for your concurrent request 143261003.
Please help to solve this.
Thanks,
Suvendu