Search Results create_journal_entry_line




Overview
Explore in AI Chat

Overview

APPS.XLA_JOURNAL_ENTRIES_PUB_PKG is a public PL/SQL package body within the Oracle E-Business Suite Subledger Accounting (XLA) module. Its role is to provide a programmatic, API-driven mechanism for constructing and finalizing journal entries that originate within Subledger Accounting. The package exposes a small, purpose-built public interface that allows callers to build an accounting entry incrementally — first creating the header, then attaching individual journal lines, and finally marking the entry as complete. This pattern supports integration scenarios where accounting events and their associated distributions must be transformed into balanced journal entries before transfer to the General Ledger.

The package body carries a standard XLA logging infrastructure, including a private TRACE routine that wraps FND_LOG calls and maps severity constants (STATEMENT, PROCEDURE, EVENT, EXCEPTION, ERROR, UNEXPECTED) to numeric log levels. Errors are propagated through XLA_EXCEPTIONS_PKG, the shared exception-handling utility for the Subledger Accounting product family.

Key Procedures and Functions

  • CREATE_JOURNAL_ENTRY_HEADER — Establishes the journal entry header record that anchors a new accounting entry. This procedure is the entry point for the workflow and is invoked before any lines can be associated with the entry.
  • CREATE_JOURNAL_ENTRY_LINE — Adds an individual journal entry line to a previously created header. This is the routine most commonly referenced by developers searching for "create_journal_entry_line," since it is the mechanism for attaching detailed accounting distributions, amounts, and supporting attributes to the entry being assembled.
  • COMPLETE_JOURNAL_ENTRY — Finalizes the journal entry after all header and line data has been supplied. Marking the entry complete signals that the record is ready for downstream processing, such as validation and transfer to the General Ledger.

The three procedures are designed to be called in sequence: header first, one or more line invocations, and then completion. No parameter lists are documented in the available metadata, so signatures should not be assumed beyond the stated purposes.

Tables Accessed

  • XLA_AE_HEADERS — The core Subledger Accounting table holding journal entry headers. CREATE_JOURNAL_ENTRY_HEADER writes to this structure to persist the new entry.
  • XLA_EVENTS — Stores the accounting events that drive subledger accounting. The package references events to associate the journal entry with its originating business transaction.
  • XLA_SUBLEDGERS — Identifies the subledger application context for the entry, ensuring the journal is attributed to the correct source application.
  • GL_PERIOD_STATUSES — Provides General Ledger period open/closed status, supporting validation that the target accounting period is available for posting.

Usage Notes

XLA_JOURNAL_ENTRIES_PUB_PKG is classified as an OTHER API within the ETRM repository and is not referenced by any other documented package, indicating it is typically invoked directly rather than through internal package dependencies. In practice, it would be called from custom PL/SQL routines or extensions that need to build Subledger Accounting journal entries outside the standard subledger processing flow. Because the package manipulates core XLA accounting tables, callers should ensure the target period is open and that events and subledger context are correctly identified before invoking the header, line, and completion routines in order.