Search Results get_cols

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

• APPS_INITIALIZE — standard environment initialisation; sets the application context (org_id, user, responsibility) before other routines execute.
• OPEN_LOG_OUT_FILES / CLOSE_LOG_OUT_FILES — open and close output files for diagnostics using UTL_FILE.
• PRINT / PRINT_HTML_TABLE — write plain-text and HTML-formatted log output.
• CREATE_TEMP_ACCTG_TABLES — create temporary staging tables used to hold accounting rows before and after correction.
• GET_COLS — utility to retrieve column metadata for dynamic SQL.
• BACK_UP_ACCTG / BACKUP_DATA — snapshot accounting data before any modification, enabling rollback.
• CHECK_PERIOD / IS_PERIOD_OPEN / GET_OPEN_PERIOD_START_DATE — validate that the AP and GL periods involved are open or determine the earliest open period date.
• CHECK_CCID — validate a GL code combination identifier before use.
• UNDO_ACCOUNTING / UNDO_ACCTG_ENTRIES — reverse previously created accounting entries.
• DEL_NONFINAL_XLA_ENTRIES — delete Subledger Accounting events that were not finalised.
• DELETE_CASCADE_ADJUSTMENTS — remove adjustment distributions that cascade from a corrected source row.
• REPOP_PREPAY_DISTS — rebuild prepayment application distributions.
• FINAL_PAY_ROUND_DFIX — repair rounding discrepancies in final payment distributions.
• PUSH_ERROR — centralised error log routine.

Tables Accessed

• AP_ACCOUNTING_EVENTS_ALL — the core accounting event rows being corrected or removed.
• AP_INVOICE_DISTRIBUTIONS_ALL — invoice distribution lines that generate accounting.
• AP_PAYMENT_HIST_DISTS — payment history distributions and their accounting.
• AP_PREPAY_APP_DISTS / AP_PREPAY_HISTORY_ALL — prepayment application and history distributions.
• AP_INVOICES_ALL / AP_INVOICE_PAYMENTS_ALL / AP_PAYMENT_HISTORY_ALL — parent invoice and payment records for validation.
• AP_SELF_ASSESSED_TAX_DIST_ALL — self-assessed tax distributions.
• GL_CODE_COMBINATIONS — validates that accounting flexfield combinations are valid.
• AP_SUPPLIERS / AP_SUPPLIER_SITES_ALL / PO_VENDORS — supplier and site validation.
• FND_USER / FND_RESPONSIBILITY_TL — audit trail for the user and responsibility performing the fix.
• MO_GLOBAL — multi-org (operating unit) security context.

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.