[Home] [Help] [Dependency Information]
Object Name: | MSC_PLAN_ORG_KPIS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_PLAN_ORG_KPIS |
Subobject Name: | |
Status: | VALID |
This table maintains the key performance indicators and the thresholds required for generating exceptions for a plan. This table is populated at the time of plan creation during the invitation process and by the supply chain intelligence APIs. The key perfomance metrics are exception count and resolution latency (i.e., the time taken to resolve the exceptions). The thresholds for supply planning and demand planning are also stored in this table if the plan is used for Demand Planning or Supply Planning. This table is queried while viewing the plan parameters and by the supply chain intelligence views.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Contains the plan identifier | |
ORGANIZATION_ID | NUMBER | Yes | Stores the owning organization of the plan | |
SR_INSTANCE_ID | NUMBER | Yes | Contains the source instance identifier, currently defaulted to -1 | |
KPI_ID | NUMBER | Yes | Contains the code of the key performance indicator or threshold | |
KPI_VALUE | NUMBER | Yes | Contains the KPI or threshold value depending on the KPI_ID |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, KPI_ID
, KPI_VALUE
FROM MSC.MSC_PLAN_ORG_KPIS;
MSC.MSC_PLAN_ORG_KPIS does not reference any database object
MSC.MSC_PLAN_ORG_KPIS is referenced by following:
|
|
|