Search Results certification_completion_date

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:

• AMW_CERTIFICATION_B — the base (transactional) table holding certification identifiers, ownership, dates, status, results, and descriptive flexfield/attribute columns.
• AMW_CERTIFICATION_TL — the translation table holding CERTIFICATION_NAME and CERTIFICATION_DESCRIPTION per language.

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

• CERTIFICATION_ID — Primary key linking the base and translation records; the join key and primary filter for queries.
• ROW_ID, OBJECT_VERSION_NUMBER — ROWID of the base row and the optimistic-locking version number used by the OAF framework.
• CERTIFICATION_OWNER_ID — The owner (typically a user or party) accountable for completing the certification.
• CERTIFICATION_TYPE, CERTIFICATION_STATUS, CERTIFICATION_RESULT — Classify the certification, its lifecycle state, and its outcome.
• CERTIFICATION_CREATION_DATE, TARGET_COMPLETION_DATE, CERTIFICATION_COMPLETION_DATE, LAST_REMINDER_DATE — Key dates driving scheduling and reminders.
• CERTIFICATION_PERIOD_NAME, CERTIFICATION_PERIOD_SET_NAME, CERTIFICATION_REMINDER — Period context and reminder configuration.
• CERTIFICATION_NAME, CERTIFICATION_DESCRIPTION — Translated descriptive columns sourced from the _TL table.
• STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID — Links to the associated statement group and financial statement definitions.
• ORIG_SYSTEM_REFERENCE, OBJECT_TYPE — Identify the source system and object type for the certification.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1–15 — Standard WHO and descriptive flexfield 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.