EBS : PS: 12.2.5 - Launch PS Plan Hangs On A Query Against MSC_OPERATION_RESOURCES

(Doc ID 2203593.1)

Last updated on JANUARY 23, 2018

Applies to:

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


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.

nothing since the process take too long.


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