Search Results delete_journal_entry

Overview

The APPS.XLA_JOURNAL_ENTRIES_PKG package is a core internal component of the Oracle E-Business Suite Subledger Accounting (XLA) engine. Subledger Accounting provides a centralized accounting repository that captures detailed journal entries generated from subledger transactions (such as Payables, Receivables, Assets, and Cost Management) and converts them into final accounting entries that are transferred to and posted in the General Ledger.

This package is responsible for the creation, maintenance, completion, reversal, and validation of those subledger journal entries at the header and line level. It operates as a programmatic engine rather than a user-facing API — it is invoked internally by the accounting program and event processing logic to persist the accounting output produced by the Create Accounting process. As documented in ETRM, the object resides in the APPS schema with a status of VALID and is classified as an OTHER API type, reflecting its role as an internal supporting package rather than a public integration interface.

The package is both a consumer and a provider of functionality within the XLA module. It references XLA_EXCEPTIONS_PKG and XLA_JE_VALIDATION_PKG, indicating that it participates in exception handling and journal entry validation, and it is itself referenced by XLA_EVENTS_PKG, XLA_JOURNAL_ENTRIES_PUB_PKG, XLA_DATAFIXES_PUB, and its own internal calls, confirming its central position in the journal entry lifecycle.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, organized around the header/line lifecycle and reversal processing:

• CREATE_JOURNAL_ENTRY_HEADER — Creates a new subledger journal entry header record.
• UPDATE_JOURNAL_ENTRY_HEADER — Modifies attributes of an existing journal entry header.
• DELETE_JOURNAL_ENTRY — Removes a single journal entry.
• DELETE_JOURNAL_ENTRIES — Removes multiple journal entries in a set operation.
• CREATE_JOURNAL_ENTRY_LINE — Creates an individual journal entry line associated with a header.
• UPDATE_JOURNAL_ENTRY_LINE — Updates an existing journal entry line.
• DELETE_JOURNAL_ENTRY_LINE — Deletes a journal entry line.
• COMPLETE_JOURNAL_ENTRY — Finalizes and completes a journal entry, marking it ready for transfer/posting.
• REVERSE_JOURNAL_ENTRY — Generates the reversal of a completed journal entry, used when transactions are reversed or corrected.
• FUNDS_CHECK_RESULT — Records or returns the outcome of funds availability checking against a journal entry (relevant to budgetary/encumbrance accounting).
• UPDATE_DATA — Performs bulk data updates across journal entry structures.
• ISREVERSIBLE — Determines whether a given journal entry is eligible for reversal.

Tables Accessed

The package reads and writes to the core XLA accounting tables via APPS synonyms, most notably XLA_AE_HEADERS, XLA_AE_HEADERS_S, XLA_AE_HEADER_ACS, XLA_AE_LINES, XLA_AE_LINE_ACS, and XLA_AE_SEGMENT_VALUES. These store accounting entry headers, lines, and their associated supporting/audit columns, which the package inserts and updates during entry creation and completion. It also references XLA_ACCOUNTING_ERRORS for error capture.

Reference data lookups include GL_LEDGERS, GL_PERIOD_STATUSES, GL_JE_CATEGORIES, GL_CODE_COMBINATIONS, GL_ENCUMBRANCE_TYPES, and FND_CURRENCIES, supporting ledger validation, period control, category assignment, account derivation, encumbrance handling, and currency conversion. The tables PSA_BC_REPORT_EVENTS_GT and PSA_BC_XML_REPORT_S are referenced for reporting/XML event integration.

Usage Notes

This package is not intended for direct customer invocation. It is called internally by the Create Accounting concurrent program and related XLA engine processes to build the accounting output. Custom code should prefer the documented public API XLA_JOURNAL_ENTRIES_PUB_PKG, which wraps this package for external consumption. The presence of XLA_DATAFIXES_PUB as a referencing object indicates that data-fix scripts also invoke this package when correcting corrupted journal entries. Standard references should rely on the public package and the Create Accounting program rather than calling these internal procedures directly.