Results for “report_category”

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

Overview

PAY_REPORT_FORMAT_ITEMS is an APPS-owned, date-effective view in the Oracle E-Business Suite Payroll (PAY) module. It exposes the report format item configuration used by Oracle Payroll reporting, providing the metadata that governs how report formats, report qualifiers, and report categories are assembled and displayed. The view carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2 and is documented as a date-effective view, meaning access is automatically filtered to the row versions that are effective as of the current application session date rather than the system date.

Rather than returning every historical version of a configuration row, the view resolves the effective date from the FND_SESSIONS table for the caller's session, ensuring that users see the configuration applicable to their session context. This behavior is significant for payroll processing, where report definitions may be changed over time and consistency between the session's effective date and the returned configuration is required.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms: PAY_REPORT_FORMAT_ITEMS_F and FND_SESSIONS. PAY_REPORT_FORMAT_ITEMS_F is the underlying date-effective base table that stores the actual report format item rows, including their effective start and end dates. FND_SESSIONS supplies the session effective date used in the view's WHERE clause.

The view text implements the date-effective filter as follows: rows are returned only where EFFECTIVE_START_DATE is less than or equal to the session effective date and EFFECTIVE_END_DATE is greater than or equal to that same session effective date. The effective date is obtained through two correlated subqueries against FND_SESSIONS, keyed by USERENV('SESSIONID'). Because the view is a simple projection with a filter, inserts and updates are not performed through the view itself; maintenance is directed at the underlying _F table.

Key Columns

• REPORT_TYPE — Identifies the report type to which the format item belongs.
• REPORT_QUALIFIER — The qualifier that distinguishes specific report variants within a report type.
• REPORT_CATEGORY — The category grouping applied to the report format item.
• USER_ENTITY_ID — Identifies the owning user entity, supporting entity-scoped configuration.
• EFFECTIVE_START_DATE — The date from which the row version becomes effective.
• EFFECTIVE_END_DATE — The date through which the row version remains effective.
• ARCHIVE_TYPE — Indicates the archival classification associated with the item.
• UPDATABLE_FLAG — A flag indicating whether the report format item is updatable; this is the column most relevant to searches concerning updatability of report format configuration.
• DISPLAY_SEQUENCE — Controls the ordering in which items are presented.

Common Use Cases and Queries

Typical use cases include identifying which report format items are updatable, sequencing report items for presentation, and retrieving the configuration effective for the current session. Because the view already applies the date-effective predicate, queries need not repeat it.

To list all updatable report format items for a given report type:

SELECT report_type, report_qualifier, report_category,
       display_sequence, updatable_flag
FROM   apps.pay_report_format_items
WHERE  updatable_flag = 'Y'
AND    report_type = :report_type
ORDER BY display_sequence;

To inspect the full effective configuration for a report category:

SELECT report_type, report_qualifier, user_entity_id,
       effective_start_date, effective_end_date,
       archive_type, display_sequence
FROM   apps.pay_report_format_items
WHERE  report_category = :report_category;

Because access is filtered by FND_SESSIONS, results reflect the date-effective state of the calling session, and any attempt to modify configuration should target PAY_REPORT_FORMAT_ITEMS_F directly rather than the view.