Supplier Merge Not Updating Receiving Tables
Last updated on MAY 18, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms