My Oracle Support Banner

Import User Defined Attributes Process Fails If ORIG_SYS_LINE_REF Is Not Unique In The Data Set (Doc ID 2375815.1)

Last updated on APRIL 13, 2018

Applies to:

Oracle Order Management - Version 12.2.6 to 12.2.7 [Release 12.2]
Oracle Order Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Customer is implementing Oracle ERP Cloud and needs to integrate with their current instance of EBS Order Management.

Customer extracts the data from the ERP Cloud tables and populate the EBS Import User Defined Attributes tables using a custom process.

The Import User Defined Attributes process fails with error message:
Entity: ONT_EXTFWK_USER_ATTRS. Row Identifier: 5192. Entity index: 1.
Table Name: OE_LINES_EXT_IFACE_ALL.
For the attribute group OPE SO Line in the data set , more than one logical rows are mapped to the same table row.

The error occurs because on EBS Order Management the field ORIG_SYS_LINE_REF needs to be unique while on ERP Cloud this restriction does not exist.

Customer performed a test case making the field unique by concatenating ORIG_SYS_DOCUMENT_REF with the original value of ORIG_SYS_LINE_REF and the Import User Defined Attributes completed successfully.

EXPECTED BEHAVIOR
-----------------------
Both Oracle products must use the same criteria for the fields uniqueness.

STEPS
-----------------------
1. Extract the data from the ERP Cloud tables and populate the EBS Import User Defined Attributes tables (using a custom process).
2. Execute process Import User Defined Attributes
3. Process fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, cannot transfer the Sales Orders from ERP Cloud tables to EBS Order Management with the same information,
the only way is to manipulate the data to be accepted in Order Management.

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!


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