Search Results object_key

Overview

FND_OBJ_INSTANCE_GRANTS_V is a reporting and integration view in the FND (Application Object Library) product of Oracle E-Business Suite. It exposes a resolved, human-readable projection of the security model that governs which business users may invoke specific function instances, by joining grant records to users, parties, menu-entry role privileges, and form functions. The view is documented as "Not implemented in this database" in the ETRM metadata, indicating that it is a definition shipped with the application schema rather than a standalone database object maintained independently; its behavior is entirely derived from its underlying base tables at query time.

Its principal value is that it collapses the multi-table relationship between role-based grants, the parties and users who hold them, and the executable functions those roles authorize. This makes it suitable for security auditing, user-access reporting, and integration scenarios where an external system needs to determine the effective instance-level grants in effect on a given date.

Underlying Base Objects

The view text is defined over the following base objects:

• FND_GRANTS — the source of grant records, filtered to OBJECT_KEY_TYPE = 'INSTANCE' and to grants currently active by date.
• FND_USER — used to resolve the user (USER_ID) associated with a grant through the customer identifier.
• HZ_PARTIES — links the grant's PARTY_ID to a trading-community party record, which in turn connects to FND_USER via CUSTOMER_ID.
• FND_MENU_ENTRIES — supplies the role-to-function privilege linkage through MENU_ID and FUNCTION_ID.
• FND_FORM_FUNCTIONS — provides the FUNCTION_NAME that corresponds to each granted function.

The join conditions enforce an active-date window, an instance-level object-key scope, and a chain from role menu entry to function, ensuring only valid, currently effective grants are returned. The ETRM metadata lists no separately documented referenced base objects beyond those named in the view text.

Key Columns

• GRANT_ID — unique identifier of the grant record in FND_GRANTS.
• PARTY_ID — the party to whom the grant is issued, used in the join to HZ_PARTIES.
• USER_ID — the application user resolved from the party/customer relationship; the principal subject of the access report.
• OBJECT_NAME — the name of the object to which the instance grant applies.
• OBJECT_KEY — the instance-level key identifying the specific object instance being granted; the user's search term. It is the discriminating value that distinguishes one instance from another under the same OBJECT_NAME.
• FUNCTION_NAME — the user-facing name of the form function authorized through the associated role privilege.

Together, these columns describe who (USER_ID), holds what instance-level authority (OBJECT_NAME, OBJECT_KEY), and may execute which function (FUNCTION_NAME), subject to the grant's effective dates.

Common Use Cases and Queries

Typical uses include auditing which users hold instance grants, tracing a specific object instance back to authorized functions, and feeding access data to external reporting or reconciliation processes. Because the view already restricts results to active grants, queries do not need to repeat the date logic.

Listing active instance grants for a user:

• SELECT USER_ID, OBJECT_NAME, OBJECT_KEY, FUNCTION_NAME FROM FND_OBJ_INSTANCE_GRANTS_V WHERE USER_ID = :user_id ORDER BY OBJECT_NAME, FUNCTION_NAME;

Inspecting the granted instances of a specific object:

• SELECT OBJECT_KEY, USER_ID, FUNCTION_NAME FROM FND_OBJ_INSTANCE_GRANTS_V WHERE OBJECT_NAME = :object_name ORDER BY OBJECT_KEY;

Summarizing grantee counts per object and function:

• SELECT OBJECT_NAME, FUNCTION_NAME, COUNT(DISTINCT USER_ID) AS grantee_count FROM FND_OBJ_INSTANCE_GRANTS_V GROUP BY OBJECT_NAME, FUNCTION_NAME ORDER BY OBJECT_NAME;

These patterns support security review and integration extracts while relying solely on the documented join semantics of the view.