ATP Post Plan Processing Running For Several Hours On First Attempt Running ATP Plan

(Doc ID 2259531.1)

Last updated on APRIL 26, 2017

Applies to:

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

Symptoms

12.1.3 .9.1

PROBLEM
-------------
ATP Post Plan Processing has been running for long time, expect the program to complete quickly
This is our first time turning on ATP for our plans.

AWR reports all contain SQL ID - 5ugxzcu452zc2
select ....
FROM MSC_PLANS MP, MSC_PLAN_ORGANIZATIONS PO, MSC_SYSTEM_ITEMS I2, MSC_TRADING_PARTNERS TP, MSC_ATP_RULES R, MSC_CALENDAR_DATES


STEPS
--------
Run plan with ATP flag checked.
Using 24 x7 processing for the ATP plan

EXPECTED BEHAVIOR
----------------------------
should finish and not hang

BUSINESS IMPACT
----------------------
Cannot use this process successfully and have ATP plans available for scheduling as required.
Cannot have 24 x7 ATP plan availability.

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