My Oracle Support Banner

RP Plan Hangs/Performance With Plan Status: Solving Plan (Doc ID 2130564.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Rapid Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Planning Engine in Test

Users are on 12.2.4 and have applied 12.2.4.1 VCP patching. They also applied one off patch 22853045 17-MAR-2016 with file version engine.zip 120.134.12020000.128

Users are running an unconstrained plan and a week ago it was completing fine. Now the plan hangs and is stuck in Solving Plan status and will not complete. Engine log shows

  sql=UPDATE MSC_PLANS SET STATUS=5 WHERE PLAN_ID=19034
Wed Mar 30 17:48:32 GMT+00:00 2016 sql=ALTER TABLE MSC.MSC_RP_ITEM_UPDATES TRUNCATE PARTITION RP_ITEM_UPDATES_19034
sql=UPDATE MSC_PLANS SET SUMMARY_FLAG=0 WHERE PLAN_ID=19034
Wed Mar 30 17:48:32 GMT+00:00 2016 RUN PLAN


********** START OF planner_.planRequests() *******
  3 Warning: No OnHand, but there is a reserved Qty
  3 Warning: Reserved Qty is greater than OnHand
  3 Warning: No OnHand, but there is a reserved Qty
Merging operation Starts :: Time in MS : 1 :: Memory usage in MB: 0
LBL Planning :: Time in MS : 14429 :: Memory usage in MB: -258
RPEPlan :: Time in MS : 14563 :: Memory usage in MB: -258
sql=UPDATE MSC_PLANS SET STATUS=6 WHERE PLAN_ID=19034
Wed Mar 30 17:48:46 GMT+00:00 2016 EXPORT SOLUTION
CLEARING THE RESERVED DEMANDS MAP
Total Time spend in End Item Subs : 0
Total Time spend in creating End Item Demands 414
Total Time spend in make processes/buy/transfer : 22952
Total time spend for Firm wips : 1275
Total time spend for FPO : 8
Total Time spend for CO Wip : 4
For Creating SupplyBase/Demands :: Time in MS : 24707 :: Memory usage in MB: 527
** Number of Constraints : 0

They have 7 gig assigned as Heap Memory size for the Engine Managed Server and still shows 40% free while hanging

EXPECTED BEHAVIOR
-----------------------
Expect plan to complete

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run unconstrained RP plan
2. Plan used to complete and now hangs and will not complete

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.