Results for “qp_description”

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

Overview

The HR_S_QP_REPORTS table is a Human Resources (PER) module object owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in the ETRM metadata as "Retrofitted," which indicates that the object was introduced or re-applied into the EBS data model during an upgrade or customization-remediation cycle rather than originating from a standard Oracle-delivered schema version. Despite its HR ownership prefix, the table's foreign keys point into the Fast Formula infrastructure (FF_QP_REPORTS and FF_FORMULA_TYPES), placing HR_S_QP_REPORTS functionally alongside the Oracle Fast Formula / payroll formula reporting layer rather than core HR person or assignment data.

Based on the heuristic Data Vault classification mined from its foreign key structure, HR_S_QP_REPORTS is modeled as a standalone object. In Data Vault terms this suggests it behaves as a satellite-like record holder rather than a pure hub or link: it carries its own surrogate key (QP_REPORT_ID) plus descriptive and audit attributes, while referencing parent formula-definition entities through foreign keys rather than being itself an integration hub.

Key Information Stored

The documented physical schema contains 14 columns. The most significant are:

• QP_REPORT_ID — the surrogate primary key and the column that other formula-reporting structures reference; also the FK target name used against FF_QP_REPORTS.
• FORMULA_ID — links the report definition to a specific formula.
• FORMULA_TYPE_ID — foreign key to FF_FORMULA_TYPES, classifying the formula (for example, payroll, absence, or accrual formula types).
• QP_REPORT_NAME — the business-facing report name.
• QP_DESCRIPTION — free-text description of the report's purpose.
• QP_ALTERED_FORMULA — indicates whether the underlying formula has been modified from its delivered form.
• QP_TEXT — the formula or report body text; this is the largest attribute column and the primary reason the table is indexed with a LOB-style index (SYS_IL0000044207C00014$$).
• BUSINESS_GROUP_ID and LEGISLATION_CODE — the multi-tenant and legislative context keys that scope a report definition to a specific business group and country legislation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS WHO-column audit set.

The unique index SYS_IL0000044207C00014$$ is associated with column position 14 (QP_TEXT), confirming the LOB-backed nature of the formula text and reinforcing that QP_REPORT_ID remains the operative surrogate business-key candidate.

Common Use Cases and Queries

Typical usage centers on auditing and reporting the formula definitions stored against each QP report. Analysts commonly join HR_S_QP_REPORTS to FF_FORMULA_TYPES to enumerate reports by formula category, and to FF_QP_REPORTS to resolve the owning report header.

SELECT r.QP_REPORT_ID,
       r.QP_REPORT_NAME,
       r.FORMULA_ID,
       t.FORMULA_TYPE_NAME
FROM   HR.HR_S_QP_REPORTS r,
       FF.FF_FORMULA_TYPES t
WHERE  r.FORMULA_TYPE_ID = t.FORMULA_TYPE_ID
AND    r.BUSINESS_GROUP_ID = :p_bg_id;

A second common pattern identifies customized formulas by filtering QP_ALTERED_FORMULA, supporting impact analysis before patching or upgrading. Legislative reporting filters use LEGISLATION_CODE alongside BUSINESS_GROUP_ID for country-specific extracts. Because QP_TEXT is a large object, projections should avoid selecting it unless the formula body itself is required, and any query listing QP_TEXT should be run against a targeted QP_REPORT_ID.

Related Objects

• FF_QP_REPORTS — parent report entity; joined via HR_S_QP_REPORTS.QP_REPORT_ID = FF_QP_REPORTS.QP_REPORT_ID.
• FF_FORMULA_TYPES — formula classification; joined via HR_S_QP_REPORTS.FORMULA_TYPE_ID = FF_FORMULA_TYPES.FORMULA_TYPE_ID.
• FF_FORMULAS — resolves the FORMULA_ID reference to the formula definition record.
• FF_FORMULA_TYPES_TL — translated formula type names for multi-language reporting.
• HR_ALL_ORGANIZATION_UNITS / HR_OPERATING_UNITS — context for BUSINESS_GROUP_ID scoping in multi-org reporting.
• FND_LOOKUPS — supplies legislation and status lookup values referenced by LEGISLATION_CODE.

Together these objects place HR_S_QP_REPORTS within the Fast Formula reporting domain, serving as a satellite of formula-report metadata scoped by business group and legislation.