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 FEBRUARY 18, 2020
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 populates the EBS Import User Defined Attributes tables using a custom process.
The Import User Defined Attributes process fails with error message:
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.
A test case was performed 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.
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