Total Pageviews

Thursday, 13 March 2014

Sample Control File To Load the Flat file data into Staging tables

--#########################################################################
--#
--# 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