Search Results pa_system_linkages_v




Overview
Explore in AI Chat

Overview

PA_SYSTEM_LINKAGES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Projects (PA) product family. Its documented status is VALID, and the ETRM metadata classifies it explicitly as "10SC Only," indicating that the view is intended for a specific functional configuration rather than general-purpose use across all Projects implementations. The view exposes linkage definitions that describe how the Projects application associates an external or internal application context with a named system linkage function. In practice, it functions as a lightweight, read-only projection over the underlying linkage configuration table, allowing integrators and developers to resolve application identifiers to their descriptive meanings without querying the base table directly.

Underlying Base Objects

The view is defined over a single documented base object: the synonym PA_SYSTEM_LINKAGES, which resolves to the underlying PA_SYSTEM_LINKAGES table in the APPS schema. The view text performs a straightforward column projection and alias operation, selecting FUNCTION, APPLICATION_ID, MEANING, and DESCRIPTION from that base object. No joins, aggregations, or filtering predicates are documented in the view definition, so the row cardinality of PA_SYSTEM_LINKAGES_V mirrors that of PA_SYSTEM_LINKAGES. Because the view does not reference FND_APPLICATION or any other lookup table in its definition, the MEANING and DESCRIPTION columns are stored values carried through from the base table rather than being resolved at runtime through a join.

Key Columns

  • SYSTEM_LINKAGE_FUNCTION — The documented column list shows the first column as SYSTEM_LINKAGE_FUNCTION, although the view text selects the base column named FUNCTION and applies the FUNCTION alias. This column identifies the system linkage function, i.e., the logical linkage category or purpose that the record describes.
  • APPLICATION_ID — The numeric identifier of the application associated with the linkage record. This value corresponds to an application registration in the EBS application dictionary.
  • MEANING — The user-facing or display name associated with the linkage entry, suitable for presentation in reports and list-of-values queries.
  • DESCRIPTION — A longer free-text explanation of the linkage, typically documenting the intent or scope of the particular function and application pairing.

Because the view is a direct projection, all four columns are exposed exactly as stored, with no derived or calculated values.

Common Use Cases and Queries

The principal use case is diagnostic and reporting: retrieving the set of configured system linkages with their human-readable meanings and descriptions. A typical query selects the function and its descriptive attributes for a specific application context:

  • SELECT system_linkage_function, application_id, meaning, description FROM apps.pa_system_linkages_v; — returns the complete linkage inventory.
  • SELECT meaning, description FROM apps.pa_system_linkages_v WHERE application_id = :app_id; — isolates the linkages registered for a single application.
  • SELECT application_id, meaning FROM apps.pa_system_linkages_v WHERE system_linkage_function = :function_name; — resolves a known function to its associated applications.

Given the "10SC Only" designation in the ETRM documentation, the view should be treated as relevant to deployments operating under that specific configuration. Developers should also note the column-name discrepancy documented above — the view text references FUNCTION while the documented column list names SYSTEM_LINKAGE_FUNCTION — and verify the actual exposed column names against the live data dictionary in their target environment (12.1.1 or 12.2.2) before embedding either name in custom code. As with all APPS-owned views, custom queries should be issued against the APPS synonym and granted through standard EBS permissions.