Search Results calc_reval_process

Overview

APPS.XTR_JOURNAL_PROCESS_P is the core accounting engine of the Oracle E-Business Suite Treasury (ETRM) module. Its principal business function is to transform treasury transaction activity — foreign exchange deals, interest accruals, amortization, bank balance movements, and inter-company (IG) transfers — into journal entries that are transferred to Oracle General Ledger. The package header comment (FND file version 120.30, last shipped 2006/10/27) confirms its long-standing role as the bridge between the treasury sub-ledger and the GL. The source excerpt documents the private helper GET_IG_CCID, which resolves the principal or interest GL code combination identifier for an inter-company transaction from XTR_IG_JOURNAL_STRUCTURES, called during journal generation. The header notes also disclose that revaluation journal insertion (CALC_REVAL_PROCESS) is not currently invoked from NEW_TRANSFER_TO_GL pending clarification of revaluation and reversal policy, so revaluation behavior should be treated as incomplete or controlled by configuration rather than assumed.

Key Procedures and Functions

• GEN_JOURNALS — The primary journal generation routine and the entry point implied by the "gen_journals" search term. It reads treasury deal, accrual, amortization, and bank data, resolves GL account combinations (including via GET_IG_CCID for inter-company principal and interest lines), and creates journal records for transfer to General Ledger.
• DO_JOURNAL_PROCESS — Orchestrates the end-to-end journal run, driving the generation, validation, and posting sequence. It acts as the controlling procedure that invokes the other documented routines in the correct order.
• UPDATE_JOURNALS — Maintains journal rows after creation, updating status, amounts, or GL references as the accounting process progresses and as source treasury records change.
• JOURNALS — Handles the journal records themselves, supporting retrieval and processing of generated journal lines before they are handed to GL.
• GET_CLOSED_PERIOD_PARAM — Resolves the closed-period processing parameter, determining how the package behaves when source activity falls in a GL period that has already been closed.
• GET_IG_CCID (private) — Returns the principal or interest GL CCID for an inter-company transaction using the company code, counterparty, currency, and bank account inputs against XTR_IG_JOURNAL_STRUCTURES.

Tables Accessed

The package reads and writes across the principal ETRM data model. Transaction source tables include XTR_DEALS, XTR_DEAL_DATE_AMOUNTS, XTR_BATCHES, XTR_BATCHES_S, XTR_BATCH_EVENTS, and XTR_BATCH_EVENTS_S, which supply deal, batch, and event detail. Accrual and amortization amounts come from XTR_ACCRLS_AMORT. Banking data is drawn from XTR_BANK_ACCOUNTS and XTR_BANK_BALANCES, while XTR_PARTY_INFO and XTR_COMPANY_PARAMETERS supply counterparty and installation-level configuration such as authorities (XTR_COMPANY_AUTHORITIES). GL-facing tables include XTR_GL_REFERENCES, which maps treasury activity to GL accounts, plus GL_PERIODS and GL_DAILY_CONVERSION_TYPES for period validation and currency conversion. Output journal rows are written for subsequent transfer to Oracle GL.

Usage Notes

XTR_JOURNAL_PROCESS_P is classified as OTHER (non-public API) and is referenced by four other ETRM packages, indicating it is invoked internally by treasury accounting flows rather than exposed directly. In practice it is driven by the Treasury journal generation and transfer concurrent programs, which call DO_JOURNAL_PROCESS and GEN_JOURNALS to produce accounting entries. Because it is not a supported public API, custom code should avoid calling it directly; instead, use the standard concurrent program or the supported accounting APIs. Sites upgrading between 12.1.1 and 12.2.2 should note the header comment regarding revaluation processing and verify that GEN_JOURNALS produces the expected entries for inter-company and accrual transactions in their configuration.