--#########################################################################
--#
--# Application : Oracle General Ledger
--# Module : GL Journals Interface
--# File : XXXGLINT_CBS.ctl
--# Version : %R%.%L%
--# Last Update : %E%.%U%
--# Description : This scripts loads the data from csv to staging table
--#
--# Parameters : All the parameter are defined in ctl file
--#
--# Exec Method : sqlldr userid/pwd
--#
--#
--# Change History
--# --------------
--#
--# Date Author Ver. Change Description
--# ----------- ----------------- ---- ------------------------------------
--# 23-Oct-2012 Ashok 1.0 Created
--#
--#########################################################################
--
LOAD DATA
APPEND
INTO TABLE XXX_GLINT_TM300i
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
SET_OF_BOOKS_ID ,
ORG_ID ,
JOURNAL_SOURCE_NAME,
ACCOUNTING_DATE ,
AP_AR_IDENTIFIER,
CURRENCY_CODE ,
SEGMENT1 ,
SEGMENT2 ,
SEGMENT3 ,
SEGMENT4 ,
SEGMENT5 ,
SEGMENT6 ,
SEGMENT7 ,
SEGMENT8 ,
SEGMENT9 ,
ENTERED_DR ,
ENTERED_CR ,
REFERENCE_10 ,
PERIOD_NAME "substr(:PERIOD_NAME,1,5)",
RECORD_NUM RECNUM ,
REQUEST_ID "(SELECT MAX(b.request_id) FROM FND_CONCURRENT_PROGRAMS a, FND_CONCURRENT_REQUESTS b WHERE a.concurrent_program_id = b.concurrent_program_id AND a.concurrent_program_name = 'XXXGLINTCBS' AND b.phase_code = 'R' AND b.status_code = 'R')"
)
--#
--# Application : Oracle General Ledger
--# Module : GL Journals Interface
--# File : XXXGLINT_CBS.ctl
--# Version : %R%.%L%
--# Last Update : %E%.%U%
--# Description : This scripts loads the data from csv to staging table
--#
--# Parameters : All the parameter are defined in ctl file
--#
--# Exec Method : sqlldr userid/pwd
--#
--#
--# Change History
--# --------------
--#
--# Date Author Ver. Change Description
--# ----------- ----------------- ---- ------------------------------------
--# 23-Oct-2012 Ashok 1.0 Created
--#
--#########################################################################
--
LOAD DATA
APPEND
INTO TABLE XXX_GLINT_TM300i
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
SET_OF_BOOKS_ID ,
ORG_ID ,
JOURNAL_SOURCE_NAME,
ACCOUNTING_DATE ,
AP_AR_IDENTIFIER,
CURRENCY_CODE ,
SEGMENT1 ,
SEGMENT2 ,
SEGMENT3 ,
SEGMENT4 ,
SEGMENT5 ,
SEGMENT6 ,
SEGMENT7 ,
SEGMENT8 ,
SEGMENT9 ,
ENTERED_DR ,
ENTERED_CR ,
REFERENCE_10 ,
PERIOD_NAME "substr(:PERIOD_NAME,1,5)",
RECORD_NUM RECNUM ,
REQUEST_ID "(SELECT MAX(b.request_id) FROM FND_CONCURRENT_PROGRAMS a, FND_CONCURRENT_REQUESTS b WHERE a.concurrent_program_id = b.concurrent_program_id AND a.concurrent_program_name = 'XXXGLINTCBS' AND b.phase_code = 'R' AND b.status_code = 'R')"
)
No comments:
Post a Comment