Bookshelf Home | Contents | Index | PDF |
Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > Other Examples > Example of Adding a Position to a Party TableThis example shows how positions are added to party tables, such as Account, Contact, and Employee. You are adding positions to the Account table. You can use the EIM_ACCOUNT table to populate S_ACCNT_POSTN, which is an intersection table between Accounts and Position. In the S_ACCNT_POSTN table, you provide information about the position you are trying to add (POSITION_ID) and the account you are trying to associate with the position (OU_EXT_ID). In the EIM_ACCOUNT table, you provide information about the account. To populate the EIM table, you must always include the target base table: in this case, S_PARTY. Since EIM_ACCOUNT is for account information, S_PARTY should also be filled with account information. So you set the S_PARTY.PARTY_TYPE_CD = 'Organization' since Account belongs to the Organization type. (PARTY_TYPE_CD = 'Person' is only used for Contact, User, Employee, or Partner.) The .IFB file looks like this: ONLY BASE TABLES = S_PARTY, S_ACCNT_POSTN INSERT ROWS = S_ORG_EXT, FALSE |
Siebel Enterprise Integration Manager Administration Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |