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

Last updated on JUNE 29, 2017

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

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