Using EIM_PREV_MAINT to populate Administration - Preventive Maintenance / Producs View "FS PM Plan Item Products View" but EIM table has no Foreign Key Mapping for FS PM Plan Item - Asset Connector BC Parent Connector Id field. (Doc ID 2094691.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.11 [IP2013] version, EIM

ACTUAL BEHAVIOR
---------------
Vanilla EIM Table is missing a foreign key mapping for a table that it maps into??
How can we populate this foreign key via EIM?

Base Table: S_PM_APPL_ASSET
Eim Table: EIM_PREV_MAINT
Parent: Product, Child - Assets, both are mapped to same base table
Attached the IFB file and view screen shots.

EXPECTED BEHAVIOR
-----------------------
Vanilla EIM_PREV_MAINT should have a mapping for this
The EIM Table Mapping wizard if run for this table or others for S_PM_APPL_ASSET does not create this foreign key mapping either.

Cause

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