Search Results obsolete_flag

Overview

The PA_RP_DEFINITIONS_VL view is a public, language-specific (VL) view owned by the APPS schema within the Oracle Projects (PA) module. It presents definition records for Project Resource Planning templates and related reporting definitions, exposing both descriptive (translatable) attributes and transactional control attributes. The "_VL" suffix indicates that the view joins a base table holding language-independent data to a translation table, filtering translation rows by the session language through USERENV('LANG'). This design allows Oracle EBS forms, concurrent programs, and external reports to retrieve a single, language-appropriate row per definition without handling translation joins themselves.

The view is available in Oracle EBS 12.1.1 and 12.2.2 and retains a VALID status. It serves as the standard read interface for consumers needing template definitions, particularly the TEMPLATE_START_DATE and TEMPLATE_END_DATE columns that govern the effective period of each template, and the OBSOLETE_FLAG that marks retired definitions.

Underlying Base Objects

The view is documented as being defined over two synonyms:

• PA_RP_DEFINITIONS_B — the language-independent base table holding operational columns such as RP_ID, RP_TYPE_ID, DT_PROCESS_DATE, RP_FILE_ID, TEMPLATE_START_DATE, TEMPLATE_END_DATE, OBSOLETE_FLAG, OBJECT_VERSION_NUMBER, and standard WHO audit columns.
• PA_RP_DEFINITIONS_TL — the translation table providing RP_NAME, EMAIL_TITLE, EMAIL_BODY, and DESCRIPTIONS for the applicable language.

The join condition is T.RP_ID = B.RP_ID AND T.LANGUAGE = USERENV('LANG'), ensuring one translated row is returned per base definition. The view also exposes the base table ROWID as ROW_ID to support row identification in forms.

Key Columns

• RP_ID — primary identifier of the resource planning definition.
• RP_TYPE_ID — foreign key identifying the definition type or category.
• RP_NAME — the translated name of the template or definition.
• TEMPLATE_START_DATE / TEMPLATE_END_DATE — the effective date range of the template; these columns are central to date-based filtering and are the fields most frequently referenced by users searching for template start dates.
• OBSOLETE_FLAG — indicates whether the definition has been retired from active use.
• DT_PROCESS_DATE and RP_FILE_ID — the process date and associated file reference for the definition.
• EMAIL_TITLE / EMAIL_BODY — translated content used for notification correspondence.
• DESCRIPTIONS — translated free-text description.
• OBJECT_VERSION_NUMBER — supports optimistic locking.
• CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical use cases include validating template effective periods, identifying active (non-obsolete) templates, and joining definitions to planning/reporting data by RP_ID. A representative query to find templates by start date is:

SELECT rp_id,
       rp_name,
       template_start_date,
       template_end_date,
       obsolete_flag
FROM   apps.pa_rp_definitions_vl
WHERE  template_start_date >= :p_from_date
AND    obsolete_flag = 'N'
ORDER BY template_start_date;

Because translation is resolved internally through USERENV('LANG'), callers do not add language predicates; the view returns translation rows appropriate to the session. This makes PA_RP_DEFINITIONS_VL the preferred interface for localized reporting and integration over its underlying base and translation tables.