Search Results psa_xla_accounting_errors_s

Overview

APPS.PSA_BC_XLA_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Public Sector/Funds Checking family of modules. Its primary responsibility is to bridge Funds Checker budgetary control processing with Oracle Subledger Accounting (SLA/XLA) event creation and error management. When procurement or payables documents — such as purchase order distributions, requisition distributions, or invoice distributions — are processed through budgetary control, this package determines whether Subledger Accounting is required and manages the creation, updating, and error-tracking of corresponding XLA events. Validated as VALID in the APPS schema, the package serves as a low-level integration layer rather than a directly callable public API, and it is referenced by five other packages in the Funds Checker and PSA suite.

Key Procedures and Functions

• BUDGETARY_CONTROL — The central routine coordinating budgetary control activity for a document. It evaluates funds availability, determines the accounting impact, and drives the downstream creation or adjustment of SLA events associated with the transaction.
• GET_SLA_NOTUPGRADED_FLAG — Returns a flag indicating whether Subledger Accounting has not yet been upgraded or enabled for the relevant entity. This allows callers to branch behavior between legacy accounting paths and SLA-aware processing.
• PSA_XLA_ERROR — Records accounting errors raised during SLA event generation or processing. It populates the error repository (PSA_XLA_ACCOUNTING_ERRORS and the underlying XLA_ACCOUNTING_ERRORS structures) so that failures surface in the standard Accounting Errors inquiry.

Tables Accessed

• PSA_XLA_ACCOUNTING_ERRORS / PSA_XLA_ACCOUNTING_ERRORS_S — The primary error store and its sequence; these hold failed SLA event details for user review and remediation.
• PSA_BC_ACCOUNTING_ERRORS — Funds Checker-level accounting error repository, linked to the SLA error records.
• PSA_BC_ALLOC_GT, PSA_BC_XLA_EVENTS_GT, PSA_OPTION_DETAILS_GT — Global temporary tables carrying allocation lines, XLA event data, and Funds Checker option details through the processing pipeline.
• XLA_ACCOUNTING_ERRORS and associated XLA_* global temporary tables — Standard SLA engine structures for event, header, and line staging and error capture.
• AP_INVOICE_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_REQ_DISTRIBUTIONS_ALL — Source document distributions whose accounting impact is evaluated.
• GL_LEDGERS, FND_PROFILE_OPTION_VALUES, FND_NEW_MESSAGES — Ledger context, profile-driven configuration, and message text retrieval.

Usage Notes

This package is invoked internally during budgetary control processing initiated from Purchasing, iProcurement, and Payables flows, typically triggered when Funds Checker routines execute through PSA_FUNDS_CHECKER_PKG. It is not intended for direct invocation by end users through forms or concurrent programs; instead, it acts as a supporting layer beneath the Funds Checker interface and the Accounting Errors inquiry page. Custom code should avoid calling PSA_BC_XLA_PVT directly, as it relies on populated global temporary tables and session context established by its parent callers. Errors it records become visible through the standard Subledger Accounting error inquiry, making it a key component for diagnosing failed SLA event generation in a Funds Checker-enabled ledger environment.