Stuck Pending Transactions Were Resubmitted on the Pending Transaction Form, Now There are Duplicated Transactions
(Doc ID 2835702.1)
Last updated on JANUARY 24, 2022
Applies to:Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
There were stuck pending transactions in mtl_material_transactions_temp (MMTT) for a batch and they were resubmitted. Now there are duplicate transactions in mtl_material_transactions (MMT).
Need to delete these.
1. The pending transactions were seen on the Pending Transactions form (Inventory > Transactions > Pending Transactions) and were resubmitted on that form.
2. The duplicate transactions can be seen on the Material Transactions form in Inventory (Inventory > Transactions > Material Transactions) or the batch View Material Transactions form (Production Supervisor > Batch Details > Inventory > View Material Transactions).
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