Wrong Order Of Processing On Mtl_transaction_interface WIP Completion, Batch Sequence (Doc ID 2070064.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Work order transactions process in the wrong order using the transaction interface (MTL_TRANSACTIONS_INTERFACE).

Expected Behavior
The transaction with Final completion flag 'Y' should process last.
Need to have transaction processed in the correct order to avoid issue with costing.

Steps
1. Populate mtl_transaction_interface table for work order completions. let say we have work order 'A' with start quantity 3,and we complete 3 quantity on a work order
2. Insert 3 rows in mtl_transactions_interface as below for work order 'A'
Transaction1-with Final completion flag ‘N’
Transaction2 with Final completion flag’ N’-
Transaction3 with Final completion flag ‘Y’

3. All these records exist in our MTI table at same time Our transaction manager will process these records one by one.
* The issue happens when we have transactions above in our table and transaction manger process them in a wrong sequence.i.e transaction with final completion falg 'Y' processed before the transaction with Final completion flag 'N'

Business Impact
If the final completion transacts before early completions, then messes up the costing of the WIP job.

Cause

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