Results for “concurrent_program_id”

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

Overview

WSH_REPORT_NAMES_V is a shipping execution view owned by the APPS schema in Oracle E-Business Suite. It is a lightweight dictionary-style view that presents the set of concurrent program definitions which have been registered as reports within Oracle Shipping Execution report sets. Rather than exposing transactional shipping data (deliveries, trips, packing slips, and so on), the view functions as a reporting and integration helper: it answers the question "which concurrent programs are currently associated with a shipping report set, and what are their user-facing names?"

This view is a join between the concurrent program definition layer and the Shipping Execution report set configuration layer. Because it selects from FND_CONCURRENT_PROGRAMS_VL, it returns the translated, user-visible concurrent program name (USER_CONCURRENT_PROGRAM_NAME) rather than the internal program short name.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, WSH_REPORT_NAMES_V is defined over two referenced base objects:

• FND_CONCURRENT_PROGRAMS_VL (VIEW) — the application-facing concurrent program definition view, supplying the translated program name, the owning application, and the concurrent program identifier.
• WSH_REPORT_SET_LINES (SYNONYM) — the Shipping Execution report set line table, which records which concurrent programs are configured as members of each shipping report set.

The view text joins these two objects on APPLICATION_ID and CONCURRENT_PROGRAM_ID, with a DISTINCT clause applied to collapse duplicate rows that would otherwise result from multiple report set lines referencing the same program:

SELECT DISTINCT R.CONCURRENT_PROGRAM_ID,
       F.USER_CONCURRENT_PROGRAM_NAME REPORT_NAME,
       R.APPLICATION_ID
FROM   FND_CONCURRENT_PROGRAMS_VL F,
       WSH_REPORT_SET_LINES R
WHERE  R.APPLICATION_ID = F.APPLICATION_ID
AND    F.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID

Key Columns

• CONCURRENT_PROGRAM_ID — the numeric identifier of the concurrent program, drawn from WSH_REPORT_SET_LINES. This is the standard FND concurrent program key and is used for joins to FND_CONCURRENT_PROGRAMS_VL, FND_CONCURRENT_REQUESTS, and related concurrent manager objects.
• REPORT_NAME — an alias for FND_CONCURRENT_PROGRAMS_VL.USER_CONCURRENT_PROGRAM_NAME, the translated, user-visible name of the concurrent program. This is the display name shown to users when submitting or reviewing shipping reports.
• APPLICATION_ID — the identifier of the application that owns the concurrent program. In this view it is sourced from the report set line (R.APPLICATION_ID), which must equal the concurrent program's APPLICATION_ID for the row to be returned. This column is essential where program identifiers are only unique within an application.

Common Use Cases and Queries

Because a user searching FND_CONCURRENT_PROGRAMS_VL is typically seeking the human-readable name of a concurrent program, this view is commonly used to resolve shipping report set members into readable names, to validate report set configuration prior to concurrent request submission, and to reconcile report set membership against concurrent program definitions after an upgrade or patch.

Typical usage:

-- List all shipping report set members with readable names
SELECT concurrent_program_id,
       report_name,
       application_id
FROM   apps.wsh_report_names_v
ORDER BY report_name;

-- Resolve a specific program by name
SELECT concurrent_program_id, application_id
FROM   apps.wsh_report_names_v
WHERE  report_name LIKE '%Shipping%';

Rows returned by this view reflect only programs that appear in WSH_REPORT_SET_LINES; a valid concurrent program that has not been added to a shipping report set will not appear. For the complete program definition, join CONCURRENT_PROGRAM_ID and APPLICATION_ID back to FND_CONCURRENT_PROGRAMS_VL.