Search Results amw_process_objectives_vl

Overview

AMW_PROCESS_OBJECTIVES_VL is a language-dependent (VL) view belonging to the AMW product family, Oracle E-Business Suite's Internal Controls Manager module. As documented in ETRM metadata, the view returns information about Process Objectives. It follows the standard EBS multi-language view pattern, joining a base (_B) table that stores language-independent attributes with a translation (_TL) table that stores the language-dependent name and description. In EBS 12.1.1 and 12.2.2, Internal Controls Manager (referred to in the metadata as AMW and classified as obsolete) was used to document, assess, and monitor internal control structures, and process objectives formed a core part of that model by capturing the objectives associated with business processes under review. The _VL view presents a single, user-language-filtered row per process objective, making it suitable for forms, concurrent programs, Oracle Reports, OAF pages, and third-party integrations that require the current session's translated text. It is important to note that the metadata records this object as "Not implemented in this database," meaning the AMW schema may not be installed in every environment, and the view will not exist unless the Internal Controls Manager product has been deployed.

Underlying Base Objects

The documented view text defines AMW_PROCESS_OBJECTIVES_VL over two base objects: AMW_PROCESS_OBJECTIVES_B (alias B), the base table holding language-independent data, and AMW_PROCESS_OBJECTIVES_TL (alias T), the translation table holding language-dependent text. The join condition is B.PROCESS_OBJECTIVE_ID = T.PROCESS_OBJECTIVE_ID, combined with a language predicate T.LANGUAGE = USERENV('LANG'). This restricts translated columns to the language of the current session, so NAME and DESCRIPTION reflect the user's language setting, while all other attributes come exclusively from the _B table. The _VL naming convention signifies a view with language-dependent translated columns that exposes both base and translated attributes in one result set. Although the ETRM metadata lists no separately documented referenced base objects beyond the view text itself, the two tables identified in the SELECT statement are the definitive underlying sources. This pattern is standard across EBS and mirrors how such views are used within the Internal Controls Manager data model.

Key Columns

• ROW_ID / ROWID: The B.ROWID pseudo-column, exposed as the view's row identifier, used by EBS forms and tools for row-level locking and updates.
• PROCESS_OBJECTIVE_ID: Primary key joining the base and translation tables and identifying each process objective.
• OBJECTIVE_TYPE: Classifies the process objective, distinguishing the nature or category of the objective record.
• START_DATE / END_DATE: Define the effective period during which the process objective applies.
• NAME / DESCRIPTION: Language-dependent translated text sourced from AMW_PROCESS_OBJECTIVES_TL, filtered by USERENV('LANG').
• REQUESTOR_ID: Identifies the requestor associated with the process objective.
• SECURITY_GROUP_ID: Supports multi-organization/security-group data partitioning.
• OBJECT_VERSION_NUMBER: Concurrency control column used for optimistic locking by the framework.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN: Standard EBS who-columns capturing audit and creation metadata.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15: Descriptive flexfield (DFF) context and segment columns for customer-defined extensions.

Common Use Cases and Queries

Typical usage involves reporting on and extracting process objectives, joining them to related internal-control entities, or feeding them into audit and compliance dashboards. The view is the natural source for any query that needs translated objective text rather than raw IDs, since it encapsulates the language join. A basic query follows:

SELECT process_objective_id, name, description, objective_type, start_date, end_date
FROM amw_process_objectives_vl
WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date, TRUNC(SYSDATE)) AND NVL(end_date, TRUNC(SYSDATE));

An active-objectives report can filter on effective dates as above; a translation audit can list NAME alongside SECURITY_GROUP_ID to verify partitioning; and an integration extract can select REQUESTOR_ID, OBJECTIVE_TYPE, and the DFF ATTRIBUTE columns for downstream systems. Because Internal Controls Manager is documented as obsolete, environments upgrading to EBS 12.2.2 may find that the view, and its AMW base tables, are absent or superseded. Developers should verify existence via ALL_VIEWS and ALL_TABLES before relying on the object, and confirm the module's installed status with FND_PRODUCT_INSTALLATIONS. Where present, the view remains the recommended, session-language-correct access path for process objective data.