Search Results fnd_release




Overview
Explore in AI Chat

Overview

FND_RELEASE is a foundational Oracle E-Business Suite (EBS) utility package owned by the APPS schema and delivered as a VALID package body. Its business function is to expose the release and version identity of the EBS application environment to any component that must behave differently depending on the installed release level. Rather than requiring each form, concurrent program, or custom routine to hard-code a release string, the package centralizes the retrieval and interpretation of release information, providing a single authoritative source for the installed product group release.

In Oracle EBS 12.1.1 and 12.2.2 environments, this capability is important because the code base, the schema objects, and the technology stack (such as the adoption of the WebLogic-based application tier in 12.2.2) all vary by release. The package allows dependent logic to detect capabilities and conditionally enable behavior without manual maintenance. It is classified by the reference documentation as an API of type OTHER, reflecting that it is an internal utility API rather than a public business API.

Key Procedures and Functions

The documented package exposes seven procedures and functions:

  • GET_RELEASE — the primary entry point that retrieves the current release information for the environment.
  • RELEASE_NAME — returns the release name, typically the product release designation (for example, "12.2.2") used for display or comparison.
  • RELEASE_INFO — returns consolidated release information, allowing callers to obtain the release details in a single invocation.
  • MAJOR_VERSION — returns the major version component of the release, the leading portion used for coarse-grained version checks.
  • MINOR_VERSION — returns the minor version component, the second segment of the release number.
  • POINT_VERSION — returns the point version component, the third segment of the release number.
  • RESULT — reports the outcome of a release lookup, supporting callers that must verify success or failure of a retrieval operation.

Collectively, these functions permit both a single release string and its discrete numeric components to be obtained and validated by calling code.

Tables Accessed

FND_RELEASE references the table FND_PRODUCT_GROUPS through an APPS synonym. This table stores one row per installed Oracle EBS product group and holds the release information maintained during installation, upgrade, and patch application. The package reads from it only; no insert, update, or delete operations are documented. Because release data is sourced from this table, the information returned by the package reflects the actual installed release stored in the database rather than any application-tier configuration value.

Usage Notes

The release documentation records that FND_RELEASE is referenced by 36 other database objects and depends on the SYS STANDARD package, confirming its role as a low-level utility consumed broadly throughout the EBS code base. It is typically invoked from Oracle Forms, concurrent programs, and custom PL/SQL that must branch on the installed release. Because the release is read from FND_PRODUCT_GROUPS at runtime, callers should invoke the package at the point of need rather than caching values persistently across upgrades. Custom code should treat the package as a read-only service, relying on the documented version accessors instead of parsing release strings independently; doing so ensures compatibility when the environment is patched or upgraded between 12.1.1 and 12.2.2.