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

Last updated on NOVEMBER 03, 2022

Applies to:

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

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