Results for “variance_value”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQP_EXCEPTION_REPORTS is a table owned by the HR schema within Oracle E-Business Suite, associated with the PQP (Public Sector Payroll) product. Its documented purpose is to store exception report definitions. Each row represents a report definition that is either seeded by Oracle or created by a user, and each definition is anchored to a payroll balance and a balance dimension. Exception reports are used in public sector payroll processing to identify payees or assignments whose balances fall outside configured tolerances, allowing payroll administrators to review anomalous values before or after a payroll run.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is identified as standalone, which suggests it be modeled as a hub-like reference entity for exception report definitions, with no upstream dependency other than its reference to PAY_BALANCE_DIMENSIONS. It does, however, serve as a parent to PQP_EXCEPTION_REPORT_GROUPS, so the definition entity participates in a one-to-many grouping relationship downstream.

Key Information Stored

The documented physical schema for release 12.2.2 lists 20 columns. The most operationally significant are described below.

Common Use Cases and Queries

Typical usage includes listing the exception reports available to a payroll administrator, retrieving the balance and dimension configuration behind a named report, and auditing which definitions are seeded versus user-defined. A representative query joining the dimension reference is:

  • SELECT er.exception_report_id, er.exception_report_name, er.variance_type, er.variance_value, bd.dimension_name FROM pqp_exception_reports er, pay_balance_dimensions bd WHERE er.balance_dimension_id = bd.balance_dimension_id AND er.legislation_code = :p_legislation AND er.business_group_id = :p_bg_id;
  • A child-oriented query returns all group assignments for a definition by joining pqp_exception_report_groups g to pqp_exception_reports er ON g.exception_report_id = er.exception_report_id.
  • Tolerance analysis reports commonly filter on VARIANCE_OPERATOR and COMPARISON_TYPE to profile which exception rules are configured for a balance, such as identifying every report that flags a variance greater than a fixed currency threshold.

Related Objects

  • PAY_BALANCE_DIMENSIONS — referenced by BALANCE_DIMENSION_ID; supplies the dimension definition each report evaluates.
  • PQP_EXCEPTION_REPORT_GROUPS — child table referencing EXCEPTION_REPORT_ID; associates definitions with exception report groups.
  • PAY_BALANCES (via BALANCE_TYPE_ID) — supplies the balance being examined by the definition.
  • HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID) — identifies the owning business group.
  • FND_ID_FLEX_STRUCTURES and related key flexfield objects — indirectly support balance type and dimension resolution.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — determine PQP product availability for the legislation in use.