Friday 19 April 2013

Payroll Process Contorl file ..

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)

No comments:

Post a Comment