Search Results set_currency_context

Overview

FND_CLIENT_INFO is a foundational Oracle E-Business Suite PL/SQL package that manages the session-level context stored in the client information area of the database session. It is the mechanism by which Oracle EBS establishes and maintains the operating unit (org_id) context, the Multi-Currency reporting context, and the security group context for a given application, responsibility, and user combination. Because virtually every transactional and reporting API in EBS depends on the correct operating unit being set before data is queried or modified, FND_CLIENT_INFO sits at the very center of the Multi-Org access control model.

In Oracle EBS 12.1.1 and 12.2.2, the package is owned by APPS and is classified as an OTHER API in the ETRM repository. Its behavior is deliberately side-effect constrained: the package-level pragma restrict_references(fnd_client_info, WNPS, WNDS) prevents it from writing database state or package state, ensuring that setting client info does not itself touch persistent data. The header dates to 2007 and reflects long-term stability across releases, with the same interface carried forward from 11i through R12.

Key Procedures and Functions

ETRM documents six procedures and functions in this package. The two SETUP_CLIENT_INFO procedures are overloaded: one populates both the operating unit context and the Multi-Currency context using application, responsibility, user, security group, and organization identifiers; the second is a backwards-compatible overload that omits the organization argument. These are the standard entry points invoked when a session is initialized for an EBS responsibility.

SET_ORG_CONTEXT sets only the operating unit context in the client info area, accepting a context value that is the org_id for the operating unit (up to 10 bytes long). This is the procedure users most commonly invoke directly when they need to switch operating unit context within an already-initialized session, for example between loops over multiple operating units in a custom concurrent program.

SET_CURRENCY_CONTEXT configures the client info area for Multi-Currency reporting, taking a context value of up to 10 bytes. SET_SECURITY_GROUP_CONTEXT establishes the security group context for the session. The ORG_SECURITY function is the validation entry point that determines whether a user has access to a given operating unit under the active security profile, forming the enforcement core of Multi-Org security.

Tables Accessed

The package references FND_PRODUCT_GROUPS, which holds product group and operating unit configuration data used to validate and resolve the operating unit context. It also relies on the DBMS_APPLICATION_INFO and DBMS_UTILITY built-in packages to record client info values in the session (the client_info and related fields of v$session) and to support context handling. Because the package carries the WNDS and WNPS restrictions, these accesses are read-oriented and do not mutate persistent application tables.

Usage Notes

FND_CLIENT_INFO is referenced by 92 other packages, which underscores its ubiquity. It is normally invoked automatically by the Forms runtime (fnd_web / FND runtime libraries) at responsibility startup, and by concurrent program initialization logic that must set organization context before processing. Custom PL/SQL, concurrent programs, and interfaces that loop over operating units typically call SET_ORG_CONTEXT directly, then restore the prior context afterward. In R12.2 online patching environments, correct use of this package is essential because it drives org_id-dependent row filtering and Multi-Org views. When the metadata is limited, developers should treat this package as the authoritative, supported interface for setting org and currency context rather than manipulating client info manually.