Siebel EIM > EIM Error during import Accounts and their respective Addresses into Siebel SIA
EIM Error during import Accounts and their respective Addresses into Siebel SIA
Requirement: Could you provide the EIM configuration necessary to load an account and an address, associate the address with the account, and set the address as the primary for the account?
Siebel Enterprise Integration Manager - Version 7.8.2 SIA [19213] and later
SOLUTION
The steps which need to performed are as follows: 1. Load Accounts (S_ORG_EXT) via EIM_ACCOUNT Include S_ORG_BU, S_ACCNT_POSTN for visibility reasons 2. Update the S_ORG_EXT.MASTER_OU_ID of the Accounts loaded in step 1. via EIM_ACCNT_CUT Reason: Visibility Note: The S_ORG_EXT.MASTER_OU_ID column maps to the following columns in the EIM_ACCNT_CUT Interface Table: MASTER_ACCNT_BU MASTER_ACCNT_NAME MASTER_ACCNT_LOC 3. Import the Addresses via EIM_ADDR_PER Note: Also populate the EIM_ADDR_PER columns CONADDR_ACCNT_BU, CONADDR_ACCNT_LOC, CONADDR_ACCNT_NAME which map to the Foreign Key S_CON_ADDR.ACCNT_ID to reference the Account records (S_ORG_EXT) loaded in steps 1./2. 4. Set the Primary Addresses (S_ORG_EXT.PR_ADDR_ID) for the Accounts loaded in 1./2. by setting the EIM_ACCNT_CUT.ACC_PR_ADDR flag to 'Y'
Process Examples > Visibility of Fields: Example of Importing Accounts
The corresponding IFB-Files (in its simplest forms) are shown below: For step 1: [Siebel Interface Manager] USER NAME = "SADMIN" PASSWORD = "SADMIN" PROCESS = ImportAccounts [ImportAccounts] BATCH = 100 TYPE = IMPORT TABLE = EIM_ACCOUNT ONLY BASE TABLES = S_PARTY, S_ACCNT_POSTN, S_ORG_BU, S_ORG_EXT For step 2: [Siebel Interface Manager] USER NAME = "SADMIN" PASSWORD = "SADMIN" PROCESS = UpdateMasterOUID [UpdateMasterOUID] BATCH = 100 TYPE = IMPORT TABLE = EIM_ACCNT_CUT ONLY BASE TABLES = S_PARTY, S_ORG_EXT For step 3: [Siebel Interface Manager] USER NAME="SADMIN" PASSWORD="SADMIN" PROCESS = ImportAddresses [ImportAddresses] TYPE = IMPORT BATCH = 100 TABLE = EIM_ADDR_PER ONLY BASE TABLES = S_ADDR_PER, S_CON_ADDR For step 4: [Siebel Interface Manager] USER NAME = "SADMIN" PASSWORD = "SADMIN" PROCESS = UpdatePrimAddr [UpdatePrimAddr] BATCH = 100 TYPE = IMPORT TABLE = EIM_ACCNT_CUT ONLY BASE TABLES = S_PARTY, S_CON_ADDR, S_ORG_EXT
The following Bugs have been raised: 10527588: EIM_ACCNT_CUT.ACC_PR_ADDR not included in EM Interface Table Report 10527531: EIM Interface Table Report (EIM_ACCNT_CUT) Mapping to S_ORG_EXT.MASTER_OU_ID is incorrect 10527530: The EIM Interface Table Report contains S_ADDR_PER although it is set to inactive in Siebel Tools 10527519: Inactive Columns are shown in the EIM Interface Table Report 10527454: Interface Table column EIM_ACCOUNT.ACC_PR_ADDR not contained in EIM Interface Table Report
The following changes to the EIM_ACCOUNT interface table mappings are implemented in Siebel Industry Applications (SIA) version 7.7 and later :
- The interface columns corresponding to the following base columns are inactivated in the EIM_ACCOUNT interface table. These columns were required in Siebel 7.5.x:
- BUYING_GROUP_FLG
- CG_DEDN_AUTH_FLG
- CG_SVP_A_LOCK_FLG
- CG_SVP_LOCK_FLG
- CG_SVP_SKIP_FLG
- CL_SITE_FLG
- GOOD_STANDING_FLG
- INCL_FLG
- PRTNR_FLG
- PRTNR_PUBLISH_FLG
- ACCNT_FLG
- COURT_PAY_FLG
- FUND_ELIG_FLG
- PLAN_GROUP_FLG
- CONTRACT_VIS_FLG
The interface columns corresponding to the MASTER_OU_ID column must be populated to ensure visibility in the user interface.
- The interface table mapping to the S_ADDR_PER base table is no longer available. These changes have been introduced to address table size limitation and performance issues raised in prior versions.
Change Requests 12-OVVFMM and 12-OOZL7Y have been logged to include this information in the documentation.
OCCURRENCE
The changes are applicable if you use the EIM_ACCOUNT interface table to import data in Siebel Industry Applications version 7.7 and later.
SYMPTOMS
The indicated columns and mappings are no longer available in the EIM_ACCOUNT interface table in Siebel Industry Applications version 7.7.
WORKAROUND
The corresponding interface table mapping to the S_ADDR_PER base table is available in the EIM_ADDR_PER interface table. The corresponding interface columns for the inactivated base columns are available in the EIM_ACCNT_CUT interface table. Populate the MASTER_OU_ID base column using the EIM_ACCNT_CUT, EIM_FN_ACCNT1, or EIM_FN_ACCNT4 interface tables.
The following is a sample SQL script and .ifb file for importing an account record using the EIM_ACCNT_CUT interface table:
- Sample SQL statement for inserting a record into the EIM_ACCNT_CUT interface table:
INSERT INTO EIM_ACCNT_CUT (ROW_ID, IF_ROW_BATCH_NUM, IF_ROW_STAT, PARTY_UID, PARTY_TYPE_CD, AC_BU, AC_LOC, AC_NAME, AP_POSTN_BU, AP_POSTN_DIVN, AP_POSTN_LOC, AP_POSTN_NAME, AP_ROW_STATUS , MASTER_ACCNT_BU, MASTER_ACCNT_NAME, MASTER_ACCNT_LOC, AC_ACCNT_TYPE_CD, AC_CUST_STAT_CD, AC_OU_TYPE_CD, AC_OU_NUM, AC_ACCNT_FLG, AC_ACTIVE_FLG, AC_BUYINGGROUP_FLG, AC_CGDEDN_AUTH_FLG, AC_CGSVPA_LOCK_FLG, AC_CG_SVP_LOCK_FLG, AC_CG_SVP_SKIP_FLG, AC_CL_SITE_FLG, AC_COURT_PAY_FLG, AC_DISACLEANSE_FLG, AC_EVT_LOC_FLG, AC_FCST_ORG_FLG, AC_FUND_ELIG_FLG, AC_GOODSTANDINGFLG, AC_INCL_FLG, AC_INT_ORG_FLG, AC_PLAN_GROUP_FLG, AC_PROSPECT_FLG, AC_PRTNRPUBLISHFLG, AC_PRTNR_FLG, AC_RPLCDWTHCMPTFLG) VALUES('1',555,'FOR_IMPORTED','ABC TEST 20','Organization', 'Default Organization', 'Boston', 'ABC TEST 20', 'Default Organization', 'Siebel Administration', 'INTERNAL', 'Siebel Administrator', 'N', 'Default Organization', 'ABC TEST 20', 'Boston', 'Customer', 'Active', 'Customer', 'ABC TEST 20', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')
[Siebel Interface Manager] USER NAME = "SADMIN" PASSWORD = "SADMIN" PROCESS = Import Account [Import Account] TYPE = IMPORT BATCH = 555 TABLE = EIM_ACCNT_CUT ONLY BASE TABLES = S_PARTY, S_ACCNT_POSTN, S_ORG_EXT
NOTE: In order to view this record in the All Accounts view, a corresponding record should be inserted into the S_ORG_BU base table. You can do this by using the EIM_ACCOUNT interface table.
|