Results for “pqp_exception_reports”
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.
- EXCEPTION_REPORT_ID — the surrogate primary key. It is the single column of the PQP_EXCEPTION_REPORTS_PK unique index and the column referenced by child tables. It carries no business meaning.
- EXCEPTION_REPORT_NAME — the user-facing identifier of the report definition, used in list of values and report selection.
- LEGISLATION_CODE — the legislation under which the report is valid, governing which seeded and user-defined definitions are visible to a given payroll.
- BUSINESS_GROUP_ID — the business group owning the definition, enabling multi-tenant separation of user-defined reports.
- BALANCE_TYPE_ID — the balance being evaluated by the exception report.
- BALANCE_DIMENSION_ID — foreign key to PAY_BALANCE_DIMENSIONS, specifying the dimension against which the balance is examined.
- CURRENCY_CODE — the currency in which variance and comparison amounts are expressed.
- VARIANCE_TYPE and VARIANCE_VALUE — the nature and magnitude of the tolerance applied to the balance.
- VARIANCE_OPERATOR — the relational operator applied when testing the variance condition.
- COMPARISON_TYPE and COMPARISON_VALUE — the reference against which the balance is compared, for example a prior period or a fixed amount.
- OUTPUT_FORMAT — controls the presentation of the generated exception report output.
- Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER provide standard who-column and optimistic locking support.
- ZD_EDITION_NAME — participates in the PQP_EXCEPTION_REPORTS_PK unique index alongside EXCEPTION_REPORT_ID, supporting edition-based redefinition.
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 gtopqp_exception_reports er ON g.exception_report_id = er.exception_report_id. - Tolerance analysis reports commonly filter on
VARIANCE_OPERATORandCOMPARISON_TYPEto 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.
-
Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.
-
Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.
-
PACKAGE: APPS.PQP_EXCP_RPT 12.1.1
-
PACKAGE: APPS.PQP_EXCP_RPT 12.2.2
-
PACKAGE: APPS.PQP_ERT_BUS 12.2.2
-
PACKAGE: APPS.PQP_ERG_BUS 12.1.1