Control file for GL Interface

Complete GL Interface

Control file for GL Interface

LOAD DATA
INFILE *
TRUNCATE INTO TABLE GL_INTERFACE_TEMP
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
                (STATUS,
                 SET_OF_BOOKS_ID,
                 ACCOUNTING_DATE,
                 CURRENCY_CODE,
                 DATE_CREATED,
                 CREATED_BY,
                 ACTUAL_FLAG,
                 USER_JE_CATEGORY_NAME,
                 USER_JE_SOURCE_NAME,
                 SEGMENT1,
                 SEGMENT2,
                 SEGMENT3,
                 SEGMENT4,
                 SEGMENT5,
                 ENTERED_DR,
                 ENTERED_CR,
                 ACCOUNTED_DR,
                 ACCOUNTED_CR,
                 GROUP_ID)
BEGIN DATA
"NEW","1","11-AUG-2002","USD","11-AUG-2002","1318","A","Inventory","JETFORMS","01","110","7730","0000","000","555","555","555","555","11"
"NEW","1","11-AUG-2002","USD","11-AUG-2002","1318","A","Inventory","JETFORMS","01","110","7730","0000","000","555","555","555","555","11"

Run below script from Command prompt:

sqlldr apps/apps control='/apps/aptest/visappl/xxcus/11.5.0/bin/XX_GL.ctl'    log='/apps/aptest/visappl/xxcus/11.5.0/bin/XX_GL.log'

Complete GL Interface