Search Results get_default_legal_context




Overview
Explore in AI Chat

Overview

XLE_UPGRADE_UTILS is an Oracle E-Business Suite PL/SQL utility package owned by the APPS schema and classified under the ETRM "OTHER" API category. Its purpose is narrowly scoped to the upgrade and migration path that moves historical Legal Entity (LE) and Subledger Accounting (SLA) configuration data into the XLE (Subledger Accounting / Legal Entity) data model introduced in Release 12. The package bridges data held in the pre-upgrade staging tables with the runtime legal entity structures by resolving the relationship between an operating unit and its designated default legal context.

The package carries the source header marker xleupgutils.pls 120.2, dated 2005/09/22, indicating it originated with the Release 12 upgrade toolset. Because it is an upgrade utility rather than a general-purpose runtime API, it is not intended for steady-state transactional processing. It exists to derive a legal entity identifier from pre-upgrade user mapping information and to expose that value to the calling upgrade program.

Key Procedures and Functions

  • GET_DEFAULT_LEGAL_CONTEXT — The sole documented procedure in the package. It returns the Default Legal Context (Legal Entity ID) for a given operating unit. According to the package specification comments, the procedure derives the LE ID from user mapping held in pre-upgrade tables, meaning the resolution depends on staging data populated earlier in the upgrade sequence rather than on live legal entity assignments. It accepts the operating unit as an input and returns the resolved default legal context along with the standard concurrent-style status and message outputs used throughout Oracle EBS APIs. The procedure is declared public within the package specification.

No additional public functions or procedures are documented for this package in the ETRM metadata. The single-procedure surface reflects its tightly bounded upgrade role.

Tables Accessed

  • XLE_LE_INTERFACE — Staging interface for legal entity records migrated during the Release 12 upgrade.
  • XLE_LE_OU_INTERFACE — Interface table linking legal entities to operating units; central to deriving which LE applies to a given OU.
  • XLE_LE_BSV_INTERFACE — Interface for balancing segment value assignments tied to legal entities.
  • XLE_LE_SOB_INTERFACE — Interface associating legal entities with sets of books during migration.
  • XLE_SOB_INTERFACE — Interface table for set of books information used in the upgrade mapping.
  • HR_ALL_ORGANIZATION_UNITS — Source of organization (operating unit) definitions used to validate or resolve the input organization.
  • HR_ORGANIZATION_INFORMATION — Stores classification and attribute information about organizations, supporting the OU-to-legal-entity resolution.

The mix of XLE interface tables and HR organization tables confirms that the procedure operates during the upgrade window, reading migrated mapping data alongside existing organization structures.

Usage Notes

GET_DEFAULT_LEGAL_CONTEXT and the parent package are invoked during the Oracle EBS Release 12 upgrade process, after the XLE interface tables have been populated with pre-upgrade legal entity, operating unit, and set of books mappings. The package is referenced by one other documented package, indicating it is called programmatically rather than directly by an end user. It is appropriate in upgrade drivers, data migration scripts, and diagnostic routines that must resolve an operating unit to its default legal entity before the full legal entity model is live.

Because the procedure depends on pre-upgrade staging data, it should not be used after the upgrade completes or as a substitute for the runtime legal entity APIs. Callers must supply a valid operating unit and should inspect the returned status and message outputs to detect mapping failures. Given the age of the source header, implementations on 12.1.1 and 12.2.2 should treat the package as legacy upgrade infrastructure: useful for historical reconstruction and migration validation, but not intended for new custom development.