My Oracle Support Banner

Generic Receiving Datafix Scripts and Root Cause Patches (Doc ID 601639.1)

Last updated on AUGUST 19, 2021

Applies to:

Oracle Inventory Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


What are the supported Generic Receiving Datafix Scripts and Root Cause Patches that are available for Receiving?


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
 List of Generic Receiving Datafix Scripts and Root Cause Patches available for Receiving:
 1. Missing Item Revision for Shipment Lines
 2. Missing Shipment Supply
 3. Fractional Quantities Remain in the Supply Tables (rcv_supply, mtl_supply)
 4. Intransit shipments (InterOrg Transfers or Internal Orders) cannot be transacted in destination/receiving inventory organization
 5. Some records in rcv_transactions have a null locator_id
 6. Receiving Transactions Show Wrong User (created_by and last_updated_by)
 7. N/A <Internal_Only> Incorrect Receipt Source Code</Internal_Only>
 8. Missing Receipt or Shipment Header Records (RCV_SHIPMENT_HEADERS table)
 9. WMS cleanup script
 10. Incorrect Primary and Source Doc Qty
 11. Null Employee Id on Some Receiving Transactions
 12. Null Vendor Site Id on Some Receiving Transactions
 13. Interorg Shipments and/or Internal Sales Order shipments which are completed successfully cannot be received as the Receiving shipment data is missing/not created.
 14. Missing RECEIVING supply in mtl_supply
 15. Missing RECEIVING supply in rcv_supply
 16. Shipment header id corrupted in RCV tables for ISO/IOT shipments
 17. Unordered receipt transactions exist under IOT/ISO
 18. Incorrect RMA line in RCV tables for split rma lines
 19. Missing SHIPMENT/RECEIVING serials supply in RSS
 20. Incorrect category stamped on RMA receipts
 21. Orphan Receipt or Shipment Header records exist (rcv_shipment_headers)
 22. Receipt_num is not stamped on Receipt Shipment Header when automatic receipt generation is setup
 23. Records in RCV_TRANSACTIONS_INTERFACE are not visible on Transaction Status Summary Form
 24. Corrupted ASN Shipment Supply in MS
 25. Cancel the work confirmation
 26. DropShip POs transactions in LCM Org Stuck as LC_PENDING or LC_INTERFACED
 27. Drop unwanted supply from MS & RS
 28. Remove item description's special characters in shipment line
 29. Incorrect organization_id in RCV_SHIPMENT_HEADERS
 30. Delete RCV specific orphan MTLI and MSNI records
 31. Delete the errored timecard receipts and corrections from receiving interface tables
 32. PO line corruption
 33. Purge successful RHI
 34. Organization corrupted for Return orders without documents 
 35. RTI records from LCM have not null secondary columns populated though the item is not tracked in dual uom
 36. Duplicate receipt numbers in Receipts Headers for a receipt organization  
 37. Missing secondary UOM&qty in RCV tables for DUAL UOM controlled item 
 38. Resubmit pending and remove orphan RTI of ISO/IOTNEW
 39. Incorrect destination_type_code for RETURN TO RECEIVING txn in rcv_transaction
 40. Supplier/supplier site info are not changed in RSH,RT after running Supplier merge program
 41. Incorrect REQ supply data in mtl_supply after the creation of Internal Intransit shipments
 42. PO putway failed in WMS org for multiple expiration dates in RLS

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