Unordered Receipt Transactions exist For Intransit Inter Org Shipment / Internal Sales Order IOT/ISO
(Doc ID 797705.1)
Last updated on JUNE 01, 2016
Applies to:Oracle Inventory Management - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Find some unordered Receipt Transactions exist For Intransit Inter Org Shipment / Internal Sales Order IOT/ISO.
For instance find for one Internal Requisition number all the shipment lines have a FULLY RECEIVED status but no receipt transactions can be seen in mtl_material_transactions table.
In RCV_SHIPMENT_LINES (RSL) table all records have:
SHIPMENT_LINE_STATUS_CODE = FULLY RECEIVED
SOURCE_DOCUMENT_CODE = REQ
but in PO_REQUISITION_LINES_ALL (PRL) table
and no records with RECEIVE or DELIVER type can be found in rcv_transactions table
On the contrary, records exist with UNORDERED transaction_type for the requisition lines but they have incorrect
DESTINATION_TYPE_CODE = INVENTORY
REQUISITION_LINE_ID = Not NULL
REQ_DISTRIBUTION_ID = Not NULL
The issue may also occur for Intransit Inter organization shipment
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