Search Results event_application_cp

Overview

APPS.XLA_ACCOUNTING_PKG is a core PL/SQL package within the Oracle E-Business Suite Subledger Accounting (XLA) architecture. The XLA schema is the common accounting engine that receives transaction data from subledgers such as Payables, Receivables, Assets, Cost Management, and Projects, applies accounting method rules, and generates the final journal entries posted to General Ledger. XLA_ACCOUNTING_PKG sits at the heart of this process as the primary driver of the accounting program that transforms raw subledger transactions into accounted events, event lines, and journal entries.

The package orchestrates the Create Accounting concurrent program. It manages the creation of accounting batches, the extraction and processing of accounting events, the application of accounting definitions, and the propagation of journal lines into General Ledger. It also manages error handling when accounting cannot complete for a given event or document, and supports the unit-based processing model used to parallelize accounting workloads. The package status is VALID in the APPS schema and is classified as an OTHER API, meaning it is a documented internal engine rather than a public integration API.

Key Procedures and Functions

• ACCOUNTING_PROGRAM_BATCH — Drives batch-level accounting processing, coordinating the creation and management of accounting batches (XLA_ACCOUNTING_BATCHES_S) for a given subledger application and accounting run.
• ACCOUNTING_PROGRAM_DOCUMENT — Processes accounting at the document level within a batch, applying accounting method rules and generating accounting entries for the documents included in the run.
• ACCOUNTING_PROGRAM_EVENTS — Handles the processing of accounting events, including the generation and transformation of event data into accounted journal entries stored in XLA_AE_HEADERS and associated tables.
• ACCOUNTING_PROGRAM — The primary driver procedure that sequences accounting program execution across batches, documents, and events for a subledger application.
• EVENT_APPLICATION_CP — A concurrent program entry point for the event application logic, invoked by the Subledger Accounting concurrent manager to apply accounting to events.

Note: The ETRM metadata lists UNIT_PROCESSOR_BATCH as a documented procedure; this handles unit-based parallel processing of accounting units where configured.

Tables Accessed

• XLA_ACCOUNTING_BATCHES_S — Stores the accounting batches created and managed during a run; central to batch-level processing.
• XLA_AE_HEADERS / XLA_AE_HEADERS_GT — Stores and temporarily holds the generated subledger journal entry headers; the output of the accounting process.
• XLA_ACCTG_METHODS_TL / XLA_ACCTG_METHOD_RULES — Provide the accounting method definitions and rules applied when deriving account combinations.
• XLA_AAD_LINE_DEFN_ASSGNS — Application accounting definition line assignments used to determine which definitions apply to a transaction.
• XLA_ACCT_PROG_EVENTS_GT — Global temporary table holding accounting program events during processing.
• XLA_ACCOUNTING_ERRORS — Receives errors raised during accounting for reporting and troubleshooting.
• GL_INTERFACE_CONTROL_S, GL_LEDGERS, GL_BC_PACKETS, GL_BC_PACKET_ARRIVAL_ORDER — Support transfer of journal entries to General Ledger and ledger configuration lookup.
• XLA_QUEUE_MSG_TYPE, FND_LANGUAGES, WF_PARAMETER_LIST_T — Support message queuing, language-specific descriptions, and concurrent program parameter passing.

Dependencies also include XLA_AE_JOURNAL_ENTRY_PKG, which the package calls to build journal entry lines.

Usage Notes

XLA_ACCOUNTING_PKG is not intended for direct invocation by end users or custom form logic. It is called internally by the Create Accounting concurrent program (XLAACCP) and by event application concurrent programs, and it is referenced by 53 other packages—predominantly the generated application accounting definition (AAD) packages such as XLA_00200_AAD_*_PKG, which supply transaction-specific accounting logic.

The dependency chain confirms the standard XLA execution flow: AAD packages are invoked from within the accounting engine to derive accounting, and the engine packages in turn call XLA_AE_JOURNAL_ENTRY_PKG to persist journal lines. Customization should be performed through accounting methods, definition rules, and the Subledger Accounting setup forms rather than by modifying this package. Because the package is a system-owned engine, any direct modification invalidates Oracle support and risks incorrect journal generation across all subledgers.