Search Results per_quickpaint_result_text




Overview
Explore in AI Chat

Overview

The PER_QUICKPAINT_RESULT_TEXT table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the QuickPaint reporting functionality. It stores the textual output generated for individual assignments during a single execution of a QuickPaint report. QuickPaint is a tool used for generating formatted, detailed reports on employee information, such as directories or organizational charts. This table acts as the repository for the final, line-by-line descriptive text produced by the report engine for each processed employee assignment, enabling the storage and subsequent retrieval of complete report results.

Key Information Stored

The table's structure is designed to uniquely identify and store the text output for each line of a report result per assignment. Its primary key is a composite of three columns, ensuring uniqueness within the context of a specific report run. The key columns are QP_INVOCATION_ID, which links to the parent report execution record; ASSIGNMENT_ID, which identifies the specific employee assignment being reported on; and LINE_NUMBER, which sequences the lines of text for that assignment. The table's primary data column, though not explicitly named in the provided metadata, would logically contain the descriptive text (CLOB or VARCHAR2) for the corresponding line, as indicated by the table's description. This structure allows for multi-line text blocks to be stored and reassembled in the correct order.

Common Use Cases and Queries

The primary use case is the retrieval of saved QuickPaint report output for viewing, printing, or distribution. Administrators or users may query this table to review historical report data or integrate its contents with other systems. A typical query would join to the PER_QUICKPAINT_INVOCATIONS table to filter results by report parameters or execution date. For example, to fetch the full text for a specific report run, one might use:

  • SELECT assignment_id, line_number, result_text
  • FROM per_quickpaint_result_text
  • WHERE qp_invocation_id = &invocation_id
  • ORDER BY assignment_id, line_number;

This table is generally accessed indirectly through the QuickPaint user interface or standard APIs, rather than via direct ad-hoc queries in operational scenarios.

Related Objects

The table maintains a critical foreign key relationship with the PER_QUICKPAINT_INVOCATIONS table, which is the master record for each QuickPaint report execution. The relationship is defined as:

  • PER_QUICKPAINT_INVOCATIONS: This table is referenced via the column PER_QUICKPAINT_RESULT_TEXT.QP_INVOCATION_ID. The PER_QUICKPAINT_INVOCATIONS table stores metadata about the report run, such as the report type, parameters, submission date, and status. Every record in PER_QUICKPAINT_RESULT_TEXT must correspond to a valid parent invocation record.

While not listed in the provided metadata, this table would also have an implicit relationship with the PER_ALL_ASSIGNMENTS_F table (or a related assignment view) through the ASSIGNMENT_ID column to obtain assignment and person details for the reported text lines.