My Oracle Support Banner

ATP Post Plan Processing Failing Post Upgrade To 12.2.6 (Doc ID 2372386.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version,

ATP Post Plan Processing (MSC_ATP_PDS_SUMM) fails post upgrade to 12.2.6
(When this happens program has a status of Normal)

The problem is happening only when the plan is run in 24 x 7 mode.


Error1: ORA-00060: deadlock detected while waiting for resource (When this happens program ends in error)


---------Before calling schedule---------
After calling schedule: l_return_status : E
Error in call to Call_Schedule
Exception in call to Call_Schedule
Return Status : E
Error Message : User-Defined Exception
Unexpected Error. Sync Call To ATP failed
Sync Error: Unable to continue further
------- Update_Summary_Flag -----
 Plan ID : 1046 Status : 7
ATP Status Flag Update : S
----------------End Call Synchronize-------------


Create an ASCP plan with ATP Option checked.
Launch the plan in 24 x 7 mode and see the failures.

Unable to run Plan in 24*7 mode


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.