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 laterInformation 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 |