My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2019

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.