Search Results xle_upgrade_utils




Overview
Explore in AI Chat

Overview

APPS.XLE_UPGRADE_UTILS is a PL/SQL package body in the Oracle E-Business Suite Legal Entity (XLE) module. It supplies utility logic used during the upgrade and configuration cycle that establishes the relationship between operating units, sets of books, and legal entities. Its primary purpose is to resolve and return the default legal context for a given operating unit by interrogating the Human Resources organization classification structures and the XLE interface tables. The package forms part of the foundation that the Legal Entity Configurator relies on when migrating or seeding legal entity, ledger, and operating unit associations.

The package is classified as OTHER in the ETRM registry, indicating that it is an internal support utility rather than a published, externally supported API. It is documented only sparsely, with a single exposed procedure and an internal cursor named check_org_id, which is the artifact most commonly referenced by developers and DBAs searching for how EBS validates an organization identifier as a valid operating unit.

Key Procedures and Functions

  • GET_DEFAULT_LEGAL_CONTEXT — the sole documented procedure in the package. It determines and returns the default legal context applicable to a specified operating unit. Internally it depends on a set of private cursors: check_org_id (validates that the supplied organization is a classified operating unit by joining HR_ALL_ORGANIZATION_UNITS with two HR_ORGANIZATION_INFORMATION rows), get_sob_id (derives the associated set of books identifier from the Operating Unit Information flexfield context), acct_env_type (reads the accounting environment type from XLE_SOB_INTERFACE), def_legal_context (resolves the legal entity from XLE_LE_SOB_INTERFACE), check_le (checks XLE_LE_OU_INTERFACE for an existing legal entity/operating unit mapping), and check_le_m. These cursors collectively establish which legal entity or ledger should be treated as the default context for the operating unit provided.

Tables Accessed

  • HR_ALL_ORGANIZATION_UNITS — the base organization definition; used to confirm the organization exists and to anchor the classification joins.
  • HR_ORGANIZATION_INFORMATION — joined twice to isolate the CLASS context ('OPERATING_UNIT') and the 'Operating Unit Information' context, from which the set of books identifier is extracted.
  • XLE_SOB_INTERFACE — supplies the accounting environment type for the derived set of books.
  • XLE_LE_SOB_INTERFACE — maps sets of books to legal entities, yielding the candidate default legal context.
  • XLE_LE_OU_INTERFACE — stores legal entity to operating unit associations; consulted to determine whether a legal entity mapping already exists.
  • XLE_LE_INTERFACE and XLE_LE_BSV_INTERFACE — legal entity interface tables referenced by the package for the broader upgrade and setup mapping logic.

Usage Notes

This package is an internal upgrade and migration utility rather than a callable public API. It is typically invoked during the Legal Entity Configurator upgrade path and related setup processes, where operating unit context must be derived programmatically without user intervention. Because the documented interface exposes only GET_DEFAULT_LEGAL_CONTEXT and is classified as OTHER, customers and integrators should not call it directly from custom code; the supported route to legal entity context resolution is through the published Legal Entity APIs. The internal check_org_id cursor remains useful as a reference pattern for validating that an organization_id is a properly classified operating unit in releases 12.1.1 and 12.2.2, where the HR organization classification model is unchanged. Referenced by one other package in the ETRM registry, it should be treated as an implementation detail subject to revision between release updates.