Datafix : How to Recreate Missing Receipt or Shipment Header Records (RCV_SHIPMENT_HEADERS table)

(Doc ID 371105.1)

Last updated on MAY 22, 2017

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



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


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