Search Results xtr_bill_bond_issues_v




Overview
Explore in AI Chat

Overview

XTR_BILL_BOND_ISSUES_V is a reporting view owned by the APPS schema within the XTR (Treasury) product family of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It exposes the bill and bond issuance records maintained by the Treasury module, presenting an outbound-facing projection of instruments that a company has issued — as opposed to instruments held as investments. The view exists to provide a stable, read-only interface for reporting, inquiry screens, Discoverer workbooks, and integration extracts without requiring consumers to bind directly to the underlying transactional table. Because the defining query is a simple projection with no joins or aggregations, the view imposes no performance penalty beyond that of the base table, and it protects dependent reports from column-level changes in the physical table. Users searching on the column issue_date reach this object when tracing the issuance or settlement date of a bill or bond.

Underlying Base Objects

The view is defined over a single documented base object, XTR_BILL_BOND_ISSUES, referenced through a synonym in the APPS schema. The defining text is a straight column-list SELECT:

There are no joins, filters, or expressions, so one row in the view corresponds exactly to one row in the base table. All insert, update, and delete activity is performed against XTR_BILL_BOND_ISSUES; the view is read-only in practice. The base table itself records both issued notes and bonds at the parcel or split level, which is why PARCEL_SPLIT_NO appears as a disambiguating key alongside the deal number.

Key Columns

  • NI_OR_BOND — Instrument classification indicator, distinguishing a note issue (NI) from a bond issue.
  • BANK_CODE — Identifier of the bank or agent associated with the issuance.
  • SERIAL_NUMBER — Serial identifier assigned to the certificate or instrument.
  • ISSUE_DATE — The date on which the bill or bond was issued; the primary date column used in aging, maturity, and period-activity reporting.
  • DEAL_NUMBER — Treasury deal number linking the issuance to its originating deal.
  • PARCEL_SPLIT_NO — Split or parcel sequence number where a deal is issued in multiple tranches.
  • STATUS — Current lifecycle state of the issuance (for example, outstanding, matured, or cancelled).
  • DUE_DATE — Maturity or redemption date of the instrument.
  • CURRENCY — Denomination currency of the issue.
  • AMOUNT — Face or principal amount issued.
  • TRANSACTION_NUMBER — Transaction reference associating the issuance with its accounting or subledger entry.

Common Use Cases and Queries

Typical uses include outstanding-issuance listings, maturity ladders, and reconciliation of Treasury issuance activity to General Ledger balances. A common query filters or orders by the issue date:

  • SELECT deal_number, serial_number, ni_or_bond, issue_date, due_date, currency, amount, status FROM apps.xtr_bill_bond_issues_v WHERE issue_date BETWEEN :p_from AND :p_to ORDER BY issue_date, deal_number;
  • SELECT ni_or_bond, currency, SUM(amount) FROM apps.xtr_bill_bond_issues_v WHERE status = 'OUTSTANDING' GROUP BY ni_or_bond, currency;
  • SELECT b.deal_number, b.serial_number, b.issue_date, b.due_date FROM apps.xtr_bill_bond_issues_v b WHERE b.due_date >= SYSDATE AND b.status = 'OUTSTANDING' ORDER BY b.due_date;

When tracing an unintended result on issue_date, note that the value is taken directly from XTR_BILL_BOND_ISSUES with no transformation; discrepancies therefore originate in the base table or in the Treasury setup that populated it, not in the view itself.