My Oracle Support Banner

Internal Sales Orders with Brazilian Localizations Creates Duplicate Lines in A/R Interface table (Doc ID 2605224.1)

Last updated on JANUARY 06, 2025

Applies to:

Oracle Order Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to Interface order lines to Receivables, two lines are created in ra_interface_lines when only one record should be created. The following error appears in RA_INTERFACE_ERRORS:



ERROR
-----------------------

This row has the same flexfield as the transaction as another row in the interface table. For each transaction line, the combination of interface_line_context and interface_line_attribute values must be unique.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create an internal Requisition
2. Import the IR into an internal sales order
3. Pick release and ship confirm the delivery
4. All requests from Create Internal Orders to Interface Trip Stop  completed successfully
5. Review data in RA_INTERFACE_LINES,  see that two duplicate records were created for the one line that was interfaced to A/R

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
Cause
Solution
References


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