Results for “set_default_context”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EDW_SEC_PKG is a PL/SQL package body owned by the APPS schema that implements the data-security (row-level access) framework for the Oracle E-Business Suite Enterprise Data Warehouse (EDW) and Daily Business Intelligence (DBI) reporting layer. Its principal responsibility is to evaluate the security profile of the currently connected application user and to constrain warehouse queries so that each user sees only the dimensions, facts, level members, item sets, and reference data they are authorized to access. The package also establishes the session context that downstream EDW reporting objects rely upon when filtering data. It is classified under ETRM as an OTHER API, indicating that it is primarily an internal engine rather than a published interface for external callers, and it is not referenced by any other database object.

Key Procedures and Functions

  • SET_CONTEXT — Populates the session-level security context used by EDW reporting views and queries, establishing the identity and access parameters for the current session.
  • SET_DEFAULT_CONTEXT — Assigns the default security context applied when a user has no explicit dimensional access records, ensuring predictable fallback behavior during report execution.
  • LINK_AOL_USER — Associates the current FND_USER with the corresponding EDW/HR person record, providing the linkage between the EBS application user and the warehouse security model (via EDW_HR_PERSON_M).
  • DIM_SEC — Resolves and applies dimension-level security, determining which dimension members a user may query based on the EDW_SEC_* configuration tables.
  • DEFAULT_SEC — Applies the default security rule set when explicit per-user or per-dimension grants are absent.

The package depends on EDW_SEC_UTIL and EDW_OWB_COLLECTION_UTIL for shared security and collection routines, uses DBMS_SESSION and DBMS_UTILITY for session manipulation, and reads FND_PROFILE for site and user profile option values.

Tables Accessed

The package reads configuration and control tables and writes diagnostic information:

Usage Notes

EDW_SEC_PKG is not exposed as a general-purpose API and is not referenced by any other package. It is invoked internally at the start of EDW/DBI report execution and by warehouse collection programs to initialize session security before data is queried. Because it calls DBMS_SESSION to set context, it should be executed within the user's session and is not suited to run under a privileged background profile that bypasses security. The package is documented as VALID in ETRM for release 12.1.1, and the same behavior carries into 12.1.1 and 12.2.2 EBS installations. Customizations should avoid reimplementing security checks; instead they should invoke this package or the EDW_SEC_UTIL helpers so that row-level filtering remains consistent with standard warehouse reporting.