Search Results set_profile

Overview

ADX_PRF_PKG is a utility package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is the programmatic management of profile options, specifically the setting of profile option values via AutoConfig. In Oracle EBS, profile options act as the central configuration mechanism that governs application behavior at the Site, Application, Responsibility, and User levels. The package provides a controlled interface for writing those configuration values directly into the underlying profile tables rather than requiring an administrator to navigate the Profile Options form manually. This is particularly valuable during automated configuration, cloning, or migration activities, where profile values must be applied consistently across environments without human intervention. The package is classified as an "OTHER" API rather than a public, supported interface, which signals that it is intended primarily for internal and AutoConfig-driven use.

Key Procedures and Functions

The package exposes two documented procedures.

• SET_PROFILE — The primary procedure. As its name and the accompanying comment indicate, its function is to set a profile option value through AutoConfig. The header comment confirms it accepts a wide range of arguments describing the profile option being modified, including the application identifier, the profile option name, the profile level and level value, the profile value itself, the level value application identifier, a context name, and control flags for update-only and insert-only behavior. The procedures never invent parameter lists, but the documented signature shows parameters such as p_application_id, p_profile_option_name, p_level_id, p_level_value, p_profile_value, p_level_value_app_id, p_context_name, p_update_only, p_insert_only, and p_level_value2. These parameters allow the caller to target a specific profile option at a specific hierarchy level and write a specific value, while optionally restricting the operation to updates or inserts alone.
• PRINTLN — An internal helper, as noted in the source comment "PRINTLN (Internal)." Its documented role is to print messages as needed, accepting a single message argument. It is used for diagnostic or informational output during profile-setting operations, most likely routing text to DBMS_OUTPUT.

Tables Accessed

According to the documented metadata, the package references the following objects via APPS synonyms:

• FND_PROFILE_OPTIONS — The definition table for profile options. It is read to resolve the profile option name into its internal identifier before a value can be written.
• FND_PROFILE_OPTION_VALUES — The table that stores the actual assigned profile values at each level. This is the primary target for the SET_PROFILE write operation.
• DBMS_OUTPUT — The standard Oracle-supplied output package, used by PRINTLN to emit diagnostic messages.
• TAB — A generic reference, likely appearing in the package source for internal queries or as a placeholder.

Usage Notes

ADX_PRF_PKG is typically invoked by AutoConfig during environment configuration and cloning, where profile option values must be set deterministically. The update-only and insert-only flags in SET_PROFILE let callers control whether an existing value is modified or only a new value is inserted, which prevents unintended overwrites during automated runs. Because the package is classified as an OTHER API and is referenced by zero other packages, it should not be treated as a supported integration point for general customizations. Custom code should prefer the supported FND_PROFILE API for setting profile values, reserving ADX_PRF_PKG for scenarios that specifically replicate AutoConfig behavior. The PRINTLN helper is internal and not intended for external invocation.