Search Results xla_compile_pad_pkg




Overview
Explore in AI Chat

Overview

XLA_COMPILE_PAD_PKG is an internal PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Subledger Accounting (XLA) architecture, which provides a common accounting engine that transforms subledger transactions into journal entries. The package is classified as an OTHER API in the Oracle E-Business Suite electronic technical reference manual, indicating that it is not published as a public, supported integration interface and is intended strictly for internal product use.

Its principal business function is to orchestrate the compilation of product accounting definitions (PAD) — the rule sets assigned to a subledger product, application, and ledger that determine how transactions are accounted. The package functions as a control wrapper around the underlying compile logic implemented in XLA_CMP_PAD_PKG, managing compile status, coordinating error handling through XLA_EXCEPTIONS_PKG and FND_LOG, and exposing the operation to the application through a single entry point. In this role it supports the integrity of the accounting rule repository, ensuring that only compilation requests issued from an authorized product context are processed and that their outcome is recorded consistently.

Key Procedures and Functions

  • COMPILE — The primary entry point. It drives the compilation of the product accounting definitions for the requested product rules, delegating the substantive compilation work to XLA_CMP_PAD_PKG and handling logging and exception propagation through the XLA logging framework.
  • SET_COMPILE_STATUS — Records or updates the compilation status of the product accounting definition. It maintains the status consumed by the compile workflow so that surrounding code and diagnostics can determine whether the definition is compiled, pending, or in error.
  • GET_COMPILE_STATUS — Returns the current compilation status of the product accounting definition. It provides the read side of the status mechanism and is used by internal callers to determine whether compilation is required before another operation proceeds.

Only these three procedures are documented for this package body; no parameter signatures are published in the reference material, and none should be inferred.

Tables Accessed

The package directly references one base table, XLA_PRODUCT_RULES_B, through an APPS synonym. XLA_PRODUCT_RULES_B stores the header-level definition of product accounting rules for each application and product. The compile request is validated and resolved against this table, and its compile-related attributes or status are maintained as the outcome of the COMPILE, SET_COMPILE_STATUS, and GET_COMPILE_STATUS operations. The package additionally depends on APPS.XLA_CMP_PAD_PKG (the core compilation engine), APPS.XLA_EXCEPTIONS_PKG (error capture and routing), FND_LOG (diagnostic logging), and the SYS.STANDARD package. No other database object references XLA_COMPILE_PAD_PKG, confirming its status as a top-level internal driver.

Usage Notes

XLA_COMPILE_PAD_PKG is not exposed as a public API and should not be called from custom code, as its interface is not guaranteed across releases or patches. It is typically invoked from within the Subledger Accounting setup path — for example, when an administrator defines or changes accounting rules in the Accounting Methods Builder or related setup — and may be reached indirectly from concurrent programs and internal product code that manage the preparation of subledger accounting data. Because it references FND_LOG, compile activity can be traced through the standard EBS logging framework, and failures surface through XLA_EXCEPTIONS_PKG rather than as raw runtime errors. Customers should rely on the supported setup and diagnostic paths rather than calling the package directly.