Search Results get_total_error_count




Overview
Explore in AI Chat

Overview

The APPS.XLA_ACCOUNTING_ERR_PKG package is the error-handling component of the Oracle Subledger Accounting (SLA) engine in Oracle E-Business Suite. Its primary responsibility is to capture, store, and report errors generated during the creation of accounting entries by the Accounting Program and by manual journal entry processing. Because Subledger Accounting operates as a centralized accounting engine across multiple source applications — Payables, Receivables, Assets, Cost Management, and others — centralized error management is essential to diagnostic and reconciliation workflows.

The package maintains a controlled vocabulary of error source codes, including C_ACCT_PROGRAM ('ACCT_PROGRAM'), C_ACCT_ENGINE ('ACCT_ENGINE'), C_TRANSFER_TO_GL ('TRANSFER_TO_GL'), and C_MANUAL_JE ('MANUAL_ENTRIES'), allowing callers to identify which phase of the accounting lifecycle produced a failure. It is one of the most widely referenced utilities in the SLA schema, invoked by 74 other packages, which reflects its role as shared infrastructure rather than a standalone program.

Key Procedures and Functions

  • INITIALIZE — Establishes the error-handling context at the start of an accounting run. Its specification was revised multiple times during development, and additional parameters were later added to support expanded error-source and limit settings.
  • SET_OPTIONS — Originally introduced as SET_ERROR_SOURCE (documented addition dated 09/09/2003) and renamed on 10/14/2003. It configures the error source code and related options that govern how errors are recorded or filtered during processing.
  • INSERT_ERRORS — Persists captured error records into the Subledger Accounting error tables for subsequent review and correction.
  • GET_TOTAL_ERROR_COUNT — Returns the accumulated count of errors for the current run, supporting threshold checks against the G_ERROR_LIMIT package variable and the G_ERROR_COUNT counter introduced under bug #2709397.
  • BUILD_MESSAGE — Constructs human-readable error text suitable for display in forms or concurrent program output.
  • COPY_GLOBAL_ARRAY — Copies the in-memory error array, defined as t_array_error over xla_accounting_errors%ROWTYPE, for downstream processing or persistence.

Tables Accessed

The package reads and writes XLA_ACCOUNTING_ERRORS, the base transactional table holding individual error rows generated during accounting and manual entry processing. It also references the XLA_ACCOUNTING_ERRORS_S sequence object, used to generate primary keys for new error records. The PLITBLM table, an Oracle Applications internal message repository, supplies translated or standard message text used by BUILD_MESSAGE. All access occurs through APPS synonyms, consistent with standard EBS schema conventions.

Usage Notes

XLA_ACCOUNTING_ERR_PKG is normally invoked implicitly rather than directly. The Subledger Accounting Program and the Create Accounting concurrent programs call it internally to record failures encountered while generating journal entries; the same applies to manual journal entry forms in Subledger Accounting. Custom code that performs bulk accounting operations can call the package explicitly, following the pattern of calling INITIALIZE first, then SET_OPTIONS for each error source, inserting errors as encountered, and finally querying GET_TOTAL_ERROR_COUNT to decide whether to abort or continue based on G_ERROR_LIMIT. Because internal state is held in package globals, callers should treat the package as session-scoped and reinitialize between distinct processing runs. Users searching for set_error_source should note that this procedure was renamed to SET_OPTIONS as of October 2003 and is documented under that name in release 12.1.1 and 12.2.2.