Search Results get_compile_status

Overview

XLA_COMPILE_PAD_PKG is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Subledger Accounting (XLA) architecture. Its documented purpose is to contain all APIs required for the compilation of Product Accounting definitions. Within Subledger Accounting, a product rule couples an application (a subledger such as Payables, Receivables, or Assets) with an accounting definition and a transaction context; compilation validates and materializes that definition so that journal entries can subsequently be generated from it. The package therefore sits at the boundary between the setup of accounting rules and their runtime execution.

The header comments show the package evolving during the initial XLA development cycle in 2002 and 2003: it was created in July 2002, an AMB_CONTEXT_CODE column reference was added in March 2003, the package was renamed from XLA_COMPILE_PKG to XLA_COMPILE_PAD_PKG in the same month, and error message handling was incorporated in April 2003. The “PAD” naming distinguishes it from other compile-related units in the XLA code family. It is classified as an OTHER API, meaning it is not part of the supported public interface and is intended for internal use by the Subledger Accounting engine and its related concurrent processes.

Key Procedures and Functions

Three documented program units make up the package interface:

• GET_COMPILE_STATUS (function) — Returns the compilation status for a given product rule. Its documented parameters include an application ID, a product rule code, a product rule type code, and an AMB context code. The function allows callers to query whether a specific product accounting definition has already been compiled, or what state the last compilation left it in, before deciding whether a compile must be performed.
• SET_COMPILE_STATUS (procedure) — Switches the compile flag for a product rule. It takes an application ID and the product rule identifiers and persists a new status value. This is the write counterpart to GET_COMPILE_STATUS and is used to mark a definition as compiled, uncompiled, or in need of recompilation.
• COMPILE (procedure) — Performs the actual compilation of a Product Accounting definition. This is the worker that reads the definition and its associated data and establishes the runtime structures needed for accounting generation.

No additional procedure signatures are documented; parameter lists should not be assumed beyond those explicitly recorded in the package header comments.

Tables Accessed

The only documented table referenced through APPS synonyms is XLA_PRODUCT_RULES_B, the base table that stores product rule definitions in Subledger Accounting. The package uses this table to identify the definition being compiled and, through SET_COMPILE_STATUS, to record the compile flag against it. GET_COMPILE_STATUS likewise reads the stored status for a given application and product rule combination. Because the table holds the definition metadata, it is the natural anchor for both status queries and compilation.

Usage Notes

XLA_COMPILE_PAD_PKG is a private package and is not intended for direct customer invocation. It is referenced by one other package in the XLA code family and is typically driven by Subledger Accounting setup and runtime flows, such as when accounting definitions are saved or activated in the Create Accounting or Subledger Accounting setups, or when a concurrent maintenance program recompiles product rules. Administrators may encounter it indirectly after changes to accounting rules are submitted, after patches that invalidate compiled definitions, or when users must reconcile accounting definitions against compilation state. Custom code should not call these APIs directly; supported alternatives in the XLA public interface should be used instead.