How To Calculate KPI Indicators For Specific Organizations And Not The Entire ASCP Plan (Doc ID 1952653.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3.8 and later
Information in this document applies to any platform.

Goal

On : 12.1.3.8 version, Reports and Dashboards

How to Calculate KPI indicators for Specific Organizations and not the entire ASCP plan

We are currently implementing APCC for Emerson Process Management, there are several Line of Businesses inside Emerson Process Management. Whereas we have one Single Global Plan for all the Business units and their inventory organizations. When we enable calculate Key performance indicators at the ASCP plan. The overall plan runtime increases by 30%. Primarily Memory based planner runtime increases due to large volume of records populated to MSC_BIS_INV_DETAILS table. From here on APCC archive programs kick off to push data for fact tables. I understand completely the rationale behind this data push and increased volume.

My question is the calculate KPI is available at ASCP plan level. Is there way if we can control this parameter at Organization level so that we can choose whichever organizations are interested in APCC information can use it and leave the rest of the organizations out of purview.

Reasons are: not all organizations are planning to use APCC information right away. And there is interest from some organizations to use it right away. So purely from performance point of view is there a way we can control the calculate kpi indicators being generated for specific set of organizations in the plan.

We are using unconstrained ASCP plan with 45 inventory organizations and six months from now the number of organizations in the global plan is predicted to increase to 73 based on Go-Lives and consolidation efforts. So it becomes critical to maintain the performance of the ASCP plan runs.
 

Solution

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