My Oracle Support Banner

Supplier Merge Not Updating Receiving Tables (Doc ID 795686.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.


After running the Supplier Merge program in Payables, invoices cannot be matched to Purchase Orders (POs) with the new Suppliers.
It is found that the rcv_shipment_headers and rcv_transactions tables are not updated with the supplier information.

Expect that receiving data will also get updated when supplier merge is run.

The issue can be reproduced at will with the following steps:
1. Purchasing>Supply Base> Supplier Merge.
2. Payables>Invoices > Entry > Invoices >Entered PO # at invoice header
3. Click Match > Supplier and PO details auto populated into the find window.
4. Click FIND > FRM-40350: Query caused no records to be retrieved

The issue has the following business impact:
Due to this issue, users do not have correct information for the suppliers on the invoice.


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

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