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?
Last updated on MARCH 02, 2017
Applies to:Siebel Enterprise Integration Manager - Version 126.96.36.199.16 [IP2013] and later
Information in this document applies to any platform.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms