Search Results xtr_bond_coupon_dates




Overview
Explore in AI Chat

Overview

The XTR_BOND_COUPON_DATES table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the system of record for storing the complete schedule of coupon payment dates associated with individual bond issues. This table is fundamental for the accurate calculation of accrued interest, cash flow forecasting, and the automated processing of periodic coupon payments. Its existence is critical for managing fixed-income securities, ensuring that all future income obligations derived from bond holdings are systematically tracked and available for financial operations and reporting.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and foreign key relationship define its essential structure. The primary data stored is the chronological series of dates on which coupon payments are due for a given bond. The key column is BOND_ISSUE_CODE, which acts as a foreign key linking each coupon schedule entry to its parent bond issue record in the XTR_BOND_ISSUES table. Other typical columns in such a structure would include the specific COUPON_DATE, a sequence number, and potentially fields for the coupon payment status or amount. This table effectively translates a bond's stated coupon frequency (e.g., semi-annual) into explicit, instance-based calendar dates for system processing.

Common Use Cases and Queries

The primary use case is the generation of cash flow reports and payment advices for upcoming coupon collections. Treasury analysts run queries to identify all payments due within a specific period for cash management. A common query pattern involves joining to the XTR_BOND_ISSUES table to fetch bond details. For example, to find all coupon dates for a specific bond issue, one might use:

  • SELECT * FROM XTR_BOND_COUPON_DATES WHERE BOND_ISSUE_CODE = '<ISSUE_CODE>' ORDER BY COUPON_DATE;

Furthermore, the table is integral to accrued interest calculations at a given valuation date. Systems query for the next and previous coupon dates relative to the settlement date to determine the accrual period. In the context of the user's search ("what type of bond is CO"), while this table does not define bond types, it is queried in conjunction with XTR_BOND_ISSUES to analyze the payment schedule of bonds, which may be filtered by various attributes including type.

Related Objects

The table has a direct and critical dependency on the XTR_BOND_ISSUES table, as defined by its foreign key. The BOND_ISSUE_CODE in XTR_BOND_COUPON_DATES references the primary key in XTR_BOND_ISSUES, establishing a one-to-many relationship where one bond issue has many coupon dates. This table is also a likely source for various treasury reports and views within the XTR module that present cash flow projections or bond portfolio analytics. It may be referenced by payment processing engines or interfaces that automate the journal entry creation for coupon income.