Import User Defined Attributes Process Fails If ORIG_SYS_LINE_REF Is Not Unique In The Data Set
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.
On : 12.2.6 version, Transaction Entry
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.
Both Oracle products must use the same criteria for the fields uniqueness.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms