My Oracle Support Banner

Inventory Transaction Workers Process Interface Records In The Wrong Sequence Even Though Transaction_Batch_Id And Transaction_Batch_Seq Are Populated (Doc ID 2826390.1)

Last updated on MARCH 19, 2024

Applies to:

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

Symptoms

Inventory transaction workers are processing interface records in the wrong order when there are a lot of records inserted from the Interface (Mtl_Transactions_Interface) with the Transaction_Batch_Id and Transaction_Batch_Seq. 

STEPS
1. Insert around 1000 records into MTI (Mtl_Transactions_Interface) with more than 200 records with the same Transaction_Batch_Id.
2. Review batch size on Inventory > Setup > Transactions > Interface Managers > Material transaction manager > See Number of rows 200
3. Tools > Launch > See 'Submit request' form appears for request : "Process transaction Interface" (Inventory Manager)> Schedule concurrent request 
4. See that same Batch id and Batch sequence records are assigned to different workers.

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.