Supplier Merge Not Updating Receiving Tables (Doc ID 795686.1)

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.

Symptoms

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.

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

STEPS
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

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms