EBS : PS: 12.2.5 - Launch PS Plan Hangs On A Query Against MSC_OPERATION_RESOURCES
Last updated on JANUARY 23, 2018
Applies to:Oracle Production Scheduling - Version 126.96.36.199 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