EBS : PS: 12.2.5 - Launch PS Plan Hangs On A Query Against MSC_OPERATION_RESOURCES (Doc ID 2203593.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Production Scheduling - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Data Collections from EBS products (717, 590 and 951) to Planning Data Store

EBS and PS 12.2.5

When trying to run the "Launch PS Plan" concurrent program, the request is running for a very long time on a query against the MSC_OPERATION_RESOURCES table. This is causing a huge delay in Production Scheduling as our schedulers cannot work without this program.
The job was taking only 2-3 minutes to run last week. Now, it is running for more than a couple hours and has not completed.

ERROR
-----------------------
nothing since the process take too long.

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