Results for “get_default_org_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AD_CONFIG is a lightweight utility package owned by the APPS schema in Oracle E-Business Suite. It exposes a small set of configuration-inquiry functions that report on fundamental characteristics of an EBS instance: the release name, whether the installation is multi-organization, multi-lingual, or multi-currency, and the identifier of the default operating unit organization. Rather than serving a single business process such as order entry or general ledger posting, AD_CONFIG functions as a foundational configuration introspection layer that other code paths consult when behavior must adapt to the environment in which it is running. The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling schema rather than the definer, which is appropriate for a read-only inquiry package whose callers are expected to already possess access to the underlying FND tables.

Key Procedures and Functions

The documented interface consists of five functions:

• RELEASE_NAME — Returns the release name of the EBS instance. It accepts an optional release type argument (defaulting to null) that allows the caller to qualify which release identifier is returned, such as the base product release or an application-specific release.
• IS_MULTI_ORG — Returns a value indicating whether the instance is configured as a multi-organization installation, i.e., whether more than one inventory organization or operating unit is defined and active.
• IS_MULTI_LINGUAL — Reports whether multiple languages are installed and enabled, allowing callers to branch logic that depends on translation or language-specific behavior.
• IS_MULTI_CURRENCY — Indicates whether the instance operates with more than one enabled currency, which is relevant for reporting, conversion, and rounding logic.
• GET_DEFAULT_ORG_ID — Returns the numeric organization identifier of the default operating unit, allowing callers to resolve the correct organization context without prompting the user.

Tables Accessed

Per the ETRM metadata, AD_CONFIG reads three core Application Object Library tables through APPS synonyms:

• FND_PRODUCT_GROUPS — Holds installed product group information; the basis for resolving release and product-group-level configuration.
• FND_PROFILE_OPTIONS — Defines the profile option names and hierarchy; used to locate the relevant configuration settings.
• FND_PROFILE_OPTION_VALUES — Stores the actual values assigned to profile options at site, application, responsibility, and user levels; the source from which multi-org, multi-lingual, multi-currency, and default organization settings are derived.

By centralizing these lookups, AD_CONFIG spares callers from writing repetitive profile-option queries.

Usage Notes

AD_CONFIG is typically invoked from server-side PL/SQL in forms, concurrent programs, and custom extensions that must behave differently depending on instance configuration. A custom concurrent program, for example, may call IS_MULTI_ORG to decide whether to prompt for an organization parameter, or call GET_DEFAULT_ORG_ID to default that parameter. The package is not referenced by any other documented packages, indicating it is a leaf utility consumed directly by application or custom code rather than building block of a larger framework. The user search fragment "adaptive conne" most likely reflects confusion with an unrelated term; AD_CONFIG has no relationship to adaptive connection or connection-pooling features, and its scope is strictly limited to configuration inquiry.