Results for “formula_type_id”

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

Overview

FF_QP_REPORTS is a table in the HR schema of Oracle E-Business Suite, owned by the FastFormula (FF) product module. It stores QuickPaint report definitions used by the FastFormula framework. QuickPaint is the reporting and layout mechanism that FastFormula uses to render formula output — the same infrastructure that powers Oracle HRMS reports such as employee statements, payslip-style outputs, and configurable letter generation. Each row in FF_QP_REPORTS represents a single QuickPaint report definition, binding a report name and descriptive metadata to an underlying FastFormula and a formula type. In EBS 12.1.1 and 12.2.2 the table is documented with 14 columns and is validated in the data dictionary.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries its own surrogate primary key and descriptive context attributes (name, description, legislation, business group), while a strong FK dependency points to FF_FORMULA_TYPES. This pattern is consistent with a descriptive satellite hanging off a formula-type hub, though the presence of business keys and lifecycle columns means it could also be treated as a small reference hub in a dimensional design.

Key Information Stored

The table is anchored by the surrogate primary key QP_REPORT_ID, enforced by the FF_QP_REPORTS_PK index. This identifier is the value propagated to downstream consumers of report definitions.

Business-key candidates are captured by the unique index FF_QP_REPORTS_UK2, which spans four columns: QP_REPORT_NAME, FORMULA_TYPE_ID, BUSINESS_GROUP_ID, and LEGISLATION_CODE. This composite uniqueness means a report name is only unique within a given formula type, business group, and legislation context — an important consideration when querying across multi-org or multi-legislative deployments.

• QP_REPORT_ID — surrogate primary key for the report definition.
• QP_REPORT_NAME — the user-facing name of the QuickPaint report; part of the composite unique key.
• FORMULA_ID — reference to the FastFormula whose output the report renders.
• FORMULA_TYPE_ID — foreign key to FF_FORMULA_TYPES; classifies the report by formula type and is part of the unique key.
• BUSINESS_GROUP_ID — multi-tenant partitioning column; part of the unique key.
• LEGISLATION_CODE — statutory jurisdiction context; part of the unique key.
• QP_ALTERED_FORMULA — holds the customized or user-altered formula text associated with the report.
• QP_DESCRIPTION — free-text description of the report's purpose.
• QP_TEXT — the QuickPaint layout or template text defining report output.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit and WHO columns tracking creation and modification.

Common Use Cases and Queries

Typical use cases include auditing which QuickPaint reports exist for a given formula type, identifying reports scoped to a specific legislation, and tracing a rendered report back to its source formula. A representative query joining to the formula type follows:

• SELECT r.QP_REPORT_NAME, r.QP_REPORT_ID, r.LEGISLATION_CODE, r.BUSINESS_GROUP_ID FROM HR.FF_QP_REPORTS r WHERE r.FORMULA_TYPE_ID = :type_id AND r.BUSINESS_GROUP_ID = :bg_id;
• Reporting: list all QuickPaint reports by name and description within a business group.
• Migration/audit: extract QP_ALTERED_FORMULA and QP_TEXT to review customizations before an upgrade.
• Impact analysis: join to PER_QUICKPAINT_INVOCATIONS to find where a report is invoked.

Related Objects

• FF_FORMULA_TYPES — referenced via FF_QP_REPORTS.FORMULA_TYPE_ID; parent classification table.
• PER_QUICKPAINT_INVOCATIONS — references this table via QP_REPORT_ID; records runtime invocations.
• HR_S_QP_REPORTS — a secondary/security mirror referencing QP_REPORT_ID.
• FF_FORMULAS — logically linked through FORMULA_ID to the underlying formula definition.
• FF_FORMULA_TYPES_TL — provides translated names for the formula-type foreign key.