Search Results xtr_accrual_process_p




Overview
Explore in AI Chat

Overview

The APPS.XTR_ACCRUAL_PROCESS_P package is a core PL/SQL specification within the Oracle E-Business Suite Treasury (ETRM) module. Its primary business function is to perform the period-end accrual, amortisation, and effective-interest computations required for treasury deals, bonds, and interest-bearing instruments. In ETRM 12.1.1 and 12.2.2, this package supports the accounting lifecycle of financial instruments by calculating accruals and amortisation amounts that are subsequently transferred for journal entry processing and sub-ledger posting.

At the top of the specification a global variable, G_batch_id, is declared against XTR_BATCHES.batch_id%TYPE, indicating the package operates in the context of batch-based processing. Batches group deals for a single accrual or accounting run, allowing the package to process a defined population of instruments for a given company and date range. The package is classified as an "OTHER" API in the documented metadata and is referenced by two other packages, confirming its role as a reusable internal engine rather than a public external interface.

Key Procedures and Functions

  • CALCULATE_EFFECTIVE_INTEREST — Computes the effective interest rate and associated discount and day-count figures for an instrument. It takes face value, all-in rate, deal, start and maturity dates, adjustment, year calculation type, calculation basis, and pre-discount-end inputs, and returns the number of days, year basis, discount amount, and effective interest as output parameters. Additional flags and status parameters are provided.
  • CALCULATE_BOND_AMORTISATION — Performs bond amortisation calculations for a specified company and batch across a start and end date, scoped by deal type. This is the procedure most closely associated with bond premium/discount amortisation runs.
  • CALCULATE_ACCRUAL_AMORTISATION — The concurrent-program-style entry point for accrual and amortisation processing. It returns an error buffer and return code, accepting company, batch, start and end dates, and an upgrade-batch flag. This signature is characteristic of an Oracle concurrent program executable.
  • CALC_INTGROUP_CACCT_ACCLS — Calculates intercompany group accruals and accounting class information for a company and batch over a date range, scoped by deal type.
  • CALCULATE_NI_EFFINT — Calculates effective interest for new instruments, accepting both new and current batch identifiers along with batch start and end dates, enabling comparison or migration between batch runs.
  • TSFR_ACCRUALS_FOR_JNL_PROCESS — Transfers calculated accruals into the journal processing flow for a company and end date, preparing them for accounting entry creation.

Tables Accessed

The package reads and writes a range of ETRM tables through APPS synonyms. XTR_BATCHES and XTR_BATCHES_S hold batch headers, while XTR_BATCH_EVENTS and XTR_BATCH_EVENTS_S capture batch event details. XTR_ACCRLS_AMORT stores the calculated accrual and amortisation results. Bond-related data is drawn from XTR_BOND_ISSUES, XTR_BOND_COUPON_DATES, and XTR_BOND_ALLOC_DETAILS. Deal data resides in XTR_DEALS and XTR_DEAL_DATE_AMOUNTS. Currency and cash information is sourced from XTR_MASTER_CURRENCIES, XTR_BANK_ACCOUNTS, and XTR_BANK_BALANCES. Intercompany processing uses XTR_INTERGROUP_TRANSFERS, and configuration parameters are read from XTR_COMPANY_PARAMETERS.

Usage Notes

This package is typically invoked through ETRM concurrent programs, particularly the accrual and amortisation accounting processes, and from treasury forms that require on-demand calculation. The CALCULATE_ACCRUAL_AMORTISATION procedure, with its errbuf and retcode outputs, is the standard concurrent-program entry point. Custom code should call the procedures with the documented parameter semantics and treat the package as an internal engine subject to change across releases; the header reference (xtraccls.pls 120.4) indicates version-tracked source. Because it is referenced by two other packages, direct modification is discouraged.