My Oracle Support Banner

MERGE: ERROR The value for the orig_system+orig_system_reference+owner_table_id column is not found in the HZ_ORIG_SYS_REFERENCES (Doc ID 2430307.1)

Last updated on MAY 20, 2020

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On R12, version, Data Quality Management

Account Merge failed with following error

ERROR
-----------------------
MSG-00001: MOSR:remap internal id ERROR The value for the orig_system+orig_system_reference+owner_table_id column is not found in the HZ_ORIG_SYS_REFERENCES table.**remap internal id**
MSG-00001: ARP_CMERGE_ARCUS.RA_SU : User-Defined Exception
MSG-00001: ARP_CMERGE_MASTER.merge_customers : User-Defined Exception


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Receivables Manager/ Trading community Manager
2. Navigate to Account merge
3. Select From and To account, run Merge

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 4. Solution Steps
References


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