Search Results validate_application




Overview
Explore in AI Chat

Overview

BIS_APPLICATION_PVT is a private PL/SQL package in the APPS schema that supplies the application-registry layer of the Oracle EBS Business Intelligence System (BIS) product family. Its role is to expose the set of Oracle E-Business Suite applications installed in the current environment — identified by application ID, short name, and display name — to other BIS components such as the Balanced Scorecard and Enterprise Performance Foundation reporting stacks. The package retrieves that registry from the FND application views and wraps it in a strongly typed PL/SQL collection so that calling packages can iterate the installed applications without issuing direct SQL against the foundation schema.

As a PVT (private) API, the package is not part of Oracle's published, supported integration surface. It is invoked internally by BIS packages and is documented here for diagnostic and troubleshooting purposes only; direct calls from customer code are unsupported.

Key Procedures and Functions

The ETRM metadata records four documented program units, of which three are named:

  • RETRIEVE_APPLICATIONS — Populates an out-bound PL/SQL table with one record per installed application, including the application ID, application short name, and application name. This is the entry point referenced by the user's search term "retrieve_applications". It is the routine that other BIS packages call when they need the full list of registered applications.
  • VALIDATE_APPLICATION — Verifies that a supplied application identifier or short name corresponds to a valid, installed application. It is used as a defensive check before BIS code persists data keyed to an application.
  • VALUE_ID_CONVERSION — Converts between the internal application identifier and its externally meaningful value (typically the application short name or display name). It supports lookups where one representation of an application must be translated into the other.

The fourth documented entry corresponds to the package-level declaration section (the G_PKG_NAME constant and the Application_Tbl_Type used by RETRIEVE_APPLICATIONS) rather than an additional callable routine.

Tables Accessed

The package's documented table reference is PLITBLM, the PL/SQL table PL/SQL-Table intermediate storage table used by Oracle's PL/SQL Table (PLITBLM) mechanism. This is consistent with the package's use of associative-array collection types for returning lists of applications rather than relying exclusively on SQL result sets.

In addition, the source header and the retrieval logic draw the application list from the FND foundation views — notably FND_APPLICATION_VL, the translated view over FND_APPLICATION that supplies APPLICATION_ID, APPLICATION_SHORT_NAME, and APPLICATION_NAME. Reads are effectively read-only: the package does not write to FND tables. Any writes implied by the PLITBLM reference are internal to the collection/table mechanism and not a business-data modification.

Usage Notes

BIS_APPLICATION_PVT is referenced by three other packages in the BIS layer, which call RETRIEVE_APPLICATIONS to seed application lists used in scorecard and reporting setup. It is not exposed through a concurrent program or a standard EBS form menu; invocation occurs from within BIS PL/SQL code, typically during page or scorecard rendering when the set of available applications must be presented or filtered.

Because the package follows the FND_API error-handling convention — setting X_RETURN_STATUS to G_RET_STS_SUCCESS or G_RET_STS_ERROR and raising FND_API.G_EXC_ERROR — callers must check the return status before consuming the application table. When diagnosing missing applications in a BI dashboard, RETRIEVE_APPLICATIONS is the appropriate routine to inspect, since its cursor orders results by UPPER(APPLICATION_NAME) and filters solely through FND_APPLICATION_VL. Applications absent from that view will not appear in any BIS-dependent list. Custom development should prefer the supported FND application APIs over direct calls to this private package.