My Oracle Support Banner

Two Intercompany Sales Orders Missing From AR Interface Table (Doc ID 2525445.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Two shipped and received intercompany sales orders are missing from the ra interface table.

Records were deleted from Ra_interface_lines_all PRIOR to the execution of the Auto_Invoice primary program.

Request a datafix to repopulate the Ra_interface_lines_all table.

 

 

1) select * from mtl_material_transactions where transaction_id in (-- insert transaction_ids here);
-- Expect for this query to return records

2) SELECT * FROM ra_interface_lines_all RCTL
WHERE RCTL.interface_line_attribute7 IN (SELECT To_Char(transaction_id) FROM
mtl_material_transactions
WHERE transaction_id in (-- insert transaction_ids here));

-- Must validate that this query does not return rows

 

3) SELECT * FROM ra_customer_trx_lines_all RCTL
WHERE RCTL.interface_line_attribute7 IN (SELECT To_Char(transaction_id) FROM
mtl_material_transactions
WHERE transaction_id in (-- insert transaction_ids here));

-- Must validate that this query does not return rows

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
References


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