PROCESS = Import Account Info

SESSION SQL = "ALTER SESSION SET CURSOR_SHARING=SIMILAR DB_FILE_MULTIBLOCK_READ_

COUNT=128"
[Import Account Info]
TYPE = SHELL
INCLUDE= Import_Address
INCLUDE= Import_Account
INCLUDE= Import_Account_Address
INCLUDE= Import_Account_Primary_Address
[Import_Address ]
TYPE = IMPORT
BATCH = 111
TABLE = EIM_ADDR_PER
ONLY BASE TABLES = S_ADDR_PER
INSERT ROWS = S_ADDR_PER, TRUE
LOG TRANSACTIONS = FALSE
ONLY BASE COLUMNS = S_ADDR_PER.ADDR, \
S_ADDR_PER.ADDR_LINE_2, \
S_ADDR_PER.ADDR_LINE_3, \
S_ADDR_PER.ZIPCODE, \
S_ADDR_PER.CITY, \
S_ADDR_PER.COUNTRY, \
S_ADDR_PER.ADDR_NAME, \
S_ADDR_PER.STATE, \
S_ADDR_PER.ALIGNMENT_FLG, \
S_ADDR_PER.DISA_CLEANSE_FLG, \
S_ADDR_PER.NAME_LOCK_FLG, \
S_ADDR_PER.PREMISE_FLG, \
S_ADDR_PER.ACTIVE_FLG, \
S_ADDR_PER.ADDR_LINE_4, \
S_ADDR_PER.LOCATION_FLG, \
S_ADDR_PER.ALIGNMENT_FLG, \
S_ADDR_PER.DISA_CLEANSE_FLG, \
S_ADDR_PER.NAME_LOCK_FLG, \
S_ADDR_PER.PREMISE_FLG
FIXED COLUMN = ADDR_LOCATION_FLG, "N"
FIXED COLUMN = AP_ALIGNMENT_FLG, "N"
FIXED COLUMN = AP_DISACLEANSE_FLG, "N"
FIXED COLUMN = AP_NAME_LOCK_FLG, "N"
FIXED COLUMN = AP_PREMISE_FLG, "N"
[Import_Account]
TYPE = IMPORT
BATCH = 222
TABLE = EIM_ACCNT_CUT
ONLY BASE TABLES = S_PARTY, S_ORG_EXT, S_ACCNT_POSTN
INSERT ROWS = S_PARTY, TRUE
INSERT ROWS = S_ORG_EXT, TRUE
UPDATE ROWS = S_ORG_EXT, TRUE
USING SYNONYMS = FALSE
LOG TRANSACTIONS = FALSE
ONLY BASE COLUMNS = S_ORG_EXT.NAME, \
S_ORG_EXT.LOC, \
S_ORG_EXT.DESC_TEXT, \
S_ORG_EXT.X_CORR_NAME, \
S_ORG_EXT.X_END_DATE, \
S_ORG_EXT.X_PRES_NAME, \
S_ORG_EXT.X_SHORT_NAME, \
S_ORG_EXT.MAIN_PH_NUM, \
S_ORG_EXT.MAIN_FAX_PH_NUM, \
S_ORG_EXT.BU_ID, \
S_ORG_EXT.MASTER_OU_ID, \
S_ORG_EXT.ACCNT_FLG, \
S_ORG_EXT.ACTIVE_FLG, \
S_ORG_EXT.BUYING_GROUP_FLG, \
S_ORG_EXT.CG_DEDN_AUTH_FLG, \
S_ORG_EXT.CG_SVP_A_LOCK_FLG, \
S_ORG_EXT.CG_SVP_LOCK_FLG, \
S_ORG_EXT.CG_SVP_SKIP_FLG, \
S_ORG_EXT.CL_SITE_FLG, \
S_ORG_EXT.COURT_PAY_FLG, \
S_ORG_EXT.DISA_CLEANSE_FLG, \
S_ORG_EXT.EVT_LOC_FLG, \
S_ORG_EXT.FCST_ORG_FLG, \
S_ORG_EXT.FUND_ELIG_FLG, \
S_ORG_EXT.GOOD_STANDING_FLG, \
S_ORG_EXT.INCL_FLG, \
S_ORG_EXT.INT_ORG_FLG, \
S_ORG_EXT.PLAN_GROUP_FLG, \
S_ORG_EXT.PROSPECT_FLG, \
S_ORG_EXT.PRTNR_PUBLISH_FLG, \
S_ORG_EXT.PRTNR_FLG, \
S_ORG_EXT.RPLCD_WTH_CMPT_FLG, \
S_ORG_EXT.CONTRACT_VIS_FLG, \
S_ORG_EXT.SKIP_PO_CRDCHK_FLG, \
S_ORG_EXT.PR_POSTN_ID, \
S_ORG_EXT.ACCNT_TYPE_CD, \
S_ORG_EXT.BASE_CURCY_CD, \
S_ORG_EXT.BO_CUST_GRP_CD, \
S_ORG_EXT.INT_ORG_FLG, \
S_ORG_EXT.PRIVACY_CD, \
S_ORG_EXT.OU_TYPE_CD, \
S_PARTY.PARTY_UID, \
S_PARTY.PARTY_TYPE_CD, \
S_ACCNT_POSTN.OU_EXT_ID, \
S_ACCNT_POSTN.POSITION_ID, \
S_ACCNT_POSTN.ROW_STATUS
FIXED COLUMN = AC_ACCNT_FLG, "Y"
FIXED COLUMN = AC_ACTIVE_FLG, "Y"
FIXED COLUMN = AC_BUYINGGROUP_FLG, "N"
FIXED COLUMN = AC_CGDEDN_AUTH_FLG, "Y"
FIXED COLUMN = AC_CGSVPA_LOCK_FLG, "N"
FIXED COLUMN = AC_CG_SVP_LOCK_FLG, "N"
FIXED COLUMN = AC_CG_SVP_SKIP_FLG, "N"
FIXED COLUMN = AC_CL_SITE_FLG, "N"
FIXED COLUMN = AC_DISACLEANSE_FLG, "N"
FIXED COLUMN = AC_EVT_LOC_FLG, "N"
FIXED COLUMN = AC_FCST_ORG_FLG, "N"
FIXED COLUMN = AC_FUND_ELIG_FLG, "N"
FIXED COLUMN = AC_GOODSTANDINGFLG, "N"
FIXED COLUMN = AC_INCL_FLG, "N"
FIXED COLUMN = AC_INT_ORG_FLG, "N"
FIXED COLUMN = AC_PLAN_GROUP_FLG, "N"
FIXED COLUMN = AC_PROSPECT_FLG, "N"
FIXED COLUMN = AC_PRTNR_FLG, "N"
FIXED COLUMN = AC_PRTNRPUBLISHFLG, "N"
FIXED COLUMN = AC_RPLCDWTHCMPTFLG, "N"
FIXED COLUMN = SKIP_PO_CRDCHK_FLG,"N"
FIXED COLUMN = AC_COURT_PAY_FLG, "N"
FIXED COLUMN = CONTRACT_VIS_FLG, "N"
FIXED COLUMN = AC_ACCNT_TYPE_CD, "Klant"
FIXED COLUMN = AC_BASE_CURCY_CD, "EUR"
FIXED COLUMN = AC_BO_CUST_GRP_CD, "Afnemer"
FIXED COLUMN = AC_INT_ORG_FLG, "N"
FIXED COLUMN = PRIVACY_CD, "Terugtrekken: alle partijen"
FIXED COLUMN = AC_OU_TYPE_CD, "Klant"
[Import_Account_Address]
TYPE = IMPORT
BATCH = 333
TABLE = EIM_ADDR_PER
ONLY BASE TABLES = S_ADDR_PER, S_CON_ADDR
INSERT ROWS = S_ADDR_PER, FALSE
INSERT ROWS = S_CON_ADDR, TRUE
UPDATE ROWS = S_ADDR_PER, FALSE
USING SYNONYMS = FALSE
LOG TRANSACTIONS = FALSE
ONLY BASE COLUMNS = S_CON_ADDR.ADDR_TYPE_CD, \
S_CON_ADDR.ADDR_PER_ID, \
S_CON_ADDR.BU_ID, \
S_CON_ADDR.RELATION_TYPE_CD, \
S_CON_ADDR.ACCNT_ID, \
S_CON_ADDR.ACTIVE_FLG, \
S_CON_ADDR.BL_ADDR_FLG, \
S_CON_ADDR.CONTACT_ID, \
S_CON_ADDR.ORG_GROUP_ID, \
S_CON_ADDR.START_DT, \
S_CON_ADDR.FRAUD_FLG, \
S_CON_ADDR.MAIN_ADDR_FLG, \
S_CON_ADDR.SHIP_ADDR_FLG
FIXED COLUMN = CONADDR_ACTIVE_FLG, "N"
FIXED COLUMN = CONADDR_BLADDR_FLG, "N"
FIXED COLUMN = CONADDR_FRAUD_FLG, "N"
FIXED COLUMN = CONADDR_MAINADDRFL, "N"
FIXED COLUMN = CONADDR_SHIPADDRFL, "N"
[Import_Account_Primary_Address]
TYPE = Import
BATCH = $BatchRange
TABLE = EIM_ACCNT_CUT
ONLY BASE TABLES = S_PARTY, S_ORG_EXT, S_CON_ADDR
UPDATE ROWS = S_PARTY, FALSE
UPDATE ROWS = S_CON_ADDR, FALSE
UPDATE ROWS = S_ORG_EXT, TRUE
USING SYNONYMS = FALSE
LOG TRANSACTIONS = FALSE
ONLY BASE COLUMNS = S_PARTY.PARTY_UID, \
S_PARTY.PARTY_TYPE_CD, \
S_ORG_EXT.NAME, \
S_ORG_EXT.LOC, \
S_ORG_EXT.BU_ID, \
S_ORG_EXT.PR_ADDR_ID, \
S_CON_ADDR.ADDR_PER_ID, \
S_CON_ADDR.RELATION_TYPE_CD
This are my ctl files:
EIM_ACCNT_CUT.ctl:
LOAD DATA
--INFILE C:\temp\CVOM\TINSTANTIE.TXT
APPEND
INTO TABLE SIEBEL.EIM_ACCNT_CUT
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
( AC_NAME CHAR -- IDINST!
, BRICK_NAME CHAR -- NMINST1!
, AC_DESC_TEXT CHAR ":BRICK_NAME || ' ' || :AC_DESC_TEXT" -- NMINST2!
, X_PRES_NAME CHAR -- PRESNMINST!
, X_CORR_NAME CHAR -- CORRNMINST!
, X_SHORT_NAME CHAR -- AFKNMPK!
, C6 FILLER CHAR -- SNVADR
, C7 FILLER CHAR -- HNVADR
, C8 FILLER CHAR -- PCNVADR
, C9 FILLER CHAR -- PCAVADR
, C10 FILLER CHAR -- PLNVADR
, X_END_DATE DATE "YYYYMMDD" -- DTOPHINST!
, C12 FILLER CHAR -- IDNINST
, C13 FILLER CHAR -- SNPADR
, AP_PROD_NAME CHAR -- HNPADR!
, AP_PROD_VEN_NAME CHAR -- PCNPADR!
, AC_NAME_1 CHAR -- PCAPADR!
, AC_URL CHAR -- PLNPADR!
, PROD_BU CHAR -- PCPLNBUIT!
, PERIOD_BU CHAR -- IDPLAND!
, AC_MAIN_PH_NUM CHAR -- TELNRINST!
, C21 FILLER CHAR -- TLXNRINST
, AC_MAIN_FAX_PH_NUM CHAR -- FAXNRINST!
, C23 FILLER DATE "YYYYMMDD" -- DTINS
, C24 FILLER CHAR -- IDGEBRINS
, C25 FILLER DATE "YYYYMMDD" -- DTUPD
, C26 FILLER CHAR -- IDGEBRUPD
, IF_ROW_STAT CONSTANT 'FOR_IMPORT'
, IF_ROW_BATCH_NUM CONSTANT '100'
, PARTY_TYPE_CD CONSTANT 'Organization'
, PARTY_UID CHAR ":AC_NAME"
, AC_BU CONSTANT 'Default Organization'
, MASTER_ACCNT_BU CONSTANT 'Default Organization'
, MASTER_ACCNT_NAME CHAR ":AC_NAME"
, MASTER_ACCNT_LOC CONSTANT ''
, AP_POSTN_BU CONSTANT 'Default Organization'
, AP_POSTN_NAME CONSTANT 'Siebel Administrator'
, AP_POSTN_LOC CONSTANT 'INTERNE'
, AP_POSTN_DIVN CONSTANT 'Siebel Administration'
, ACC_PR_POSTN CONSTANT 'Y'
, ACC_PR_ADDR CONSTANT 'Y'
, AP_ROW_STATUS CONSTANT 'Y'
, AC_OU_TYPE_CD CONSTANT 'Instantie'
, ROW_ID SEQUENCE (max,1,1)
)
EIM_ADDR_PER.ctl:
LOAD DATA
--INFILE TINSTANTIE.TXT
APPEND
INTO TABLE EIM_ADDR_PER
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
( T_CON_ADDR_ACCNTI CHAR -- IDINST!
, C2 FILLER CHAR -- NMINST1
, C3 FILLER CHAR -- NMINST2
, C4 FILLER CHAR -- PRESNMINST
, C5 FILLER CHAR -- CORRNMINST
, C6 FILLER CHAR -- AFKNMPK
, C7 FILLER CHAR -- SNVADR
, C8 FILLER CHAR -- HNVADR
, C9 FILLER CHAR -- PCNVADR
, C10 FILLER CHAR -- PCAVADR
, C11 FILLER CHAR -- PLNVADR
, C12 FILLER DATE "YYYYMMDD" -- DTOPHINST
, C13 FILLER CHAR -- IDNINST
, AP_ADDR CHAR -- SNPADR!
, AP_ADDR_LINE_3 CHAR -- HNPADR!
, AP_ADDR_LINE_4 CHAR -- PCNPADR!
, AP_ADDR_LINE_5 CHAR -- PCAPADR!
, AP_CITY CHAR -- PLNPADR!
, AP_ADDR_LINE_2 CHAR -- PCPLNBUIT!
, AP_COUNTRY CHAR -- IDPLAND!
, C21 FILLER CHAR -- TELNRINST
, C22 FILLER CHAR -- TLXNRINST
, C23 FILLER CHAR -- FAXNRINST
, C24 FILLER DATE "YYYYMMDD" -- DTINS
, C25 FILLER CHAR -- IDGEBRINS
, C26 FILLER DATE "YYYYMMDD" -- DTUPD
, C27 FILLER CHAR -- IDGEBRUPD
, IF_ROW_STAT CONSTANT 'FOR_IMPORT'
, IF_ROW_BATCH_NUM CONSTANT '100'
, CONADDR_ACCNT_BU CONSTANT 'Default Organization'
, CONADDR_ACCNT_NAME CHAR ":T_CON_ADDR_ACCNTI"
, CONADDR_BU CONSTANT 'Default Organization'
, CONADDR_RELATIONTY CONSTANT 'ContactPointUsage'
, ROW_ID SEQUENCE (max,1,1)
, AP_ADDR_NAME SEQUENCE (max,1,1)