My Oracle Support Banner

MSCHUBA: Archive Plan Summary Hanging (Doc ID 2721665.1)

Last updated on OCTOBER 21, 2020

Applies to:

Oracle Advanced Planning Command Center - 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
---------------
Archive Plan Summary program is hanging. When you look at the log file, all you see is:
MSCHUBA: Archive Plan Summary
+---------------------------------------------------------------------------+
Current system time is 21-SEP-2020 03:15:00
+---------------------------------------------------------------------------+
**Starts**21-SEP-2020 03:15:01

Check the .tmp files by running the following SQL:

select
c.value || '/' || p.plsql_log
from fnd_concurrent_processes P,
fnd_concurrent_requests R,
fnd_env_context C
where R.controlling_manager=P.concurrent_process_id
and P.concurrent_process_id=C.concurrent_process_id
and c.variable_name='APPLPTMP'
and r.request_id = &request_id

This provided results similar to the following:

2020-10-08 02:57:38: msc_phub_pkg.populate_facts: msc_apcc_workers:8
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_exception_pkg, 22, 392392) = 1249343
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_supplier_pkg, 22, 392392) = 1249344
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_demand_pkg, 22, 392392) = 1249345
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_phub_cost_pkg, 22, 392392) = 1249346
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_supply_pkg, 22, 392392) = 1249347
2020-10-08 02:57:38: msc_phub_pkg.populate_facts: MSCHUBA2(msc_resource_pkg, 22, 392392) = 1249348
2020-10-08 02:59:33: msc_phub_pkg.populate_facts: MSCHUBA2(msc_phub_excess_pkg, 22, 392392) = 1249349

There is also one Archive One Package hanging as well. The .tmp file for this shows:

2020-10-08 02:57:59: msc_phub_pkg.populate_each: (msc_demand_pkg,22,392392)
2020-10-08 02:57:59: l_n=0
2020-10-08 02:57:59: msc_phub_util.is_measure_block_included(3) = 1
2020-10-08 02:57:59: msc_demand_pkg.populate_details
2020-10-08 02:57:59: msc_demand_pkg.populate_details: 22,392392,1,1,08-OCT-20,03-OCT-21,15682,,,1,03-OCT-21
 

EXPECTED BEHAVIOR
-----------------------
All the programs should run to completion and not hang.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the plan.



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.