Search Results multi_profile_value_specific




Overview
Explore in AI Chat

Overview

FND_AOLJ_UTIL is a utility package in the APPS schema of Oracle E-Business Suite, valid and present in both release 12.1.1 and 12.2.2. Its name reflects its role as the server-side companion to "AOL/J," the Java-based application object library infrastructure that EBS uses for session management, Java class loading, and connectivity between the Oracle Forms-based application tier and the Oracle Application Framework (OAF) / Java middle tier. The package is classified in ETRM as a UTIL (utility) API rather than a business API, meaning it does not enforce business rules or own transactional data; instead it provides low-level helper logic consumed by the AOL/J Java stack and by internal framework code. Typical responsibilities include creating and validating an AOL/J session identifier, resolving stored Java class versions from the database, managing the NLS (National Language Support) context for the database session, and rendering diagnostic output for AOL/J establishment routines. Because it sits beneath the user-facing application, it is rarely invoked directly by end users but is exercised on virtually every connection established against the EBS instance.

Key Procedures and Functions

ETRM documents eight callable units within the package. Their names indicate the following purposes:

  • MULTI_PROFILE_VALUE_SPECIFIC — Retrieves or resolves a profile option value in a manner specific to the AOL/J runtime context, supporting the multiple-profile-value model used by EBS profile options.
  • SET_NLS_CONTEXT — Establishes or resets the National Language Support context for the current database session, ensuring that language-, territory-, and character-set-dependent behaviour is correct for the connected user.
  • GETCLASSVERSIONFROMDB — Reads version information for Java classes stored in the database, allowing the AOL/J tier to detect and honour the correct class version when loading Java components.
  • CREATESESSION — Creates an AOL/J session, the foundational step that binds a middle-tier request to an authenticated EBS session.
  • IS_VALID_ICX — Validates an ICX (Oracle Applications Framework) session token or context, returning whether the supplied session is still valid.
  • CONVERTGUESTSESSION — Converts an anonymous or guest AOL/J session into an authenticated user session, as occurs when a public page is followed by a login.
  • DISPLAY_AOLJ_RUP — Emits AOL/J runtime diagnostic or "RUP" (runtime update / rendering) information, used for tracing and debugging the AOL/J establishment path.

Tables Accessed

The documented table references are made through APPS synonyms and are consistent with the package's session-management role:

  • FND_USER — consulted to resolve and validate the application user associated with a session, supporting session creation, guest-to-user conversion, and validation routines.
  • USER_OBJECTS — queried to confirm the existence and state of database objects, a common technique for version detection and dependency verification such as in GETCLASSVERSIONFROMDB.
  • DUAL — used for single-row evaluations and expression resolution.
  • DBMS_JAVA — the Oracle Java stored-procedure support package used to interact with the in-database Java environment.

Usage Notes

FND_AOLJ_UTIL is an internal framework package. It is not exposed as a concurrent program and is not normally called from Oracle Forms or from customer-written code. It is invoked by the AOL/J Java middle tier and by related APPS packages during session establishment, validation, guest-session conversion, and Java class version checks. ETRM records no other APPS packages as referencing it, which underscores its position at the base of the dependency stack. Customisations should avoid calling it directly, since its behaviour is tied to the AOL/J runtime and its interface may change between patches; developers needing session information should use higher-level, supported APIS. The package remains VALID in both 12.1.1 and 12.2.2, with no functional difference implied by the release upgrade.