How To Load S_ISS_OBJ_ATTR Table Via EIM? EIM_ASSET1 Table Mapping for S_ATTR_XA has a Foreign Key Mapped to S_XA_ASSET, but that Column has ROW_ID for S_ISS_OBJ_ATTR Table? (Doc ID 2050400.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 8.1.1.11.16 [IP2013] and later
Information in this document applies to any platform.

Goal

There is a question on a EIM_ASSET1's mapping to to the S_ASSET_XA foreign key column ATTR.

EIM_ASSET1 is being used to bring in assets for a product that has attributed.

EIM_ASSET1 does have a table mapping for S_ASSET_XA, and there is a foreign key mapping for ATTR_ID that should be a foreign key to S_XA_ATTR.
In the repository, the S_ASSET_XA table column definition shows the foreign key column ATTR_ID for S_XA_ATTR.  However, the table S_ASSET_XA does not have any data?  After lots of digging around, we found that the ATTR_ID column in table S_ASSET_XA resolves to ROW_ID of S_ISS_OBJ_ATTR table.

Does this mean that the EIM_ASSET1 table's foreign key mapping to S_XA_ATTR is incorrect then?

If this is true, how can we populate ATTR_ID via EIM since there is no EIM mapping to S_ISS_OBJ_ATTR table?
 

Solution

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