Search Results pa_perf_rules_v




Overview
Explore in AI Chat

Overview

PA_PERF_RULES_V is an Oracle Applications (APPS) database view within the Projects (PA) product family. It exposes the definition of the performance rules available to the Oracle Projects performance and measurement framework. Performance rules associate a rule type with a key performance area (KPA), an underlying measure, a scoring method, and a set of formatting and validity attributes. The view is a denormalized, user-facing read layer over the base performance rule table, resolving code values to their translated meanings and joining supplemental measure information.

In Oracle EBS 12.1.1 and 12.2.2, this view is typically consumed by reporting tools, custom extensions, and integrations that need to enumerate or validate performance rules without performing lookup joins manually. It is a standard, VALID view owned by the APPS schema. The view flattens several coded reference columns into display-ready names, which makes it suitable for use in Oracle Reports, BI Publisher data models, OBIEE-style federated queries, and ad hoc SQL. Because it is a view rather than a table, it carries no independent data; all content is derived from its referenced base objects at query time.

Underlying Base Objects

Per the documented ETRM metadata, PA_PERF_RULES_V is defined over three referenced objects:

The joins are enforced on lookup type plus lookup code, and the key area lookup is further restricted by ENABLED_FLAG = 'Y'. As a result, the view returns only rules whose key area code maps to an enabled lookup value, and it suppresses rows whose rule type lacks a corresponding lookup entry.

Key Columns

Common Use Cases and Queries

Typical uses include listing active rules filtered by key performance area, reporting rule-to-measure mappings, and validating KPA codes supplied by an interface or integration. The following retrieves rules for a specific KPA:

  • SELECT rule_name, kpa_code, kpa_name, measure_name, score_method FROM pa_perf_rules_v WHERE kpa_code = 'YOUR_KPA' ORDER BY rule_name;
  • SELECT kpa_code, kpa_name, COUNT(*) FROM pa_perf_rules_v GROUP BY kpa_code, kpa_name;
  • SELECT r.rule_name, r.measure_name FROM pa_perf_rules_v r WHERE TRUNC(SYSDATE) BETWEEN NVL(r.start_date_active, SYSDATE) AND NVL(r.end_date_active, SYSDATE);

Because KPA_CODE is resolved through an enabled-flag-filtered lookup join, queries on this column return only valid, active key areas, making the view a reliable source for code validation and reference reporting.