Search Results update_journals

Overview

XTR_JOURNAL_PROCESS_P is the core accounting engine of the Oracle E-Business Suite Treasury (ETRM) module. Its primary business function is to transform treasury deal activity — foreign exchange contracts, money market instruments, loans, and other financial transactions captured in ETRM — into journal entries suitable for posting to Oracle General Ledger. The package evaluates deal date amounts, determines the appropriate accounting periods, applies conversion rates, and generates the balanced debit/credit lines required by GL. In addition, it supports amortization schedules, bank balance reconciliation entries, and accrual processing, ensuring that the sub-ledger activity of the treasury desk is reflected accurately in the general ledger. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user, which is significant when invoked from concurrent programs or custom code running under different schemas.

Key Procedures and Functions

• GET_CLOSED_PERIOD_PARAM — A function that accepts a company identifier and returns the closed-period parameter value for that company. It is used to determine which accounting periods should be excluded from processing based on company-level configuration.
• DO_JOURNAL_PROCESS — The principal concurrent-program entry point. It accepts runtime parameters including source option, company code, a batch ID range (batch_id_from and batch_id_to), and a cutoff date. It orchestrates the overall journal creation run and returns standardized concurrent-program outputs (errbuf, retcode).
• GEN_JOURNALS — Generates journal entries for a specific batch and period end. It accepts source option, company, batch ID, period end date, and an upgrade-batch flag. The return type was changed to NUMBER to accommodate warning conditions.
• UPDATE_JOURNALS — Updates previously generated journal entries based on deal numbers, transaction numbers, and deal type, supporting corrections and re-processing scenarios.
• JOURNALS — An extended procedure supporting Flex Journals (introduced via bug 2404342). It exposes a broader parameter set including source option, company code, batch ID range, cutoff date, dummy dates, processing options, closed-period handling, and an "include transferred" flag.

Tables Accessed

The package reads and writes a broad set of ETRM and GL tables through APPS synonyms. XTR_BATCHES and XTR_BATCHES_S hold the batch headers being processed, including the batch_id range referenced by the p_batch_id_to parameter. XTR_DEAL_DATE_AMOUNTS supplies the dated amount records that drive journal lines, while XTR_DEALS provides the underlying deal definitions. XTR_PARTY_INFO and XTR_COMPANY_PARAMETERS resolve company code and party code, and XTR_COMPANY_AUTHORITIES governs company-level access. Conversion logic uses GL_DAILY_CONVERSION_TYPES, and period validation relies on GL_PERIODS and GL_SETS_OF_BOOKS. GL account assignment is derived from XTR_GL_REFERENCES (including the suspense code combination). Amortization and accrual entries involve XTR_ACCRLS_AMORT. Banking-related journals draw on XTR_BANK_ACCOUNTS and XTR_BANK_BALANCES, while event tracking uses XTR_BATCH_EVENTS and XTR_BATCH_EVENTS_S.

Usage Notes

This package is most commonly invoked from ETRM concurrent programs — particularly the Journal Creation / Journal Processing programs — where DO_JOURNAL_PROCESS or JOURNALS serves as the executable entry point. The p_batch_id_from and p_batch_id_to parameters allow operators to constrain processing to a specific batch range, which is useful for targeted re-runs, month-end close sequencing, or troubleshooting. The package is also referenced by four other EBS packages, so it may be called programmatically by upstream treasury processes. Because it runs with AUTHID CURRENT_USER, callers must ensure appropriate privileges on the underlying tables and synonyms. Typical invocation windows are period-end close and daily batch accounting cycles; operators should be aware that cutoff date and closed-period parameters directly affect which deals are journalized in a given run.