Facing Issue While Loading Data Into SIEBEL S_MDF_ACCRUAL Table Using SIEBEL EIM_MDF Table. (Doc ID 2155383.1)

Last updated on JUNE 29, 2016

Applies to:

Siebel CRM - Version 15.7 [IP2015] and later
Information in this document applies to any platform.

Symptoms

After completion of SIEBEL EIM process the status of IF_ROW_STAT for all records is showing PARTIALLY_IMPORTED in SIEBEL EIM_MDF table for
INSERT/UPDATE process on SIEBEL S_MDF_ACCRUAL. and for delete process we are getting NO_SUCH_RECORD error.

even though populating all the required user key columns and foreign key columns we are getting the above error.
We found new mapping between ROW_ID column of SIEBELS_MDF_ACCRUAL to ACCR_ROW_ID column of SIEBEL EIM_MDF table
and after populating row_id for one of the existing record UPDATE process is working fine.
and after populating some dummy value into row_id column for new record the INSERT process is working fine.
and after populating the ROW_ID of deleting record delete process was fine.
we find it as product defect since ACCR_ROW_ID is not map to any of the user keys of S_MDF_ACCRUAL and its not marked
as mandatory column as well in EIM_MDF table.Hence could you please provide defect details if any else please created defect on the same.

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