Search Results fnd_conc_req_summary_v




Overview
Explore in AI Chat

Overview

FND_CONC_REQ_SUMMARY_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, part of the FND – Application Object Library product. It presents a denormalized, human-readable summary of concurrent requests by joining the core transactional request table (FND_CONCURRENT_REQUESTS) to supporting lookup and translation tables for programs, users, and printer styles. Its purpose is to spare report developers and integrators from repeatedly reconstructing the multi-table joins required to render a meaningful concurrent request listing. Instead of raw internal identifiers, the view surfaces resolved values such as the requestor user name, the user-facing concurrent program name, and the effective printer style.

The view carries the ETRM status VALID and is flagged "Retrofitted," indicating it is part of the standard FND object set maintained across releases including 12.1.1 and 12.2.2. Because it is a view rather than a table, it holds no data of its own and always reflects the current state of its underlying base tables at query time. This makes it suitable for ad hoc operational reporting, custom concurrent programs, and integration extracts that need to enumerate and describe concurrent requests by their status, phase, and priority.

Underlying Base Objects

The documented base objects referenced by this view are all accessed through APPS synonyms:

The view is therefore a read-only projection over the concurrent request and program configuration model, with language-sensitive outer joins ensuring rows are not lost when a printer style is undefined.

Key Columns

Common Use Cases and Queries

A frequent requirement is locating a request by its priority grouping or by PRIORITY_REQUEST_ID, which is the term the user searched. The following query lists outstanding requests with their resolved program and requestor names:

  • SELECT request_id, priority_request_id, priority, phase_code, status_code, program, requestor, request_date FROM fnd_conc_req_summary_v WHERE priority_request_id = :p_priority_request_id ORDER BY priority, request_date;
  • SELECT request_id, program, requestor, actual_start_date, actual_completion_date FROM fnd_conc_req_summary_v WHERE phase_code = 'C' AND status_code = 'E' AND actual_completion_date >= SYSDATE - 1;
  • SELECT request_id, program, user_print_style, printer FROM fnd_conc_req_summary_v WHERE hold_flag = 'Y';

These patterns support operational monitoring, error triage, and prioritization reporting. Because the view resolves names and language-specific program titles automatically, it is well suited to custom reports and integration extracts that must present concurrent request data without additional application-layer lookups.