Last updated on MARCH 09, 2017
Applies to:Siebel Enterprise Integration Manager - Version 188.8.131.52  to 15.3 [IP2015] [Release V7 to V15]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 184.108.40.206 
Reviewed for relevance "11-SEP-2015".
Database: IBM DB2 8.2
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: IBM AIX 5L 5.2
This document was previously published as Siebel SR 38-3003695261.
I'm trying to load account data using EIM_FN_ACCNT1 table, to the following base tables:
S_PARTY, S_ACCNT_POSTN,S_ORG_EXT, S_ORG_BU, S_PARTY_PER
I based the mapping columns on the article "Visibility of Fields: Example of Importing Accounts".
Here are the columns I'm using on EIM_FN_ACCNT1:
ROW_ID ,IF_ROW_STAT ,IF_ROW_BATCH_NUM ,PARTY_UID ,PARTY_TYPE_CD ,GROUP_TYPE_CD ,PARTY_UID1 ,PARTY_TYPE_CD1 ,START_DT ,ACC_ACCNT_FLG , ACC_ACTIVE_FLG , ACC_BUYINGGROUPFLG , ACC_CL_SITE_FLG , ACC_COURT_PAY_FLG ,ACC_DISACLEANSEFLG ,ACC_EVT_LOC_FLG , ACC_FCST_ORG_FLG , ACC_FUND_ELIG_FLG , ACC_INT_ORG_FLG , ACC_PLAN_GROUP_FLG ,ACC_PROSPECT_FLG , ACC_RPLCDWTHCMPTFL ,ORG_BU ,ACC_BU ,ACC_LOC ,ACC_NAME , NAME ,MASTER_ACCNT_BU ,MASTER_ACCNT_LOC ,MASTER_ACCNT_NAME ,ACC_OU_NUM ,ROOT_PARTY_FLG,POS_ROW_STATUS,POS_POSTN_NAME,POS_POSTN_LOC,POS_POSTN_DIVN,POS_POSTN_BU,ACC_CUST_STAT_CD,ACC_OU_TYPE_CD
Here is one record (CSV type) (There is a record already imported in S_Party "+B9+1189'
1234,FOR_IMPORT,2000,FICTICUS_NAME,Organization,1+B9+1189,Person,2006-01-16-00.00.00,Y,Y,N,N,N,N,N,N,N,N,N,N,N,Default Organization,Default Organization,,FICTICUS_NAME,Default Organization,,FICTICUS_NAME,FICTICUS_NAME2,N,N,TEST POSITION,INTERNAL,Siebel Administration,Default Organization,Active,Customer
Here the .ifb file.
TYPE = IMPORT
BATCH = 2000 - 2200
TABLE = EIM_FN_ACCNT1
COMMIT EACH TABLE = TRUE
COMMIT EACH PASS = FALSE
NET CHANGE = FALSE
USE INDEX HINTS = FALSE
USE ESSENTIAL INDEX HINTS = FALSE
ONLY BASE TABLES = S_PARTY, S_ACCNT_POSTN,S_ORG_EXT, S_ORG_BU, S_PARTY_PER
The import does not work, because I cannot see the new Account records in the "All Accounts" view.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms