Search Results get_db_user

Overview

EDW_SOURCE_OPTION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API type. Its header declares AUTHID CURRENT_USER, signifying that it executes with the privileges of the invoking user rather than the package owner, which is characteristic of utility and data-warehouse-oriented code. As its name implies — Enterprise Data Warehouse Source Option — the package serves as a source-configuration utility for the EBS data warehouse and Business Intelligence integration layer. It provides a standardized mechanism for resolving configuration options and database user identifiers associated with source systems, products, and objects. The package header is dated 2002 and carries the "noship" designation, indicating it is an internal, non-shipped component. Its documented procedures expose two focused capabilities: retrieving a named source option's value for a given object or product, and resolving the database user associated with a specified product.

Key Procedures and Functions

• GET_SOURCE_OPTION — A function that retrieves the value of a specified source option for a given object. It accepts a product name, object name, object identifier, and option code, and returns the resolved option value through an output parameter. The function returns a Boolean indicating success or failure, making it suitable for conditional logic in calling code.
• GET_DB_USER — A function that resolves and returns the database user name associated with a supplied product name. This capability is central to multi-product EBS environments, where different source applications may be hosted under distinct database schemas. The function returns a VARCHAR2 result containing the resolved user name.

Both functions are modest in scope, reflecting the utility nature of the package. No overloaded variants or additional procedures are documented in the package specification.

Tables Accessed

The package reads from three documented data dictionary views, accessed via APPS synonyms:

• DBA_USERS — Provides authoritative database user account information, used by GET_DB_USER to resolve product-to-schema mappings.
• ALL_USERS — A less-privileged counterpart to DBA_USERS; its presence in the reference list suggests the package may fall back to this view when the invoking user lacks DBA privileges, consistent with the AUTHID CURRENT_USER declaration.
• ALL_DB_LINKS — Supplies information about configured database links, supporting the resolution of source options that reference remote or distributed data warehouse sources.

No application tables or transactional objects are referenced, confirming the package's role as a metadata and configuration resolver rather than a data-processing routine.

Usage Notes

EDW_SOURCE_OPTION is typically invoked from data warehouse integration code, concurrent programs, and custom PL/SQL that must dynamically determine source configuration. The documented reference indicating one other package depends on EDW_SOURCE_OPTION confirms it functions as a supporting utility within a larger call chain rather than as a standalone entry point. The GET_DB_USER function is particularly relevant to environments where custom code queries the database user associated with a product — the search term "get_db_user" maps directly to this function. Because the package is declared AUTHID CURRENT_USER, callers must possess sufficient privileges on DBA_USERS, or the code paths relying on ALL_USERS will be exercised instead. The presence of package-level globals (g_status_message and g_debug) indicates that callers may inspect status messages or enable debugging output during troubleshooting. In Oracle EBS 12.1.1 and 12.2.2, the package remains an internal, non-shipped object; customizations should reference it with caution, as Oracle does not document or guarantee its interface.