Search Results rg_report_set_requests




Overview
Explore in AI Chat

Overview

The RG_REPORT_SET_REQUESTS table is a core data object within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the primary audit and control table for tracking the submission of report sets. A report set is a collection of individual financial reports grouped for concurrent execution. This table records the master request for each submission, capturing essential metadata such as the identity of the report set, the time of submission, and the user who initiated it. Its role is critical for managing and monitoring batch reporting processes, particularly those initiated via the "Multiple Report Sets" functionality within the Run Financial Reports interface, providing a traceable history of report set executions.

Key Information Stored

The table's primary purpose is to store high-level submission data. The most critical column is the REPORT_SET_REQUEST_ID, which serves as the unique identifier (primary key) for each report set submission request. Other significant columns, as inferred from the metadata and standard EBS patterns, include identifiers for the specific report set that was run, the concurrent request ID linking to FND_CONCURRENT_REQUESTS, and the submitting user (likely CREATED_BY). A notable foreign key relationship exists on UNIT_OF_MEASURE_ID to FND_CURRENCIES, indicating the table also stores the currency or unit of measure context for the report set execution, which is vital for accurate financial reporting.

Common Use Cases and Queries

This table is primarily queried for audit trails, troubleshooting, and status monitoring. Common scenarios include identifying all report sets submitted by a specific user within a date range or finding the master request details for a problematic report set run. A typical query would join with FND_CONCURRENT_REQUESTS and RG_REPORT_SETS for a comprehensive view. For example, to track recent submissions:

  • SELECT rrsr.report_set_request_id,
  • rrsr.report_set_id,
  • fcr.request_id,
  • fcr.phase_code,
  • fcr.status_code,
  • rrsr.creation_date
  • FROM rg_report_set_requests rrsr,
  • fnd_concurrent_requests fcr
  • WHERE rrsr.concurrent_request_id = fcr.request_id
  • AND rrsr.creation_date > SYSDATE - 1
  • ORDER BY rrsr.creation_date DESC;

This data is also foundational for custom operational reports on financial reporting activity.

Related Objects

RG_REPORT_SET_REQUESTS is central to a small hierarchy of related objects. It has a direct one-to-many relationship with RG_REPORT_SET_REQ_DETAILS, where the details of individual reports within the submitted set are stored, linked via the REPORT_SET_REQUEST_ID foreign key. As noted, it references FND_CURRENCIES via UNIT_OF_MEASURE_ID. In practice, it is also closely tied to FND_CONCURRENT_REQUESTS (for request status and log files) and the master definition table RG_REPORT_SETS. Any process or interface that submits report sets via the Application Report Generator will populate this table.

  • Table: RG_REPORT_SET_REQUESTS 12.1.1

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORT_SET_REQUESTS,  object_name:RG_REPORT_SET_REQUESTS,  status:VALID,  product: RG - Application Report Generator ,  description: RG_REPORT_SET_REQUESTS tracks submission of report sets. It stores the report set that was submitted, the it was submitted, and who it was submitted by. If the report set was submitted using the Multiple Report Sets tab in the Run Financi ,  implementation_dba_data: RG.RG_REPORT_SET_REQUESTS , 

  • Table: RG_REPORT_SET_REQUESTS 12.2.2

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORT_SET_REQUESTS,  object_name:RG_REPORT_SET_REQUESTS,  status:VALID,  product: RG - Application Report Generator ,  description: RG_REPORT_SET_REQUESTS tracks submission of report sets. It stores the report set that was submitted, the it was submitted, and who it was submitted by. If the report set was submitted using the Multiple Report Sets tab in the Run Financi ,  implementation_dba_data: RG.RG_REPORT_SET_REQUESTS , 

  • Table: RG_REPORT_SET_REQ_DETAILS 12.2.2

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORT_SET_REQ_DETAILS,  object_name:RG_REPORT_SET_REQ_DETAILS,  status:VALID,  product: RG - Application Report Generator ,  description: RG_REPORT_SET_REQ_DETAILS tracks the individual reports that were run for each report set submission. There will be one row in this table for each report run as part of a report set submission. ,  implementation_dba_data: RG.RG_REPORT_SET_REQ_DETAILS , 

  • Table: RG_REPORT_SET_REQ_DETAILS 12.1.1

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORT_SET_REQ_DETAILS,  object_name:RG_REPORT_SET_REQ_DETAILS,  status:VALID,  product: RG - Application Report Generator ,  description: RG_REPORT_SET_REQ_DETAILS tracks the individual reports that were run for each report set submission. There will be one row in this table for each report run as part of a report set submission. ,  implementation_dba_data: RG.RG_REPORT_SET_REQ_DETAILS ,