Search Results hri_per

Overview

APPS.BIS_GRANTS_V is an internal Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as BIS.BIS_GRANTS_V. It presents grant and delegation information drawn from the Oracle Applications security and function-grant model, exposing data that associates a grantee with menu/function objects, report regions, and delegation parameters. The view carries a status of VALID and is documented as an internal object; Oracle explicitly notes that access to applications data through this object is unsupported except from standard Oracle Applications programs. In EBS 12.1.1 and 12.2.2, such views are used principally by Oracle's own functional administration and security reporting programs rather than by end-user SQL.

Underlying Base Objects

The documented dependency list identifies the base objects over which the view is defined: FND_GRANTS, FND_OBJECTS, FND_MENU_ENTRIES, FND_FORM_FUNCTIONS, and BIS_AK_REGION_ITEM_EXTENSION. FND_GRANTS supplies the core grant rows (grantee, object, start and end dates, and the delegation parameter). FND_OBJECTS and FND_FORM_FUNCTIONS provide the function or object identity against which the grant is issued. FND_MENU_ENTRIES links menu structures to functions, while BIS_AK_REGION_ITEM_EXTENSION supplies region-extension metadata used by the BIS reporting model. The view is in turn referenced by APPS.FII_USER_SEC_OPTIMIZER, indicating that it feeds Oracle's user security optimization logic. ETRM 12.2.2 lists no separately documented referenced base tables, so the dependency list above remains the authoritative statement of lineage.

Key Columns

• GRANTED_TO (VARCHAR2, 240) — identifies the user or grantee receiving the grant or delegation.
• ROLE_ID (NUMBER, 15) — the role or object identifier associated with the grant.
• REPORT_REGION_CODE (VARCHAR2, 30) — the reporting or functional region to which the grant applies.
• GRANTED_FOR (VARCHAR2, 256) — the object or function for which the grant is made.
• DELEGATION_PARAMETER (VARCHAR2, 256) — the parameter controlling delegation of the grant; this is the column most relevant to searches on "delegation_parameter".
• START_DATE / END_DATE (DATE) — the effective window during which the grant or delegation is active.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS auditing columns recording creation and last modification context.

Common Use Cases and Queries

Because the view is marked internal and unsupported for direct access, practical use is limited to diagnostics and security auditing performed alongside supported EBS programs. A typical query retrieves all active grants for a given grantee within a validity window:

• SELECT GRANTED_TO, ROLE_ID, REPORT_REGION_CODE, GRANTED_FOR, DELEGATION_PARAMETER, START_DATE, END_DATE FROM APPS.BIS_GRANTS_V WHERE GRANTED_TO = :grantee AND SYSDATE BETWEEN START_DATE AND END_DATE;
• SELECT GRANTED_TO, GRANTED_FOR, DELEGATION_PARAMETER FROM APPS.BIS_GRANTS_V WHERE DELEGATION_PARAMETER IS NOT NULL ORDER BY GRANTED_TO;
• SELECT REPORT_REGION_CODE, COUNT(*) FROM APPS.BIS_GRANTS_V GROUP BY REPORT_REGION_CODE ORDER BY 2 DESC;

These queries support troubleshooting of function security, delegated administration, and report-region access. Any production use should be validated against Oracle Support policy, since the object is documented as internal and reserved for standard Oracle Applications programs.