EIM Import to Populate Custom Fkey ( Foreign Key ) Fail with SBL-EIM-00205, Error SBL-EIM-00999: IF Table has Cyclic Dependencies (Doc ID 2125033.1)

Last updated on JULY 01, 2023

Applies to:

Symptoms

On : 8.1.1.14.13 [IP2014] version, EIM

ACTUAL BEHAVIOR
---------------
Unable to load data in table S_WRNTY_CLAIM

We are unable to load the data in S_WRNTY_CLAIM siebel base table through EIM. We are getting error "Failed to load the application dictionary". We have generated detailed log file by increasing EIM Component log level to 5 and setting the below flags while triggering IFB:

Error Flags: 1
Trace Flags: 1
SQL Trace Flags: 8

This error started happening after we used the EIM Table Mapping Wizard to automatically add new column mappings for custom S_WRNTY_CLAIM extension columns that are defined as foreign key columns to S_WRNTY_CLM_IT.

Why is this error happening? What does the "cyclic dependencies" error mean? 

Note, that if EIM_WRNTY_CLM does not have custom mappings created by the EIM Table Mapping Wizard, this error does not happen.

Our business requirements need to populate the custom S_WRNTY_CLAIM fkey columns to the child S_WRNTY_CLM_IT table. 

The detailed log file shows the error below..

"Error SBL-EIM-00999: IF table EIM_WRNTY_CLM has cyclic dependencies (at S_WRNTY_CLAIM)!
Error SBL-EIM-00205: Failed to load the application dictionary."

EIMError EIMErrorSubEvent 0 00000006570315e8:0 2016-04-05 16:50:44 Error SBL-EIM-00999: IF table EIM_WRNTY_CLM has cyclic dependencies (at

EIMError EIMErrorSubEvent 0 00000006570315e8:0 2016-04-05 16:50:44 S_WRNTY_CLAIM)!

EIMError EIMErrorSubEvent 0 00000006570315e8:0 2016-04-05 16:50:51

EIMError EIMErrorSubEvent 0 00000006570315e8:0 2016-04-05 16:50:51 Error SBL-EIM-00205: Failed to load the application dictionary.

GenericLog GenericError 1 00000006570315e8:0 2016-04-05 16:50:51 (compmain.cpp (1565) err=65741 sys=0) SBL-EIM-00205: Failed to load the application dictionary.

GenericLog GenericError 1 00000006570315e8:0 2016-04-05 16:50:51 (smisched.cpp (923) err=65741 sys=0) SBL-EIM-00205: Failed to load the application dictionary.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.