Search Results xla_cmp_pad_pkg




Overview
Explore in AI Chat

Overview

XLA_CMP_PAD_PKG is an Oracle E-Business Suite package owned by the APPS schema that forms part of the Subledger Accounting (XLA) "compiler" infrastructure. The XLA schema stores accounting definitions — application accounting definitions (AADs), line definitions, event class sources, and product rules — as metadata. Before those definitions can be used at runtime, they must be compiled into executable PL/SQL. XLA_CMP_PAD_PKG supports this compilation process for the product accounting definition (PAD) layer.

The package name follows the XLA_CMP_* convention adopted throughout the XLA compiler framework. Its principal role is to resolve the name of an application and to drive the compilation of product-level accounting definitions. Product rules determine the journal line types, accounting sources, and account derivation rules that apply to a given application, event class, and event type combination. Once all components are compiled, the definition becomes available for accounting event processing.

Key Procedures and Functions

The ETRM documentation records two public program units in this package.

  • GETAPPLICATIONNAME — Returns the display name of an Oracle EBS application. This is typically used during compilation to produce readable messages, log entries, or diagnostics that identify the application whose product accounting definition is being processed, rather than exposing only an internal APPLICATION_ID.
  • COMPILE — The principal entry point that compiles the product accounting definition metadata. It orchestrates the generation and execution of the accounting definition's compiled form, coordinating with the other XLA_CMP_* packages that handle line types, sources, descriptions, and rules.

No parameter signatures are documented in the ETRM metadata, and none should be assumed.

Tables Accessed

The package references a focused set of tables through APPS synonyms:

  • FND_APPLICATION_TL — The application name translation table, read to resolve application names via GETAPPLICATIONNAME.
  • FND_USER — Read to identify the user performing or associated with the compilation.
  • XLA_PRODUCT_RULES_B and XLA_PRODUCT_RULES_TL — The base and translated product rule definition tables that this package compiles.
  • XLA_LINE_DEFINITIONS_B — The line definition base table, holding the journal line definitions referenced by product rules.
  • XLA_AAD_SOURCES and XLA_AAD_LINE_DEFN_ASSGNS — The source assignments and line definition assignments that bind sources and line definitions to an AAD.
  • XLA_EVT_CLASS_SOURCES_GT — A global temporary table used to stage event class source information during compilation.
  • DBMS_SQL — Referenced for dynamic SQL generation and execution, the mechanism by which compiled accounting definitions are built and validated.

Usage Notes

This package is an internal compiler component rather than a public API. It is not intended to be called directly from custom code. It is referenced by seven other packages, including XLA_CMP_ACCT_LINE_TYPE_PKG, XLA_CMP_ADR_PKG, XLA_CMP_DESCRIPTION_PKG, XLA_CMP_EVENT_TYPE_PKG, XLA_CMP_MPA_JLT_PKG, XLA_CMP_SOURCE_PKG, and XLA_COMPILE_PAD_PKG, which indicates its place in the wider XLA compilation dependency chain. Compilation is normally initiated from the Subledger Accounting setup user interface — for example, when an accounting definition is saved, validated, or deployed — or through the concurrent programs that compile accounting definitions in bulk. Customizations and extensions in the XLA framework should use the supported public APIs and the standard setup forms; the XLA_CMP_* packages are invoked implicitly by those tools. The package is valid in both 12.1.1 and 12.2.2.