Search Results object_key

Overview

AMW_OWNER_ROLES_V is a reporting view owned by the APPS schema within the AMW (Internal Controls Manager) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The view consolidates ownership and role grant information for internal control objects, specifically the owners of processes, risks, and controls managed through the AMW module. Functionally, it answers the question of which party or user holds a named owner role over a specific control, process, or risk instance.

The view is significant because it exposes a normalized representation of role grants joined to human-readable party names, role descriptions, and object names. Rather than requiring report authors or integrators to navigate the FND_GRANTS, FND_MENUS, HZ_PARTIES, and FND_OBJECTS tables independently, AMW_OWNER_ROLES_V presents a flattened, denormalized result set suitable for operational reporting, security auditing, and integration extract.

Underlying Base Objects

The ETRM metadata documents no formal base-object registry entries for this view, but the embedded view text defines its sources precisely. The primary driver is FND_GRANTS, the EBS grants repository, which supplies the grant GUID, start and end dates, instance type, instance primary key values, and menu ID. FND_GRANTS is joined to FND_MENUS and FND_MENUS_TL to resolve menu names and translated user menu names, and to FND_OBJECTS via OBJECT_ID to retrieve the object name.

The grantee is resolved through HZ_PARTIES (aliased GRANTEE_GLOBAL) and FND_USER, with party name formatting applied through HZ_FORMAT_PUB.FORMAT_NAME and an additional subquery against AMW_EMPLOYEES_CURRENT_V for the current employee full name. The WHERE clause restricts the result set to a fixed list of AMW owner menu names: AMW_CTRL_OWNER_ROLE, AMW_AP_OWNER_ROLE, AMW_RL_PROC_OWNER_ROLE, AMW_RISK_OWNER_ROLE, AMW_RL_PROC_APPL_OWNER_ROLE, and AMW_RL_PROC_FINANCE_OWNER_ROLE. It further filters on GRANTEE_TYPE of GLOBAL, an instance type of INSTANCE, and an active grant condition using NVL(GRANTS.END_DATE, SYSDATE+1) >= TRUNC(SYSDATE).

Key Columns

• GRANT_GUID — Unique identifier for the underlying grant record.
• OBJECT_KEY / OBJECT_KEY_TYPE — The instance primary key value (INSTANCE_PK1_VALUE) and instance type, identifying the specific control, process, or risk the grant applies to. These columns are the direct answer to the "object_key" search term.
• PK1_VALUE through PK5_VALUE — Individual instance key components, together with INSTANCE_SET_ID, allowing reconstruction of the full AMW object identity.
• PARTY_NAME / PARTY_NAME_ORIG — The formatted grantee name and its original formatting derived from HZ_FORMAT_PUB.FORMAT_NAME.
• ROLE_NAME / ROLE_DESCRIPTION — The AMW owner menu name, representing the role granted.
• OBJECT_NAME — The FND_OBJECTS name associated with the grant.
• START_DATE / END_DATE — Validity window of the grant.
• USER_NAME — The FND_USER user name tied to the party, where applicable.
• ROW_ID — The GRANTS.ROWID, useful for direct row identification.

Common Use Cases and Queries

Typical uses include listing current owners of all controls, auditing expired versus active role grants, and extracting owner assignments for external GRC or identity-management systems.

To list all active owners against their objects:

• SELECT object_key, object_name, role_name, party_name, start_date, end_date FROM apps.amw_owner_roles_v ORDER BY object_name;

To find owners of a specific object key:

• SELECT role_name, party_name FROM apps.amw_owner_roles_v WHERE object_key = :p_object_key;

To identify grants nearing expiry:

• SELECT object_key, role_name, party_name, end_date FROM apps.amw_owner_roles_v WHERE end_date IS NOT NULL AND end_date < SYSDATE + 30;

Because the view relies on USERENV('LANG') for menu translation, query results reflect the session language of the executing user, which should be accounted for in multilingual deployments.