Search Results certification_period_name




Overview
Explore in AI Chat

Overview

AMW_CERTIFICATION_VL is a bilingual (MLS) validation view owned by the APPS schema within the AMW – Internal Controls Manager product in Oracle EBS 12.1.1 and 12.2.2. It exposes certification records held in the Internal Controls Manager module, presenting both the transactional certification data and its translated descriptive attributes in a single queryable interface. The "VL" suffix denotes a view that joins a base (_B) table with its translation (_TL) counterpart, resolving the translated columns to the session language through USERENV('LANG'). This view underpins OAF-based certification pages and provides a stable reporting surface for the Certification business object.

Its principal role is to serve as the read layer for certification data used in internal controls, audit, and compliance reporting, and to support integration and analysis without requiring consumers to handle the _B/_TL join, language filtering, or WHO column setup themselves.

Underlying Base Objects

As documented, the view is defined over two base objects joined on CERTIFICATION_ID:

The defining predicate B.CERTIFICATION_ID = T.CERTIFICATION_ID AND T.LANGUAGE = USERENV('LANG') restricts the translation row to the current runtime language, so the view returns exactly one row per certification for the active session language. No additional referenced base objects are documented in the ETRM metadata.

Key Columns

Common Use Cases and Queries

Typical uses include listing active certifications for a period, tracking completion status against target dates, and joining to the certification statement or financial statement definitions. A representative query:

SELECT certification_id, certification_name, certification_owner_id, certification_status,
       certification_creation_date, target_completion_date, certification_completion_date
  FROM apps.amw_certification_vl
 WHERE certification_status = 'OPEN'
   ORDER BY target_completion_date;

A second query joins to statement groups and financial statements by STATEMENT_GROUP_ID and FINANCIAL_STATEMENT_ID to produce compliance reports. Because the view applies the USERENV('LANG') filter automatically, reports always return translated names; in multi-language environments callers should ensure the session language is set appropriately. All access should respect the standard APPS security and MOAC considerations applied to AMW objects.