Results for “amw_assess_procedures_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view AMW_ASSESS_PROCEDURES_VL is a seeded, translation-enabled (VL, or "view language") database object belonging to the AMW — Internal Controls Manager product within Oracle E-Business Suite. Its defined purpose is to expose assessment procedures, the reusable control-testing and evaluation definitions used by Internal Controls Manager to support an organization's internal control assessment and certification workflows.

The _VL suffix indicates a standard EBS "View Language" construct: the view joins an underlying base/transaction table (AMW_ASSESS_PROCEDURES_B) with its translation table (AMW_ASSESS_PROCEDURES_TL) and filters the translated rows by the current session language. This allows an application or report to query user-facing, language-specific descriptive text (name and description) alongside the language-independent business attributes, without issuing separate joins in each calling program. As such, the view serves as the primary read interface for assessment-procedure reference and reporting.

It is important to note that the ETRM documentation classifies the AMW product as obsolete, and records the view as "Not implemented in this database" in the documented environment. This designation means the object is legacy: it exists in the historical EBS data model and product lineage, but is not deployed in the environment surveyed. Organizations on release 12.1.1 or 12.2.2 should verify actual presence via ALL_OBJECTS before depending on it.

Underlying Base Objects

The view is defined over two documented base objects, joined on the assessment-procedure identifier and the session language:

• AMW_ASSESS_PROCEDURES_B — the base (non-translated) table holding the language-independent attributes of each assessment procedure, prefixed with alias B.
• AMW_ASSESS_PROCEDURES_TL — the translation table holding language-specific NAME and DESCRIPTION text, prefixed with alias TL.

The join condition is B.ASSESS_PROCEDURE_ID = TL.ASSESS_PROCEDURE_ID combined with TL.LANGUAGE = USERENV('LANG'), which restricts results to the caller's current language. No additional referenced objects are documented. Following the standard EBS multilanguage ("MLS") pattern, each base row is expected to have one translation row per installed language.

Key Columns

• ASSESS_PROCEDURE_ID — the primary identifier linking base and translation records; the key business reference for an assessment procedure.
• NAME, DESCRIPTION — the translated, user-facing text sourced from the _TL table.
• START_DATE, END_DATE — the effective date range during which the procedure is active/valid.
• OBJECT_VERSION_NUMBER — the optimistic locking/versioning column used by the Oracle Application Framework (OAF) for concurrency control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard "Who" audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard DFF (Descriptive Flexfield) columns for customer-defined attributes.
• ROWID — the row identifier of the base table record.

Common Use Cases and Queries

Typical uses include validating that active assessment procedures exist for a period, retrieving translated names/descriptions for reports, and joining assessment procedures to associated assessment/control structures.

A sample query listing currently active procedures:

SELECT assess_procedure_id,
       name,
       description,
       start_date,
       end_date
FROM   amw_assess_procedures_vl
WHERE  TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);

Because the view already applies USERENV('LANG'), queries automatically return text in the caller's language, eliminating manual translation joins. Given the product's obsolete status, confirm the object's existence in your instance prior to use, and treat any dependency as legacy reporting rather than a supported integration point.