Search Results ad_feature_vers_pkg

Overview

AD_FEATURE_VERS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Applications DBA (AD) product family, which underpins the technical infrastructure of the EBS application tier. The package provides a controlled programmatic interface for loading and maintaining rows in the AD_FEATURE_VERSIONS table, which records the version and enablement status of application features across the E-Business Suite environment.

Feature version tracking is significant during patching, upgrades, and migrations. Each release of EBS introduces or modifies functional features, and the framework must capture which version of a given feature is present in the database and whether that feature is currently enabled. The RCS (Revision Control System) attributes recorded alongside each row link a feature to its source control file and revision keywords, supporting the patch driver infrastructure in determining applicable file versions. This package was introduced in the 11.5.x code line; its header ($Header: adufeats.pls 115.0) indicates it was shipped as version 115.0 in 2003 and it remains present in both 12.1.1 and 12.2.2. Its AUTHID CURRENT_USER designation means it executes with the privileges of the calling user rather than the definer, which is consistent with packages designed to be invoked by privileged patching and administration sessions.

Key Procedures and Functions

• LOAD_ROW — The sole documented procedure in the package. It accepts a feature name, a database version number, an enabled flag, an RCS file keyword, and an RCS version keyword, and loads the corresponding row into AD_FEATURE_VERSIONS. The procedure implements the standard EBS row-loading convention used by AD-era seed data utilities: the caller supplies the attribute values, and the procedure performs the merge into the target table, inserting or updating the record as appropriate. Because the package exposes a single procedure, it functions as a targeted utility rather than a general-purpose feature management API.

Tables Accessed

• AD_FEATURE_VERSIONS — The only table referenced through APPS synonyms. The package reads and writes this table to persist feature version metadata. The columns implied by the LOAD_ROW interface are the feature name, database version, enabled flag, RCS file keyword, and RCS version keyword, which together identify a feature and its current state within the instance.

Usage Notes

AD_FEATURE_VERS_PKG is a low-level utility rather than an end-user API. It is typically invoked by patch and upgrade infrastructure, seed data loaders, and administrative scripts that need to register or refresh feature version information in AD_FEATURE_VERSIONS. It is not exposed through standard EBS forms or concurrent programs in a documented manner, and the ETRM metadata records no other packages referencing it, indicating a narrow call surface.

Because the procedure writes directly into a core AD table, it should be invoked only within supported patching, cloning, or migration operations, or by custom code deliberately extending the feature-version framework. Direct invocation outside these scenarios risks introducing inconsistent feature version records that could affect patch applicability decisions. The use of AUTHID CURRENT_USER means the invoking session must hold the required privileges on AD_FEATURE_VERSIONS; typically this is satisfied when the package is called as APPS or another account with appropriate grants.