Results for “xtr_a_futures_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_A_FUTURES_V is a reporting view within the Oracle E-Business Suite Treasury (XTR) module. It exposes the full set of attribute columns required to describe, price, and administer futures and exchange-traded derivative contracts maintained in the Treasury contract repository. The view captures the descriptive identity of each instrument (contract code and description), its classification, pricing conventions, settlement behaviour, coupon characteristics, termination rules, and month-level deliverability flags.
In Oracle EBS 12.1.1 and 12.2.2, XTR_A_FUTURES_V functions as a read-only presentation layer over the futures contract definition data. It is intended for inquiry, reporting, and downstream extraction rather than for transactional maintenance. Because it carries audit columns (CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, AUDIT_INDICATOR, AUDIT_DATE_STORED) alongside the business attributes, the view is equally suited to reconciliation and audit reporting as it is to operational inquiry.
The metadata records that the view is not implemented in the reference database, and that no owner or referenced base objects were documented in the ETRM 12.2.2 extract. Consumers should therefore validate object availability in their own instance before building dependent reports.
Underlying Base Objects
The view definition is a straight projection with no joins, aggregation, or filtering predicates:
SELECT ... FROM XTR_A_FUTURES
Every column listed in the view text maps one-to-one to a column of the base table XTR_A_FUTURES. No additional tables, synonyms, or lookup objects are referenced. The absence of a WHERE clause means the view does not, by itself, restrict rows to authorised contracts, active contracts, or any date range; filtering must be supplied by the calling query. The AUTHORISED column is exposed as data, not applied as a predicate.
Since the view is a non-transforming projection, it is inherently updatable in Oracle terms, but the EBS convention remains that contract maintenance is performed through the Treasury application forms and APIs rather than through the view.
Key Columns
- CONTRACT_CODE / CONTRACT_DESCRIPTION — The primary identifier and the free-text description of the futures contract. CONTRACT_DESCRIPTION is the column most frequently referenced in ad hoc searches and report prompts.
- FINANCIAL_CONTRACT, DELIVERABLE, PRICING_BASIS — Classify the instrument and define how it is settled and priced.
- AUTHORISED — Indicates whether the contract definition has been approved for use.
- SETTLEMENT_ADJUSTMENT, UNIT_SIZE, ROUNDING_FACTOR, EX_CODE, CALCULATION_TYPE, TICK_VALUE — Pricing and valuation parameters, including the exchange code, tick value, and rounding behaviour applied to calculated amounts.
- CURRENCY / CONTRA_CURRENCY — The denominated currency and its counterparty currency for cross-currency instruments.
- YEAR_BASIS, CONTRACT_DAYS, CONTRACT_YEARS, COUPONS_PER_YEAR, TOTAL_COUPONS, COUPON_RATE — Day-count and coupon conventions governing accrual and cash flow generation.
- TERMINATION_DATE, TERMINATION_DAY, TERMINATION_WEEK — Termination scheduling attributes.
- CONTRACT_CONFO — Contract confirmation reference.
- JAN_YN through DEC_YN — Twelve month-level indicator flags supporting seasonal or delivery-month logic.
- Audit columns — CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, AUDIT_INDICATOR, AUDIT_DATE_STORED.
Common Use Cases and Queries
Typical scenarios include contract master listings, pricing-convention audits, authorisation status reviews, and extracts feeding risk or valuation engines.
Listing contracts with description and pricing detail:
SELECT CONTRACT_CODE, CONTRACT_DESCRIPTION, PRICING_BASIS, TICK_VALUE, CURRENCY FROM XTR_A_FUTURES_V WHERE AUTHORISED = 'Y';
Searching by description fragment, which mirrors the common "contract_description" lookup:
SELECT CONTRACT_CODE, CONTRACT_DESCRIPTION FROM XTR_A_FUTURES_V WHERE UPPER(CONTRACT_DESCRIPTION) LIKE '%TREASURY BOND%';
Auditing recently modified definitions:
SELECT CONTRACT_CODE, UPDATED_BY, UPDATED_ON FROM XTR_A_FUTURES_V WHERE UPDATED_ON >= TRUNC(SYSDATE) - 30;
Reviewing coupon and termination conventions:
SELECT CONTRACT_CODE, YEAR_BASIS, COUPONS_PER_YEAR, COUPON_RATE, TERMINATION_DATE FROM XTR_A_FUTURES_V;
Because no row-level filtering is built into the view, all business restrictions should be applied explicitly in the consuming query.
-
View: XTR_A_FUTURES_V 12.1.1
Not implemented in this database·Explore XTR module →
-
View: XTR_A_FUTURES_V 12.2.2
Not implemented in this database·Explore XTR module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2