Search Results xtr_accrls_amort




Overview
Explore in AI Chat

Overview

The XTR_ACCRLS_AMORT table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for storing detailed accrual and amortization amounts generated from financial deal transactions. This table is critical for the accurate accounting and financial reporting of treasury instruments, as it captures the periodic recognition of interest income, expense, and the amortization of premiums or discounts over the life of a deal. Its role is integral to the accrual accounting processes within the Treasury module, ensuring that financial statements reflect the true economic substance of transactions in the correct accounting periods.

Key Information Stored

The table's structure is designed to uniquely identify and store accrual amounts for specific transaction periods. Its primary key is a composite of several columns, ensuring granularity: DEAL_NO identifies the master agreement, TRANS_NO pinpoints the specific transaction within that deal, PERIOD_TO defines the accounting period end date for the accrual, AMOUNT_TYPE classifies the nature of the accrual (e.g., interest, fee, amortization), and ACTION_CODE may indicate the transaction's lifecycle state. The table holds the calculated monetary AMOUNT for the specified period and type. Additional columns, such as BATCH_ID, link the accrual records to the processing batch that generated them, facilitating audit trails and reconciliation.

Common Use Cases and Queries

Primary use cases revolve around financial reporting, period-end close reconciliation, and audit inquiries. Finance teams query this table to verify accrued interest payable or receivable, review amortization schedules for complex instruments, and investigate discrepancies in treasury-related general ledger accounts. A typical reporting query would join to deal and transaction master tables to pull a comprehensive accrual schedule. For example:

  • SELECT a.deal_no, a.trans_no, a.period_to, a.amount_type, a.amount, d.deal_type FROM xtr_accrls_amort a, xtr_deals d WHERE a.deal_no = d.deal_no AND a.period_to BETWEEN :p_start_date AND :p_end_date ORDER BY a.deal_no, a.period_to;
  • Another common pattern is reconciling the sum of accruals for a specific deal and amount type against the deal's total expected accrual over its term.

Related Objects

The XTR_ACCRLS_AMORT table maintains defined foreign key relationships with several master transaction tables in the XTR schema, as documented in the ETRM metadata. These relationships are fundamental for data integrity and join operations:

  • XTR_DEALS: Joined via XTR_ACCRLS_AMORT.DEAL_NO = XTR_DEALS.DEAL_NO. This links accruals to the overarching deal header information.
  • XTR_ROLLOVER_TRANSACTIONS: Joined via the composite key XTR_ACCRLS_AMORT.DEAL_NO = XTR_ROLLOVER_TRANSACTIONS.DEAL_NO and XTR_ACCRLS_AMORT.TRANS_NO = XTR_ROLLOVER_TRANSACTIONS.TRANS_NO. This connects accruals to specific rollover events for instruments like deposits or loans.
  • XTR_BATCHES: Joined via XTR_ACCRLS_AMORT.BATCH_ID = XTR_BATCHES.BATCH_ID. This provides context on the processing run that created the accrual records.