ATP Post Plan Processing Failing Post Upgrade To 12.2.6

(Doc ID 2372386.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

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.

ERROR
-----------------------

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

Error2:

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



STEPS
-----------------------

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


BUSINESS IMPACT
-----------------------
Unable to run Plan in 24*7 mode

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms