Search Results fa_rx_cr_reports_v




Overview
Explore in AI Chat

Overview

The view APPS.FA_RX_CR_REPORTS_V is an Oracle E-Business Suite dictionary object owned by the APPS schema and shipped as part of the OFA (Oracle Assets) product. It is marked VALID and carries the description "Retrofitted," indicating that the definition was adjusted during an upgrade or code retrofit so that it continues to function correctly against the current Oracle EBS data model, particularly in releases 12.1.1 and 12.2.2. The view combines concurrent program definitions with the registered extract/report definitions held in FA_RX_REPORTS, producing a reporting-oriented projection that links each Assets report row to its associated application, request group, responsibility, and concurrent program metadata. Because it exposes the concurrent program ID, the concurrent program name, and the user-facing program name together with the report's interface table and purge API, FA_RX_CR_REPORTS_V serves as a bridge between the Assets report registry and the standard concurrent manager configuration views. It is typically queried when diagnosing or documenting how an Assets report is wired into a request group, how its display name appears to end users, or which interface table and purge routine support it.

Underlying Base Objects

The documented base objects for the view are FA_RX_REPORTS (SYNONYM), FND_APPLICATION_ALL_VIEW (VIEW), FND_CONCURRENT_PROGRAMS_VL (VIEW), FND_GLOBAL (PACKAGE), and FND_REQUEST_GROUP_UNITS (SYNONYM). The view text joins these as follows: FA_RX_REPORTS (aliased RX) supplies the report registry columns such as REPORT_ID, INTERFACE_TABLE, WHERE_CLAUSE_API, PURGE_API, and auditing columns; FND_APPLICATION_ALL_VIEW (aliased A) supplies APPLICATION_NAME; FND_REQUEST_GROUP_UNITS (aliased RGU) supplies the request group association, specifically REQUEST_GROUP_ID and REQUEST_UNIT_ID; and FND_CONCURRENT_PROGRAMS_VL (aliased CP) supplies CONCURRENT_PROGRAM_NAME and USER_CONCURRENT_PROGRAM_NAME. The definition is a UNION of two branches. The first branch links RX.APPLICATION_ID to RGU.APPLICATION_ID and RX.CONCURRENT_PROGRAM_ID to CP.CONCURRENT_PROGRAM_ID, joining the request unit to the concurrent program. The second branch uses RX.APPLICATION_ID = RGU.UNIT_APPLICATION_ID with RGU.REQUEST_UNIT_TYPE = 'A', allowing program-only request units to be matched. FND_GLOBAL is referenced to resolve the runtime current responsibility context.

Key Columns

  • ROW_ID — the ROWID of the underlying FA_RX_REPORTS row; useful for direct row identification.
  • REPORT_ID — primary identifier of the report registration row.
  • APPLICATION_ID / APPLICATION_NAME — the owning application of the report and its descriptive name.
  • RESPONSIBILITY_ID / RESPONSIBILITY_NAME — responsibility association; RESPONSIBILITY_NAME is cast to NULL via TO_CHAR(NULL) in the view definition.
  • REQUEST_GROUP_ID — the request group through which the concurrent program is exposed.
  • CONCURRENT_PROGRAM_FLAG — indicates whether the row resolves to a concurrent program.
  • CONCURRENT_PROGRAM_ID — the concurrent program identifier.
  • CONCURRENT_PROGRAM_NAME / USER_PROGRAM_NAME — the developer and user-facing program names from FND_CONCURRENT_PROGRAMS_VL.
  • INTERFACE_TABLE — the staging interface table used by the extract or report.
  • Auditing columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN.
  • WHERE_CLAUSE_API / PURGE_API — the API used to restrict data and to purge report output.

Common Use Cases and Queries

A typical use is to list every Assets report and the concurrent program that implements it, along with its request group:

SELECT report_id, application_name, user_program_name, concurrent_program_name, request_group_id, interface_table FROM fa_rx_cr_reports_v WHERE application_id = :app_id;

Another scenario filters by concurrent program to confirm which report registration and interface table back a given program, useful before purging or tracing an extract:

SELECT report_id, concurrent_program_name, interface_table, purge_api, where_clause_api FROM fa_rx_cr_reports_v WHERE concurrent_program_id = :cp_id;