Search Results xtr_batch_events_s




Overview
Explore in AI Chat

Overview

XTR_ACCRUAL_PROCESS_P is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, forming part of the Treasury (ETRM) module. Its primary business function is the calculation, processing, and transfer of accruals, amortisation, and effective interest amounts relating to treasury deals, bonds, bank balances, and intercompany transactions. The package centralises the logic required to derive effective interest, amortise premiums and discounts, and prepare accrual entries for transfer into the general ledger journal process. It is classified as an "OTHER" API within the ETRM documentation metadata and is a dependent component within the treasury calculation framework, relying on shared packages such as XTR_CALC_P, XTR_FPS2_P, and XTR_REVAL_PROCESS_P.

Key Procedures and Functions

The package body exposes six documented procedures and functions:

  • CALCULATE_EFFECTIVE_INTEREST — Derives the effective interest rate or amount applicable to a treasury instrument, supporting accurate accrual and amortisation postings.
  • CALCULATE_BOND_AMORTISATION — Computes amortisation for bond issues, applying coupon dates and allocation details to produce periodic amortisation amounts.
  • CALCULATE_ACCRUAL_AMORTISATION — Performs the core accrual and amortisation calculation across the relevant treasury deal records.
  • CALC_INTGROUP_CACCT_ACCLS — Handles intergroup and corporate account accrual processing, supporting accrual entries arising from intercompany transfers.
  • CALCULATE_NI_EFFINT — Calculates effective interest in a net-interest or notional-interest context, accommodating variable-rate and discount-based instruments.
  • TSFR_ACCRUALS_FOR_JNL_PROCESS — Transfers calculated accruals into the journal process so that they can be posted to the general ledger.

Detailed parameter lists are not exposed in the metadata and should not be assumed; callers should reference the live package specification for signatures.

Tables Accessed

The package reads and writes a broad set of ETRM tables via APPS synonyms. Transaction data is drawn from XTR_DEALS, XTR_DEAL_DATE_AMOUNTS (and its _V view), XTR_ROLLOVER_TRANSACTIONS, and XTR_INTERGROUP_TRANSFERS. Batch processing relies on XTR_BATCHES and XTR_BATCHES_S, with event-driven records held in XTR_BATCH_EVENTS and XTR_BATCH_EVENTS_S — the latter being the object referenced in the originating search. Bond-specific data comes from XTR_BOND_ISSUES, XTR_BOND_COUPON_DATES, and XTR_BOND_ALLOC_DETAILS. Amortisation results are stored in XTR_ACCRLS_AMORT. Banking and settlement information is read from XTR_BANK_ACCOUNTS, XTR_BANK_BALANCES, and XTR_MM_COVERS, while currency and configuration values are obtained from XTR_MASTER_CURRENCIES (and _V), XTR_COMPANY_PARAMETERS, and XTR_PRO_PARAM.

Usage Notes

XTR_ACCRUAL_PROCESS_P is typically invoked from treasury concurrent programs and background batch processes that drive daily or period-end accrual runs. It is also callable from treasury forms and custom PL/SQL extensions where accrual recalculation or bond amortisation is required. Because its outputs feed the journal import process through TSFR_ACCRUALS_FOR_JNL_PROCESS, it should be scheduled ahead of general ledger journal creation. The package is referenced by two other database objects and depends on utility packages including FND_FILE for logging, FND_MESSAGE and APP_EXCEPTION for error handling, and FND_CURRENCY for currency conversions. Implementers should invoke it within a controlled batch context and verify XTR_BATCH_EVENTS_S state before execution.