My Oracle Support Banner

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.

Symptoms

Problem Statement

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:

QUANTITY_SHIPPED = QUANTITY_RECEIVED
SHIPMENT_LINE_STATUS_CODE = FULLY RECEIVED
SOURCE_DOCUMENT_CODE = REQ

but in PO_REQUISITION_LINES_ALL (PRL) table

QUANTITY_DELIVERED = 0

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

SOURCE_DOCUMENT_CODE = PO
DESTINATION_TYPE_CODE = INVENTORY
REQUISITION_LINE_ID = Not NULL
REQ_DISTRIBUTION_ID = Not NULL

The issue may also occur for Intransit Inter organization shipment

Cause

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
Symptoms
Cause
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.