Configuring Siebel Business Applications > Transferring Data Between Databases > Mapping a Custom Table to an Interface Table >

Starting the EIM Table Mapping Wizard for a Table That Does Not Use the Foreign Key

To start the EIM Table Mapping Wizard for a Siebel base table that does not use the foreign key as part of the user key, you must create a temporary column and then run the wizard. For more information, see Article ID 507151.1 on My Oracle Support.

To start the EIM Table Mapping Wizard for a table that does not use the foreign key

1. Create a temporary column. Use properties described in the following table.

   Property	Value
   Inactive	Contains a check mark.
   User Key Sequence	<> NULL
   Foreign Key Table Name	Choose the target table for the interface table. NOTE:  In many but not all situations, this table is the parent table of the temporary column.

2. Run the EIM Table Mapping Wizard.

   By creating the temporary column, The EIM Table Mapping Wizard lists predefined EIM interface tables that are already mapped to this table as the target or destination table. The wizard also lists EIM tables that are mapped to tables with which this table uses a foreign key. However, the foreign key must be part of the Traditional U1 Index user key of this table.

   For more information, see Mapping a Custom Table to an Interface Table.

3. After the EIM Table Mapping Wizard finishes, delete the column you created in Step 1.