Search Results oks_profiles_visible




Overview
Explore in AI Chat

Overview

OKS_PROFILES_VISIBLE is a lightweight PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an OTHER API. It belongs to the Oracle Knowledge System (OKS) module, commonly associated with Service Contracts and related service management functionality, where visibility of profile options at specific organizational or user levels must be determined at runtime. The package exposes a single public function, PROFILE_VISIBLE_VALUE, whose purpose is to evaluate whether a given profile option value should be considered "visible" for a specific combination of application, profile option, and level context. Unlike the standard FND_PROFILE API, which retrieves profile values, this package focuses on the conditional visibility of those values, a common requirement in service module setups where profile-driven behavior varies by operating unit, organization, or user level.

Key Procedures and Functions

  • PROFILE_VISIBLE_VALUE — The sole documented function in the package. It accepts a set of identifying parameters that specify the application, the profile option, the level definition, the level value, and an optional application identifier for the level value context, and returns a VARCHAR2 result. The function evaluates the stored profile option values against the supplied level context to determine whether the resulting value is visible. Because the ETRM metadata lists only the function signature at a high level, integrators should treat it as a visibility-checking utility rather than a data-mutation routine. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which has implications for how grants and synonyms must be configured in custom deployments.

Tables Accessed

The package references two tables through APPS synonyms. The primary source is FND_PROFILE_OPTION_VALUES, the Oracle Application Object Library table that stores profile option values at various levels (site, application, responsibility, user, and so on). The function reads from this table to determine what value exists for the given level context and whether that value qualifies as visible. DUAL is referenced for syntactic completeness, typically when constructing conditional expressions or default returns. No write operations against these tables are documented, confirming the package's read-only, query-oriented nature.

Usage Notes

OKS_PROFILES_VISIBLE is typically invoked from Forms-based or OAF-based service module setups, or from custom PL/SQL routines that need to mirror the visibility logic applied by the standard profile user interface. It is not referenced by any other documented package, indicating that its consumers are application code, forms, or customizations rather than a shared internal API layer. In Oracle EBS 12.1.1 and 12.2.2 environments, the package remains largely unchanged in behavior, with the only documented revision dating to 2002. Developers embedding this function should ensure that the calling schema has appropriate execute grants and that the level identifiers passed in correspond to valid FND_PROFILE_OPTION_VALUES entries, since the function does not document error handling for invalid level inputs. Given the sparse metadata, functional testing in a non-production environment is advisable before relying on its return values in custom logic.