Search Results fnd_client_info




Overview
Explore in AI Chat

Overview

APPS.FND_CLIENT_INFO is a core Oracle E-Business Suite package body that manages the session-level context information associated with a database connection made on behalf of an EBS application user. Its fundamental business purpose is to establish and maintain the "client info" attributes that Oracle's DBMS_APPLICATION_INFO facility exposes through V$SESSION and related dynamic performance views. By populating these attributes, the package enables database administrators and support personnel to identify which EBS user, responsibility, organization, and application are responsible for a given database session. Beyond diagnostics, FND_CLIENT_INFO also establishes organizational, currency, and security group context used by Multi-Org and related features. In the ETRM metadata for release 12.2.2 the object is reported as VALID under the APPS schema and is classified as an "OTHER" API. It is not referenced by any other database object, which confirms that it operates as a low-level context-setting utility invoked directly by the forms and runtime layers rather than being called programmatically by dependent PL/SQL units.

Key Procedures and Functions

The documented interface exposes six procedures and functions:

  • SETUP_CLIENT_INFO — The principal entry point. It initializes the client information for the session, deriving identifying values such as the application, responsibility, and user from the EBS runtime and forwarding them to DBMS_APPLICATION_INFO.
  • SET_ORG_CONTEXT — Establishes the current organization (Org ID) context for the session, supporting Multi-Org Access Control so that subsequent queries are restricted to the correct operating unit or inventory organization.
  • SET_CURRENCY_CONTEXT — Sets the session currency context, allowing downstream logic and reporting to determine the functional or reporting currency in effect for the user's responsibility.
  • SET_SECURITY_GROUP_CONTEXT — Applies the security group context, which governs which set of operating units and data a responsibility may access under security group enforcement.
  • ORG_SECURITY — Relates to organization-level security handling, participating in the validation or application of the org security rules for the session.

The metadata lists six documented procedures in total; the remaining item completes the context-setting surface. Parameter lists are intentionally omitted here, as the ETRM extract does not document them.

Tables Accessed

Dependency information shows the package body reading FND_PRODUCT_GROUPS, which supplies installation-wide identifiers such as the product group and release information used to contextualize the session. It also depends on DBMS_APPLICATION_INFO and DBMS_UTILITY, the standard Oracle-supplied packages used to write session attributes and to obtain call stack or depth information. Additional dependencies include FND_GLOBAL for runtime user and responsibility identifiers, FND_PROFILE and FND_PROFILE_OPTIONS_VL for profile option values, FND_MESSAGE and APP_EXCEPTION for error reporting, and FND_RELEASE for release versioning. The package references no application tables for persistent writes; its output is confined to session state.

Usage Notes

FND_CLIENT_INFO is typically invoked implicitly by the EBS framework whenever a user connects through the Forms server or the self-service runtime, rather than being called directly by developers. Because it is referenced by 92 other packages, it is effectively a foundational utility relied upon throughout the application tier. Custom code should not need to call it directly; instead, developers should generally use FND_GLOBAL or FND_PROFILE to read context. The package is nevertheless valuable as a diagnostic reference: querying V$SESSION columns such as CLIENT_INFO and MODULE reveals the values set by this package and helps identify the source of a session during troubleshooting.