Datafix : How to Recreate Missing Receipt or Shipment Header Records (RCV_SHIPMENT_HEADERS table)
(Doc ID 371105.1)
Last updated on JULY 09, 2024
Applies to:
Oracle Inventory Management - Version 11.5.1 to 12.2.4 [Release 11.5 to 12.2]Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVRCVRC.FMB - View Receiving Transactions
Form:RCVTXERT.FMB - Enter Receiving Transactions
Form:RCVTXERE.FMB - Enter Returns
Form:RCVTXECO.FMB - Enter Corrections
IDENT_MISSING_RSH_FOR_ASN_ASBN.sql
RSH_FOR_ASN_ASBN.sql
IDENT_MISSING_RSH_FROM_RSL.sql
RSH_FROM_RSL_ONLY.sql
Goal
Records in RCV_SHIPMENT_HEADERS table may have been deleted when transactions were processed using the following:
Receiving Open Interface functionality (including receiving data populated via Electronic Data Exchange (EDI) and 3rd Party software)
-or- iSupplier Portal
-or- Warehouse Management Systems (WMS) Mobile Applications
-or- Mobile Supply Chain Applications (MSCA)
-or- iProcurement
-or- Field Services Portal
This datafix will recreate the missing Receipt Header (or Shipment Header) records in RSH rcv_shipment_headers table.
Users may see this error when searching for the known receipt number in the Receiving Transactions Summary form:
Users may not see any receipt when searching for the receipt from the PO Summary Form:
Solution
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
| Goal |
| Solution |
| References |