Search Results ap_acctg_data_fix_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_ACCTG_DATA_FIX_PKG is a corrective maintenance package in the Oracle E-Business Suite Payables (AP) module. Its purpose is remediation of corrupt or inconsistent accounting data — the subledger entries in AP_ACCOUNTING_EVENTS_ALL, the distribution and payment history rows that feed them, and the corresponding balances in General Ledger. Such inconsistencies typically arise after failed accounting submission, orphaned Subledger Accounting (SLA) events, period-close anomalies, or data corruption introduced during upgrades or patches. In Oracle EBS 12.1.1 the accounting model is based on the legacy create_accounting_entries PL/SQL path, while 12.2.x routes AP accounting through Subledger Accounting; the package bridges these by manipulating both AP distribution tables and the XLA accounting events, so it must be used with a full understanding of the target release.

The package is owned by the APPS schema, is classified as OTHER (not a public API), and is self-referenced, meaning it invokes its own internal routines. It is not called by any other documented package, confirming that it is a stand-alone utility invoked directly.

Key Procedures and Functions

Tables Accessed

Usage Notes

AP_ACCTG_DATA_FIX_PKG is not exposed through a standard Payables form or concurrent program menu. It is typically invoked from a dedicated data-fix concurrent program, an SQL*Plus session, or a custom wrapper after Oracle Support or an approved change request authorises the correction. Because the routines physically delete and rebuild accounting, they should only be run after the BACKUP_DATA routine has captured the affected rows, with the operating unit set and the AP/GL periods confirmed open. The log files created via OPEN_LOG_OUT_FILES and the PRINT/PRINT_HTML_TABLE routines should be retained as evidence of the fix. On 12.2.x systems, DEL_NONFINAL_XLA_ENTRIES is of particular importance because Subledger Accounting events must be reconciled with the underlying AP distributions; on 12.1.1 the corrective emphasis is on AP_ACCOUNTING_EVENTS_ALL and the transfer to GL. Given the destructive nature of the operations, direct execution outside a supported remediation script is discouraged.