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 JUNE 26, 2023

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

STEPS
--------
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).

Changes

 

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
Changes
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.