My Oracle Support Banner

ATP Transactions Getting Stuck DBA_2PC_PENDING (Doc ID 2694947.1)

Last updated on AUGUST 10, 2020

Applies to:

Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

We are observing that there are multiple DBA_2PC_PENDING getting added in our EBS production environment.
Upon investigation we have identified that ATP transactions from Sales Order are causing this. We have a separate ASCP Instance

SQL> select mixed, count(*) from DBA_2PC_PENDING group by mixed;
MIXED COUNT(*)
----- ----------
no 702376

This count is increasing day by day.

We were able to identify the sql involved using logminer utility and have attached the same in SR for your review.
 

Solution

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