Sunday, 4 December 2011

Control File to upload element entry

-- File Name         : XXARJ_CREATE_ELEMENT_ENTRY.ctl
-- File Type         : SQL*Loader Control file.
-- RICEW Object id   :
-- Description       : This SQL*Loader file is used to load  data
--                     from flat file to the staging table XXARJ_CREATE_ELEMENT_ENTRY
-- Maintenance History:
LOAD DATA
INFILE '/genhor12app/hc12u/uat/apps/apps_st/appl/XXARJ/12.0.0/data/XXARJ_CREATE_ELEMENT_ENTRY.csv'
APPEND
INTO TABLE  XXARJ_CREATE_ELEMENT_ENTRY
TRUNCATE
FIELDS TERMINATED BY "," optionally enclosed by '"'
TRAILING NULLCOLS
( "ELEMENT_NAME" ,
    "BATCH_NAME" ,
    "ENTRY_TYPE" ,
    "CREATOR_TYPE",
    "EFFECTIVE_START_DATE" ,
    "BUSINESS_GROUP_ID"  ,
    "EMPLOYEE_NUMBER"    ,
    "NEW_EMPLOYEE_NUMBER" ,
    "INPUT_VALUE_1"       ,
    "ENTRY_VALUE_1"       ,
    "INPUT_VALUE_2"       ,
    "ENTRY_VALUE_2"       ,
    "INPUT_VALUE_3"       ,
    "ENTRY_VALUE_3"       ,
    "INPUT_VALUE_4"       ,
    "ENTRY_VALUE_4"       ,
    "INPUT_VALUE_5"       ,
    "ENTRY_VALUE_5"       ,
    "INPUT_VALUE_6"       ,
    "ENTRY_VALUE_6"       ,
    "INPUT_VALUE_7"       ,
    "ENTRY_VALUE_7"       ,
    "INPUT_VALUE_8"       ,
    "ENTRY_VALUE_8"       ,
    "INPUT_VALUE_9"       ,
    "ENTRY_VALUE_9"       ,
    "INPUT_VALUE_10"      ,
    "ENTRY_VALUE_10"      ,
    "INPUT_VALUE_11"      ,
    "ENTRY_VALUE_11"      ,
    "INPUT_VALUE_12"      ,
    "ENTRY_VALUE_12"      ,
    "INPUT_VALUE_13"      ,
    "ENTRY_VALUE_13"      ,
    "INPUT_VALUE_14"      ,
    "ENTRY_VALUE_14"      ,
    "INPUT_VALUE_15"      ,
    "ENTRY_VALUE_15"      ,
    "PROCESS_FLAG"  CONSTANT 'N',
    "ERROR_MESSAGE"       ,
    "ELEMENT_ENTRY_ID"    ,
    "OBJECT_VERSION_NUMBER",
    "CREATION_DATE" SYSDATE,
    "CREATED_BY" "FND_GLOBAL.USER_ID",
    "LAST_UPDATE_DATE" SYSDATE,
    "LAST_UPDATED_BY" "FND_GLOBAL.USER_ID" ,
    "LAST_UPDATE_LOGIN" "FND_GLOBAL.LOGIN_ID"
 )


 

No comments:

Post a Comment