Search Results oke_role_functions_u1

Overview

The OKE.OKE_ROLE_FUNCTIONS table is a repository of contract role (OKE) security data within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the allowable functions that are assigned to each contract role. The table is not maintained through direct user data entry; rather, it is populated automatically when a role is compiled. During compilation, the list of functions included in the menu referenced by the role definition is expanded and persisted into this table, producing a flattened, queryable representation of role-level function entitlements.

The object resides in the APPS_TS_SEED tablespace, carries a status of VALID, and is registered under the FND Design Data namespace OKE.OKE_ROLE_FUNCTIONS. It is a standard, seed-oriented repository object rather than a transactional table.

The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. Under a Data Vault modeling suggestion, OKE_ROLE_FUNCTIONS behaves like a satellite attached to the role and function hubs, recording the descriptive relationship between them along with audit attributes. It should not be treated as an independent hub.

Key Information Stored

The table contains seven documented columns. The most significant are the two identifier columns that form the composite business key:

• ROLE_ID (NUMBER) — Contract role unique identifier. Together with FUNCTION_ID it forms the primary key OKE_ROLE_FUNCTIONS_PK and the unique index OKE_ROLE_FUNCTIONS_U1.
• FUNCTION_ID (NUMBER) — Function unique identifier. It is the foreign key that references FND_FORM_FUNCTIONS, tying each row to a defined application function.
• CREATION_DATE (DATE) — Standard Who column recording when the compilation populated the row.
• CREATED_BY (NUMBER) — Standard Who column identifying the user or process that created the row.
• LAST_UPDATE_DATE (DATE) — Standard Who column recording the most recent modification timestamp.
• LAST_UPDATED_BY (NUMBER) — Standard Who column identifying the last modifying user.
• LAST_UPDATE_LOGIN (NUMBER) — Standard Who column recording the login session of the last update.

There is no single surrogate primary key column; the primary key is a composite of ROLE_ID and FUNCTION_ID. The unique index OKE_ROLE_FUNCTIONS_U1 (ROLE_ID, FUNCTION_ID) on the APPS_TS_SEED tablespace serves as the business-key candidate and enforces that a given function may be assigned to a given role only once. The remaining columns are standard audit (Who) attributes.

Common Use Cases and Queries

Typical usage centers on role-to-function entitlement reporting and security validation. Because the table is populated only upon role compilation, queries are frequently run to confirm that a compilation has refreshed the correct set of functions.

• Listing all functions granted to a specific role: SELECT FUNCTION_ID FROM OKE.OKE_ROLE_FUNCTIONS WHERE ROLE_ID = :role_id;
• Determining which roles include a particular function: SELECT ROLE_ID FROM OKE.OKE_ROLE_FUNCTIONS WHERE FUNCTION_ID = :function_id;
• Detecting stale or missing compilations by comparing LAST_UPDATE_DATE against the expected compile date.
• Joining to FND_FORM_FUNCTIONS to obtain function names, user function names, and menu context for audit reports.
• Minimum-column extraction, as documented: SELECT ROLE_ID, FUNCTION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN FROM OKE.OKE_ROLE_FUNCTIONS;

These patterns support access reviews, segregation-of-duties analysis, and troubleshooting of contract role visibility issues in the Oracle Contracts (OKE) application.

Related Objects

Dependency metadata indicates that OKE_ROLE_FUNCTIONS does not reference any database object but is referenced by the APPS synonym OKE_ROLE_FUNCTIONS. Its principal foreign-key relationship is to the application function definition table:

• FND_FORM_FUNCTIONS — referenced via OKE_ROLE_FUNCTIONS.FUNCTION_ID = FND_FORM_FUNCTIONS.FUNCTION_ID; supplies the function name, type, and menu context.
• OKE_ROLE_FUNCTIONS (APPS synonym) — the application-facing alias used by concurrent programs and reports.
• OKE_ROLE_DEFINITIONS / contract role definition objects — the source that drives role compilation into this table.
• FND_MENUS and FND_MENU_ENTRIES — the menu structures expanded during role compilation to produce the stored function list.

Because the documented dependency footprint is intentionally narrow, OKE_ROLE_FUNCTIONS should be treated as a derived, compile-time entitlement snapshot rather than a source-of-truth security definition.