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