My Oracle Support Banner

How to Check the Move Order Status of Pending Transactions (Allocations) Show in Pending Transactions Form (Doc ID 1370430.1)

Last updated on JANUARY 24, 2019

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Oracle Warehouse Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
INVTOTRX, INVTVTMP, MTL_TXN_REQUEST_LINES, MTL_MATERIAL_TRANSACTIONS_TEMP, Pending Transaction, Transact Move Orders

Goal

It happens sometimes that allocated move order material is shown in the Pending Transactions form but the Move Order cannot be queried, hence processed, in the Transact Move Orders form.

This document has checks for Move Order transactions shown as Allocated in Pending Transactions and how to process the allocations for each status. This note will also provide helpful information on processing all Move Order Allocations seen in the Pending Transactions 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
 Query to check the Move Orders status for Pending Transactions resulting of MO allocations:
 Depending on the MO_Line_Status (Move Order Line) take the following actions:
References

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