Search Results pa_perf_indicators

Overview

APPS.PA_PERF_THRESHOLDS_V is a reporting and integration view within the Oracle E-Business Suite Projects (PA) module. It exposes the threshold definitions used by the performance indicator engine, resolving the raw code values stored in the underlying threshold table into their user-facing meanings. Performance indicators in Oracle Projects are metrics such as cost variance, schedule variance, and budget performance, and thresholds define the numeric ranges against which those indicator values are evaluated. When project performance is assessed, each threshold determines the band (for example, acceptable, warning, or critical) into which a calculated indicator value falls, and it may also drive exception flagging and weighted scoring.

For a user searching on "pa_perf_indicators," this view is the natural access point. The string PA_PERF_INDICATORS is the lookup type in the PA_LOOKUPS table, and the view is defined precisely by joining that lookup set to the threshold rows. This makes PA_PERF_THRESHOLDS_V the readable, resolved representation of performance indicator thresholds rather than the raw key-bearing base table.

Underlying Base Objects

The documented ETRM metadata states that the view references two objects: PA_LOOKUPS (a VIEW) and PA_PERF_THRESHOLDS (a SYNONYM). The view definition confirms this in its FROM clause, aliasing PA_PERF_THRESHOLDS as TH and PA_LOOKUPS as IND. The join predicate restricts the lookup rows to the PA_PERF_INDICATORS lookup type and matches the lookup code to the indicator code on the threshold row. Because PA_PERF_THRESHOLDS is exposed as a synonym, it resolves to the underlying Projects threshold entity owned by the application schema.

It should be noted that the view does not itself perform filtering by project or rule object beyond the lookup join; the RULE_TYPE and THRES_OBJ_ID columns carry that context to the caller.

Key Columns

The view returns the following columns, drawn largely from the PA_PERF_THRESHOLDS entity with one resolved description column from PA_LOOKUPS:

• THRESHOLD_ID — Primary key of the threshold definition row.
• RULE_TYPE — Classifies the rule context to which the threshold applies.
• THRES_OBJ_ID — Identifier of the object to which the threshold is attached.
• FROM_VALUE / TO_VALUE — Lower and upper bounds defining the numeric range for the threshold band.
• INDICATOR_CODE — Code identifying the performance indicator (the value matched against PA_PERF_INDICATORS lookup codes).
• MEANING — The descriptive meaning of the indicator code, resolved through the PA_PERF_INDICATORS lookup type via PA_LOOKUPS.
• EXCEPTION_FLAG — Indicates whether the threshold triggers exception handling when breached.
• WEIGHTING — Numeric weighting applied to the indicator for scoring purposes.
• ACCESS_LIST_ID — Identifier of the access list controlling visibility of the threshold row.
• RECORD_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle auditing columns.

Common Use Cases and Queries

Typical uses include listing all thresholds for a given indicator, reporting the configured bands and weights, and joining indicator meaning into project performance dashboards or custom integrations. A simple listing query is:

SELECT threshold_id, rule_type, thres_obj_id, indicator_code, meaning, from_value, to_value, exception_flag, weighting FROM apps.pa_perf_thresholds_v ORDER BY indicator_code, from_value;

To isolate thresholds for a particular indicator, add a predicate on the code:

SELECT threshold_id, meaning, from_value, to_value, exception_flag, weighting FROM apps.pa_perf_thresholds_v WHERE indicator_code = :p_indicator_code;

Because MEANING is supplied by the PA_PERF_INDICATORS lookup, this view is preferred over querying PA_PERF_THRESHOLDS directly whenever a user-facing description of the indicator is required.