My Oracle Support Banner

Supplier Merge Not Updating Receiving Tables (Doc ID 795686.1)

Last updated on FEBRUARY 28, 2019

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

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
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.