Search Results fnd_oracle_userid_s

Overview

AD_UTIL is a foundational utility package body owned by the APPS schema in Oracle E-Business Suite, shipped in both Release 12.1.1 and 12.2.2. Its classification in the E-Business Suite Technical Reference Manual (ETRM) is UTIL, indicating that it provides low-level infrastructure services rather than end-user business functionality. The package is used primarily by the Oracle Applications Object Library (AD) administrative layer to manipulate database metadata, manage schema-level configuration, and align EBS product registration and Oracle user identity information with the underlying database dictionary. Because AD_UTIL performs privileged DDL and dictionary operations, it is an internal, Oracle-maintained component; customers are not expected to modify it, and it is not referenced by any other database object, as confirmed by the documented dependency analysis.

Key Procedures and Functions

The documented package exposes six procedures or functions. Three are named explicitly in the ETRM metadata excerpt; the remaining members are internal helpers. The named procedures are:

• UPDATE_COLUMN — Modifies the definition of a database column through dynamic SQL. It is the general-purpose routine used by the AD administration layer to alter column attributes on registered tables during patching, upgrade, or product installation activities.
• UPDATE_ORACLE_ID — Maintains and refreshes Oracle user identifier information. This routine is the reason the package references FND_ORACLE_USERID and FND_ORACLE_USERID_S, and it is the object most closely associated with the user search term "fnd_oracle_userid_s." It synchronizes the identity records that map EBS application users to database accounts.
• SET_PROD_TO_SHARED — Sets the status of a product's schema objects to a shared configuration. It is used when multiple EBS products must share a single Oracle schema and associated data groups.

Because these routines execute DDL and DML against data dictionary views, they are typically guarded by privilege checks and are invoked only from privileged administrative sessions.

Tables Accessed

AD_UTIL reads and writes a well-defined set of EBS and dictionary objects, accessed through APPS synonyms:

• FND_ORACLE_USERID and FND_ORACLE_USERID_S — The primary and secondary tables holding Oracle user ID mappings. These are the core tables for the UPDATE_ORACLE_ID routine.
• FND_APPLICATION, FND_DATA_GROUPS, and FND_DATA_GROUP_UNITS — Application registration and data group membership data used to determine which products share which schemas.
• FND_PRODUCT_INSTALLATIONS — Tracks which EBS products are installed and their status, supporting the SET_PROD_TO_SHARED logic.
• ALL_TABLES, ALL_TAB_COLUMNS, DBA_SYNONYMS, and USER_SYNONYMS — Data dictionary views consulted by UPDATE_COLUMN to validate object existence and column attributes before issuing DDL.
• DUAL, DBMS_OUTPUT, and DBMS_SQL — Supporting constructs for dynamic SQL execution and diagnostic output.

Usage Notes

AD_UTIL is an internal utility invoked by the AD administration tools — notably AutoPatch (adpatch), AD Administration (adadmin), and the AD Worker (adworker) processes — during patching, upgrade, and product installation. It is not exposed through standard EBS forms or concurrent programs and is not documented as a public API for customer use. Custom code should not call AD_UTIL directly, because its procedures assume privileged execution context and may perform unrecoverable DDL. The frequent reference to FND_ORACLE_USERID_S reflects the package's role in maintaining user-ID synchronization during administrative operations. As with all AD-layer utilities, any modification is unsupported and may invalidate the package; only Oracle-provided patches should alter its body.