Search Results ff_qp_reports




Overview
Explore in AI Chat

Overview

The FF_QP_REPORTS table is a core repository for QuickPaint report definitions within the Oracle E-Business Suite FastFormula (FF) module. It functions as a master table that stores the metadata and configuration for QuickPaint reports, which are tools used to generate formatted, ad-hoc reports directly from FastFormula logic. This table is owned by the HR schema, underscoring its primary integration with Human Resources and Payroll processes, though its use can extend to other modules leveraging FastFormula. Its role is to centrally define and manage these report templates, enabling users to execute them through the application's QuickPaint interface.

Key Information Stored

The table's structure is designed to uniquely identify and categorize each QuickPaint report definition. Its primary key is the system-generated identifier, QP_REPORT_ID. The table enforces a unique constraint (FF_QP_REPORTS_UK2) on a combination of columns to prevent duplicate report definitions within a given context. Key descriptive and contextual columns include QP_REPORT_NAME, which stores the user-defined name of the report, and FORMULA_TYPE_ID, a foreign key linking to FF_FORMULA_TYPES to categorize the report by its associated formula type (e.g., a payroll formula). The BUSINESS_GROUP_ID and LEGISLATION_CODE columns provide multi-organization and legislative context, allowing for the definition of reports specific to a particular business unit or legal jurisdiction.

Common Use Cases and Queries

A primary use case is auditing and managing available QuickPaint reports within an implementation. System administrators or functional consultants may query this table to list all reports for a specific formula type or business group. A typical query would be:

SELECT qp_report_id, qp_report_name, formula_type_id
FROM hr.ff_qp_reports
WHERE business_group_id = :p_bg_id
ORDER BY qp_report_name;

Another common scenario involves troubleshooting report execution issues by verifying a report's definition exists and is correctly linked to its formula type. Developers may also reference this table when writing custom programs that need to programmatically invoke a specific QuickPaint report, using the QP_REPORT_ID as a key parameter.

Related Objects

The FF_QP_REPORTS table has defined relationships with other key EBS objects, as documented in the ETRM metadata. It references the FF_FORMULA_TYPES table via the foreign key on FORMULA_TYPE_ID, enabling categorization of the report. More significantly, it is referenced by the PER_QUICKPAINT_INVOCATIONS table via the QP_REPORT_ID column. This relationship is critical; PER_QUICKPAINT_INVOCATIONS stores the runtime instances and parameters for each execution of a QuickPaint report. Therefore, a typical join for analyzing report usage would be:

SELECT r.qp_report_name, i.*
FROM hr.ff_qp_reports r,
     per_quickpaint_invocations i
WHERE r.qp_report_id = i.qp_report_id;

These relationships position FF_QP_REPORTS as the definitional source for runtime data stored in PER_QUICKPAINT_INVOCATIONS.

  • Table: FF_QP_REPORTS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_QP_REPORTS,  object_name:FF_QP_REPORTS,  status:VALID,  product: FF - FastFormula ,  description: QuickPaint report definitions. ,  implementation_dba_data: HR.FF_QP_REPORTS , 

  • Table: FF_QP_REPORTS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_QP_REPORTS,  object_name:FF_QP_REPORTS,  status:VALID,  product: FF - FastFormula ,  description: QuickPaint report definitions. ,  implementation_dba_data: HR.FF_QP_REPORTS , 

  • Table: FF_FORMULA_TYPES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_FORMULA_TYPES,  object_name:FF_FORMULA_TYPES,  status:VALID,  product: FF - FastFormula ,  description: Used to define groups of formulas to associate with formula contexts. ,  implementation_dba_data: HR.FF_FORMULA_TYPES , 

  • Table: FF_FORMULA_TYPES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_FORMULA_TYPES,  object_name:FF_FORMULA_TYPES,  status:VALID,  product: FF - FastFormula ,  description: Used to define groups of formulas to associate with formula contexts. ,  implementation_dba_data: HR.FF_FORMULA_TYPES ,