Post Plan Program for UI Concurrent Program Peformance Issue in msc_get_bis_values.ui_post_plan (Doc ID 2009890.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Memory Based Planner

ACTUAL BEHAVIOR
---------------
Plan Program for UI program which used to take a minute to run before one week now takes more than 3 hours to run.
We are facing this issue in multiple instances plan is taking long time to tun particularly


MSC_UI_POST_PLAN module: Post Plan Program for UI
**Starts**11-MAY-2015 08:31:43
**Ends**11-MAY-2015 11:32:24


TKPROF
----------------
BEGIN msc_get_bis_values.ui_post_plan(:errbuf,:rc,:A0); END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 4778.29 10407.54 9360552 164646090 3628161441 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 4778.29 10407.54 9360552 164646090 3628161441 1

Elapsed Time -10407 secs - 10407/3600 = 2.890 hrs

EXPECTED BEHAVIOR
-----------------------
Expect the performance to return to as it was before .

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. Run a Plan
3. See the request Post Plan Program for UI taking time to complete.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer is in critical stage of the project and are in final stages of UAT.

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