Search Results del_nonfinal_xla_entries

Overview

AP_ACCTG_DATA_FIX_PKG is an Oracle EBS Payables utility package (owned by APPS, status VALID) that provides a controlled framework for diagnosing, backing up, and repairing corrupted or inconsistent accounting data in the Oracle Payables subledger. Its principal business purpose is data repair of accounting entries that have been left in an unresolved or erroneous state — for example, invoice and payment distributions that failed to transfer to the General Ledger, entries created under a period that was later found to be closed, or non-final Subledger Accounting (XLA) entries that must be removed before accounting can be re-run. The package is classified as OTHER rather than as a formal public API, indicating it is an internal remediation tool rather than a supported integration interface. It governs a deliberately destructive workflow: source Payables accounting rows are first backed up, the affected entries are either undone or deleted (including non-final XLA entries), and the data is then regenerated or repopulated so that the transfer to GL can be repeated cleanly. Because it manipulates core accounting tables directly, it is intended for controlled use under Oracle Support direction and typically with a validated database backup available.

Key Procedures and Functions

• OPEN_LOG_OUT_FILES / CLOSE_LOG_OUT_FILES — Open and close output log files that capture the execution trace of the repair run.
• CREATE_TEMP_ACCTG_TABLES — Creates temporary staging tables used to hold extracted accounting data during processing.
• GET_COLS — Dynamically retrieves column definitions (utilizing ALL_TAB_COLUMNS and DBMS_SQL) to build dynamic SQL for the affected tables.
• BACK_UP_ACCTG / BACKUP_DATA — Copy the affected accounting records into backup structures before any modification, providing a rollback reference.
• PRINT / PRINT_HTML_TABLE — Write formatted textual and HTML tabular output to the log for review and audit.
• APPS_INITIALIZE — Establishes APPS session context (user, responsibility, application) in the standard EBS manner.
• CHECK_PERIOD / IS_PERIOD_OPEN / GET_OPEN_PERIOD_START_DATE — Validate the accounting period state and derive the first open period start date for corrective postings.
• CHECK_CCID — Validates accounting flexfield code combinations before re-accounting.
• UNDO_ACCOUNTING / UNDO_ACCTG_ENTRIES — Reverse previously created accounting entries for the targeted records.
• DEL_NONFINAL_XLA_ENTRIES — Delete non-final Subledger Accounting entries so that accounting can be re-generated.
• FINAL_PAY_ROUND_DFIX — Repairs payment rounding discrepancy conditions in final payments.
• DELETE_CASCADE_ADJUSTMENTS — Removes dependent adjustment distributions that would otherwise be orphaned.
• REPOP_PREPAY_DISTS — Repopulates prepayment application distributions.
• PUSH_ERROR — Standard error-raising/notification helper.

Tables Accessed

The package reads and writes core Payables accounting and source tables through APPS synonyms: AP_ACCOUNTING_EVENTS_ALL (accounting event tracking), AP_INVOICE_DISTRIBUTIONS_ALL, AP_PAYMENT_HIST_DISTS, AP_PREPAY_APP_DISTS and AP_PREPAY_HISTORY_ALL (prepayment application and history distributions), AP_SELF_ASSESSED_TAX_DIST_ALL (self-assessed tax distributions), AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL and AP_PAYMENT_HISTORY_ALL (invoice and payment header/line data), plus AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL for supplier validation. GL_CODE_COMBINATIONS and FND_RESPONSIBILITY_TL / FND_USER support code combination validation and session/security context. ALL_TAB_COLUMNS, DUAL and V$PARAMETER are read for dynamic SQL construction and environment checks. The package also uses FND_FILE and UTL_FILE for log output, DBMS_SQL for dynamic statements, APP_EXCEPTION and STANDARD for error and numeric handling.

Usage Notes

AP_ACCTG_DATA_FIX_PKG is not referenced by any other database object (referenced by 0 packages) and exposes no documented public API signature set, which confirms it is invoked directly — typically from a controlled SQL*Plus session, a custom concurrent program wrapper, or by an Oracle Support engineer executing individual procedures. Because it deletes non-final XLA entries, reverses accounting, and directly modifies distribution tables, it must only be run when the affected accounting period state has been confirmed and a full backup of the impacted tables exists. In both EBS 12.1.1 and 12.2.2 the underlying tables and the Subledger Accounting model are consistent, though in 12.2.x the subledger accounting transfer architecture makes the removal of non-final XLA entries via DEL_NONFINAL_XLA_ENTRIES especially relevant. Logging should always be enabled through OPEN_LOG_OUT_FILES so that PRINT and PRINT_HTML_TABLE output provides an auditable record of every repair performed. It is not a substitute for the standard Payables Accounting Process; it is a remediation tool applied after that process has failed to resolve the data condition.