My Oracle Support Banner

Unable to Import Orders using EIM_ORDER (Doc ID 2681417.1)

Last updated on FEBRUARY 05, 2021

Applies to:

Siebel CRM - Version 18.12 and later
Information in this document applies to any platform.

Symptoms

On : 18.12 version, EIM

Unable to import orders using EIM_ORDER


ERROR
-----------------------

Process [ORDER] had 2 rows fail on EIM_ORDER for batch 399 in step 4, pass 190: Failed to resolve foreign key value. (severity 7)

Interface table: EIM_ORDER (EIM_ORDER)
REP_POSTN_BI (Name)
REP_POSTN_DIVN (Name)
REP_POSTN_LOC (Site)
REP_POSTN_NAME (Name)

Base table:

S_ORDER_POSTN (Position Order Credit)
POSTN_ID (Position Id)

This is a foreign key value in the base table and the values in the interface. Table did not resolve to existing values. Verify that the IF columns correspond to existing base table rows.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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