Search Results fnd_value_sets




Overview
Explore in AI Chat

Overview

ADI_SECURITY_API is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its documented purpose, expressed in the header comment of the source, is to retrieve a list of expansion values from FND_VALUE_SETS. In the context of Oracle EBS 12.1.1 and 12.2.2, this places the package within the Oracle Application Data Installer (ADI) / Application Desktop Integrator (ADI) integration layer, which governs how desktop tools such as Web ADI and the ADI spreadsheet interface access Flexfield value set definitions and their associated expansion values.

The package has been progressively reduced in scope over its lifecycle. The header records that on 15-NOV-02, the developer GHOOKER stubbed out procedures not used by RM8 (Release Management 8), leaving the package body effectively empty in the version documented. Earlier modifications included the addition of a Package_Revision procedure (16-FEB-00, Task 3858) intended to capture the revision number of the package at runtime, and the relocation of the $Header comment with the removal of the CREATE OR REPLACE clause from the top of the file (16-MAY-00). The version stamped in the header is 120.0, dated 2006/12/14, and carries the "noship" designation.

Key Procedures and Functions

The documented package metadata lists zero procedures or functions. This is consistent with the source excerpt, which shows the package body consisting solely of comments and an immediate END statement. Any procedures named in the modification history—most notably Package_Revision—were stubbed out or removed and are not part of the delivered body.

  • Package_Revision — recorded in the modification history as having been added on 16-FEB-00 to capture the package revision number during runtime. The 15-NOV-02 change note indicates procedures unused by RM8 were stubbed out; the procedure is not documented as active in the delivered body.
  • Expansion value retrieval logic — the descriptive comment states the package retrieves a list of expansion values from FND_VALUE_SETS. No callable procedure or function implementing this behavior is documented in the delivered body.

Because the documented procedure count is zero, no parameter lists are described, and none should be assumed.

Tables Accessed

The only table referenced in the documentation is FND_VALUE_SETS, accessed through an APPS synonym. FND_VALUE_SETS is the Oracle Application Object Library (FND) table that stores Oracle Flexfield value set definitions. A value set defines the set of valid values available to a flexfield segment, and the "expansion values" referenced in the package comment relate to the individual values produced by a value set—particularly for table-validated or independent value sets where the list of allowable segment values must be resolved at runtime.

The documented metadata names no additional tables and records no synonyms beyond this reference. Because the delivered body is stubbed, no live SQL against FND_VALUE_SETS is executed by this package in its shipped form.

Usage Notes

  • Callers: The package is documented as referenced by zero other packages, indicating it is not a dependency of any shipped APPS package in the documented configuration.
  • Invocation context: Given its ADI naming and its stated purpose of resolving value set expansion values, the package historically supported desktop integration components—Web ADI uploads and downloads, ADI spreadsheet interfaces, and flexfield value validation—rather than forming part of the core Flexfields engine.
  • Forms and concurrent programs: No form, concurrent program, or request is documented as invoking this package. No concurrent program registration is implied by the metadata.
  • Custom code: Because the body is a stub, custom code should not depend on any behavior from ADI_SECURITY_API. Implementations requiring expansion values from FND_VALUE_SETS should query the FND value set tables directly or use the supported FND Flexfields APIs.
  • Upgrade behavior: The stub-out performed for RM8, combined with the "noship" header designation, indicates the package is retained only for historical or compatibility reasons and carries no active application logic in 12.1.1 or 12.2.2.

In summary, ADI_SECURITY_API is a functionally inert package body in the documented releases. Its significance is historical: it records the migration of value set expansion logic out of the ADI security layer and into supported FND infrastructure.