Search Results per_quickpaint_invocations




Overview
Explore in AI Chat

Overview

The PER_QUICKPAINT_INVOCATIONS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically designed to manage the execution of QuickPaint reports. QuickPaint is a reporting tool used to generate ad-hoc, formatted reports on HR data. This table serves as a transactional log, uniquely identifying and tracking each individual run or invocation of a QuickPaint report. Its primary role is to maintain a record of report executions, which is essential for auditing, troubleshooting, and linking a report run to its generated output data stored in related tables.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the critical data points stored. Each record represents a single report execution instance. The primary key, QP_INVOCATION_ID, is a unique identifier for each run. A crucial foreign key, QP_REPORT_ID, links the invocation to its report definition stored in the FF_QP_REPORTS table, identifying which specific QuickPaint report was executed. Other typical columns in such an audit table, though not explicitly listed here, would likely include timestamps for the run, the user who initiated it, status (e.g., 'SUBMITTED', 'COMPLETE', 'ERROR'), and parameters used for that specific execution.

Common Use Cases and Queries

The primary use case is auditing and monitoring QuickPaint report usage. System administrators or HR analysts can query this table to understand report frequency, identify heavy users, or troubleshoot failed executions. A common query would join to the report definitions table to get a readable report name.

Sample Query:
SELECT i.QP_INVOCATION_ID, r.REPORT_NAME, i.CREATION_DATE, i.CREATED_BY
FROM PER_QUICKPAINT_INVOCATIONS i,
FF_QP_REPORTS r
WHERE i.QP_REPORT_ID = r.QP_REPORT_ID
AND i.CREATION_DATE > SYSDATE - 30
ORDER BY i.CREATION_DATE DESC;

This table is also essential for retrieving the actual output of a report run, as its primary key is referenced by the PER_QUICKPAINT_RESULT_TEXT table which stores the report results.

Related Objects

  • Primary Key: PER_QUICKPAINT_INVOCATIONS_PK on column QP_INVOCATION_ID.
  • Foreign Key (Referenced Outbound): The table references FF_QP_REPORTS via the QP_REPORT_ID column. This links an invocation to its master report definition.
  • Foreign Key (Referenced Inbound): The table is referenced by PER_QUICKPAINT_RESULT_TEXT via its QP_INVOCATION_ID column. This is a critical relationship, as the result text for a specific report run is stored in this child table, linked by the invocation ID.