Search Results rg_report_set_req_details




Overview
Explore in AI Chat

Overview

The RG_REPORT_SET_REQ_DETAILS 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. Its primary function is to provide detailed execution tracking for report sets. A report set is a grouping of individual Application Report Generator reports submitted as a single concurrent request. This table acts as a child table, storing a distinct record for every individual report executed within a parent report set submission. It is essential for auditing, troubleshooting, and understanding the runtime composition and status of complex, multi-report submissions.

Key Information Stored

The table's structure is designed to link the individual report execution to its parent set and to the broader concurrent processing framework. The primary key is a composite of REPORT_SET_REQUEST_ID and SEQUENCE, ensuring uniqueness for each report line within a set. Critical foreign key columns establish vital relationships: REPORT_SET_REQUEST_ID links to the RG_REPORT_SET_REQUESTS table, which holds the master record for the report set submission. REPORT_ID links to the RG_REPORTS table, identifying the specific report definition that was run. CONCURRENT_REQUEST_ID links to the FND_CONCURRENT_REQUESTS table, connecting each individual report run to its own concurrent request record, which contains standard execution details like status, phase, completion date, and output/log file locations.

Common Use Cases and Queries

This table is central to operational reporting and diagnostics for report sets. Common use cases include analyzing the performance and success rate of individual reports within historical sets, identifying which specific report within a failed set encountered an error, and generating audit trails of report execution. A typical diagnostic query joins this table to its related master tables to get a complete picture of a report set's execution.

Sample Query:
SELECT rsrd.sequence,
r.report_name,
fcr.request_id,
fcr.phase_code,
fcr.status_code,
fcr.completion_text
FROM rg_report_set_req_details rsrd,
rg_reports r,
fnd_concurrent_requests fcr
WHERE rsrd.report_set_request_id = :p_report_set_request_id
AND r.report_id = rsrd.report_id
AND fcr.request_id = rsrd.concurrent_request_id
ORDER BY rsrd.sequence;

Related Objects

  • RG_REPORT_SET_REQUESTS: The direct parent table. The foreign key RG_REPORT_SET_REQ_DETAILS.REPORT_SET_REQUEST_ID references RG_REPORT_SET_REQUESTS.REPORT_SET_REQUEST_ID.
  • RG_REPORTS: Contains the definitional metadata for the report. The foreign key RG_REPORT_SET_REQ_DETAILS.REPORT_ID references RG_REPORTS.REPORT_ID.
  • FND_CONCURRENT_REQUESTS: The central concurrent processing table. The foreign key RG_REPORT_SET_REQ_DETAILS.CONCURRENT_REQUEST_ID references FND_CONCURRENT_REQUESTS.REQUEST_ID, providing status, timing, and output file details for each individual report run.
  • 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 , 

  • 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_REPORTS 12.2.2

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORTS,  object_name:RG_REPORTS,  status:VALID,  product: RG - Application Report Generator ,  description: Report definitions ,  implementation_dba_data: RG.RG_REPORTS , 

  • Table: RG_REPORTS 12.1.1

    owner:RG,  object_type:TABLE,  fnd_design_data:RG.RG_REPORTS,  object_name:RG_REPORTS,  status:VALID,  product: RG - Application Report Generator ,  description: Report definitions ,  implementation_dba_data: RG.RG_REPORTS , 

  • 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 ,