The Visibility on the "All Accounts" View does not Show Accounts Created with EIM, Can't See Account Records Created with EIM, EIM_FN_ACCNT1? EIM Example to Load Accounts. (Doc ID 534244.1)

Last updated on MARCH 09, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2.4 [18365] to 15.3 [IP2015] [Release V7 to V15]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.2.4 [18365]
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.


Symptoms

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.

[Import Accounts]
      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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms