OPTIONS (SKIP=1)
LOAD DATA
INFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.csv'
BADFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.bad'
DISCARDFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.dsc'
APPEND
INTO TABLE gl.GL_interface
fields terminated by ',' optionally enclosed by '"'
TRAILING NULLCOLS
(STATUS,
LEDGER_ID,
ACCOUNTING_DATE date "DD-MM-YY",
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
DATE_CREATED date "DD-MM-YY" ,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
USER_CURRENCY_CONVERSION_TYPE,
SEGMENT1,
SEGMENT2 "DECODE (:SEGMENT2,'0','000',:SEGMENT2)",
SEGMENT8 "DECODE (:SEGMENT8,'0','000000',:SEGMENT8)",
SEGMENT4 "DECODE (:SEGMENT4,'0','0000',:SEGMENT4)",
SEGMENT5 "DECODE (:SEGMENT5,'0','00',:SEGMENT5)",
SEGMENT6 "DECODE (:SEGMENT6,'0','0000',:SEGMENT6)",
SEGMENT7 "DECODE (:SEGMENT7,'0','0000',:SEGMENT7)",
ENTERED_DR,
ENTERED_CR,
REFERENCE1,
REFERENCE4,
REFERENCE5,
REFERENCE10)
LOAD DATA
INFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.csv'
BADFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.bad'
DISCARDFILE '/oracle/DEVNEW/apps/apps_st/appl/gl/12.0.0/bin/PAYROLL1.dsc'
APPEND
INTO TABLE gl.GL_interface
fields terminated by ',' optionally enclosed by '"'
TRAILING NULLCOLS
(STATUS,
LEDGER_ID,
ACCOUNTING_DATE date "DD-MM-YY",
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
DATE_CREATED date "DD-MM-YY" ,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
USER_CURRENCY_CONVERSION_TYPE,
SEGMENT1,
SEGMENT2 "DECODE (:SEGMENT2,'0','000',:SEGMENT2)",
SEGMENT8 "DECODE (:SEGMENT8,'0','000000',:SEGMENT8)",
SEGMENT4 "DECODE (:SEGMENT4,'0','0000',:SEGMENT4)",
SEGMENT5 "DECODE (:SEGMENT5,'0','00',:SEGMENT5)",
SEGMENT6 "DECODE (:SEGMENT6,'0','0000',:SEGMENT6)",
SEGMENT7 "DECODE (:SEGMENT7,'0','0000',:SEGMENT7)",
ENTERED_DR,
ENTERED_CR,
REFERENCE1,
REFERENCE4,
REFERENCE5,
REFERENCE10)
No comments:
Post a Comment