Search Results xtr_bill_bond_issues_uk

Overview

XTR_BILL_BOND_ISSUES is a Treasury (XTR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores bill and bond issue serial numbers together with descriptive and financial attributes for each issuance. Its documented purpose is to record the serial numbers of bills and bonds and to link those instruments to the Treasury deals to which they are assigned. The table therefore acts as a registry layer between physical or book-entry instruments and the deal structures managed by the Treasury dealing subsystem.

From a Data Vault modeling perspective, the object is best classified heuristically as a link. Its business identity is defined by the combination of bank code, serial number, and instrument type, and it carries foreign keys pointing to both the deal (XTR_DEALS.DEAL_NUMBER) and the counterparty or party (HZ_PARTIES.BANK_ID). Because it also carries descriptive attributes such as amount, currency, and dates, a satellite-style treatment may also be appropriate depending on the modeling standard in use. In the ETRM 12.2.2 physical schema the table is owned by the XTR schema and contains twelve documented columns.

Key Information Stored

The primary key of the table is defined by the unique index XTR_BILL_BOND_ISSUES_UK, comprising BANK_CODE, SERIAL_NUMBER, and NI_OR_BOND. A second documented unique index, XTR_BILL_BOND_ISSUES_U1, is defined on SERIAL_NUMBER, NI_OR_BOND, and BANK_CODE, which is functionally equivalent in composition and confirms the business-key grain. The most significant columns are:

• BANK_CODE — the code identifying the bank or institution associated with the instrument; part of the business key.
• SERIAL_NUMBER — the serial number of the bill or bond; part of the business key.
• NI_OR_BOND — distinguishes whether the instrument is a note issue or a bond; part of the business key.
• BANK_ID — foreign key to HZ_PARTIES, identifying the party or institution record.
• DEAL_NUMBER — foreign key to XTR_DEALS, identifying the deal to which the instrument is assigned.
• TRANSACTION_NUMBER — reference to the originating transaction associated with the instrument.
• AMOUNT — the face or nominal amount recorded for the issue.
• CURRENCY — the currency in which the amount is denominated.
• ISSUE_DATE — the date on which the bill or bond was issued.
• DUE_DATE — the maturity or due date of the instrument.
• STATUS — the current status of the serial number or issuance record.
• PARCEL_SPLIT_NO — the parcel split number where an issue is subdivided across multiple parcels.

Common Use Cases and Queries

Typical usage centers on reconciling instrument serial numbers with the deals they support, verifying outstanding or matured instruments, and reporting issuance activity by bank or currency. A common query joins the table to XTR_DEALS on DEAL_NUMBER to retrieve deal context:

• SELECT i.SERIAL_NUMBER, i.NI_OR_BOND, i.AMOUNT, i.CURRENCY, i.DUE_DATE, d.DEAL_NUMBER FROM XTR_BILL_BOND_ISSUES i, XTR_DEALS d WHERE i.DEAL_NUMBER = d.DEAL_NUMBER;
• Filtering by BANK_CODE and STATUS to list active serial numbers for a given institution.
• Aggregating AMOUNT by CURRENCY and NI_OR_BOND to produce issuance exposure reports.
• Joining to HZ_PARTIES on BANK_ID to enrich reports with party names and identifiers.
• Comparing ISSUE_DATE and DUE_DATE to identify instruments approaching maturity.

Related Objects

The most significant related objects follow directly from the documented foreign keys:

• XTR_DEALS — joined via XTR_BILL_BOND_ISSUES.DEAL_NUMBER = XTR_DEALS.DEAL_NUMBER; provides the deal context for each instrument.
• HZ_PARTIES — joined via XTR_BILL_BOND_ISSUES.BANK_ID = HZ_PARTIES.PARTY_ID; supplies party and bank details.
• XTR_BILL_BOND_ISSUES_UK / XTR_BILL_BOND_ISSUES_U1 — unique indexes enforcing the business keys.
• XTR_TRANSACTIONS — the transaction layer referenced by TRANSACTION_NUMBER, where populated.
• XTR_DEAL_TYPES and related Treasury deal views — used to classify and report issuance activity alongside bill and bond deal types.