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

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

 

Solution

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