My Oracle Support Banner

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

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