Search Results fnd_conc_release_classes_vl




Overview
Explore in AI Chat

Overview

The view FND_CONC_RELEASE_CLASSES_VL is an Application Object Library (FND) database object owned by the APPS schema. It presents a "VL" (translated, or "value list") representation of concurrent program release classes, combining the language-independent attributes stored in the base transaction table with the language-dependent, translatable attributes stored in the corresponding translation table. Release classes govern how the Concurrent Manager schedules and resubmits concurrent programs, for example controlling the interval at which a request is automatically resubmitted after it completes.

Because it is a VL view, it automatically enforces the session language through the predicate T.LANGUAGE = USERENV('LANG'), returning exactly one row per release class in the language of the current user session. This makes it the canonical source for reporting and integration logic that needs a single, translated row for each release class. In Oracle EBS 12.1.1 and 12.2.2 it is classified as "Retrofitted," and it is read-only from an application standpoint, deriving all of its content from the underlying synonym targets.

Underlying Base Objects

The view is defined over two documented base objects, both exposed to APPS as synonyms:

The join is performed on the composite key RELEASE_CLASS_ID and APPLICATION_ID, with the additional language filter on FND_CONC_RELEASE_CLASSES_TL. In the view text, alias B denotes the base table and alias T the translation table. All stored columns are taken from B except the user-facing name and description, which are drawn from T as USER_RELEASE_CLASS_NAME and DESCRIPTION. The ROW_ID column is derived from B.ROWID.

Key Columns

Common Use Cases and Queries

The view is typically queried to list enabled release classes, to review automatic resubmission settings, or to join release classes to schedule definitions for integration and diagnostics. A representative query listing resubmission configuration is:

  • SELECT release_class_id, application_id, user_release_class_name, resubmit_interval, resubmit_interval_unit_code, resubmit_interval_type_code, enabled_flag FROM fnd_conc_release_classes_vl WHERE enabled_flag = 'Y';
  • Filtering by application_id to scope results to a single product.
  • Joining to FND_CONC_RELEASE_CLASSES or related schedule tables when the internal name is required alongside translated text.

Because the view depends on USERENV('LANG'), sessions using different language settings will see translated names accordingly, and any integration reading user-facing labels should rely on this view rather than the base table.