Results for “forward_point_factor”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_AUTH_CCY_COMBINATIONS is a Treasury (XTR) module configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores currency pair combination information, including whether each combination is authorised for use in foreign exchange and treasury transactions. The table lives in the XTR schema and carries a VALID status in the data dictionary. Its functional purpose is to act as the authoritative reference list of currency quote pairs — the first currency and second currency in a quote convention — against which Treasury users may execute deals, revalue positions, or maintain rates.

Each row represents one ordered currency pair. The two currencies are held in CURRENCY_QUOTE_FIRST and CURRENCY_QUOTE_SECOND, and both columns are validated against XTR_MASTER_CURRENCIES. The AUTHORISED flag governs whether the pair may be transacted. The presence of audit columns and a forward-point factor indicates the table is maintained rather than transient reference data.

From a Data Vault modelling perspective, the mined FK structure suggests a satellite-leaning classification. The table is anchored by a two-part business key (the two currency codes) rather than a single surrogate identifier, and it records descriptive and status attributes — AUTHORISED, FX_SEQ_NO, FORWARD_POINT_FACTOR — around that key. In a dimensional or Data Vault design this would typically be modelled as a satellite hanging off the currency hub(s), with the pair itself forming a link between two currency hub entities.

Key Information Stored

• CURRENCY_QUOTE_FIRST — the base (first) currency of the quote pair; foreign key to XTR_MASTER_CURRENCIES; participates in the primary key.
• CURRENCY_QUOTE_SECOND — the terms (second) currency of the quote pair; foreign key to XTR_MASTER_CURRENCIES; participates in the primary key.
• AUTHORISED — flag indicating whether the currency combination is authorised for use in Treasury processing.
• FX_SEQ_NO — sequence number used in foreign exchange processing order for the combination.
• FORWARD_POINT_FACTOR — factor applied to derive forward points for the currency pair.
• LAST_TRANSACTION_CHANGED — identifier or timestamp recording the last transaction that modified the row.
• AUDIT_INDICATOR — audit trail indicator for the record.
• CREATED_BY / CREATED_ON — standard WHO columns capturing row creation.
• UPDATED_BY / UPDATED_ON — standard WHO columns capturing the last update.

The surrogate-style primary key is enforced by XTR_AUTH_CCY_COMBINATIONS_PK, defined on (CURRENCY_QUOTE_FIRST, CURRENCY_QUOTE_SECOND). A separate unique index, XTR_AUTH_CCY_COMBINATIONS_U1, exists on the identical column pair and represents the business-key candidate for the table. The documented physical schema contains 11 columns in total.

Common Use Cases and Queries

The most common use case is validating that a currency pair is authorised before allowing a Treasury deal to be entered. A typical lookup returns the authorisation status for a specific pair:

• Retrieve all authorised combinations: SELECT CURRENCY_QUOTE_FIRST, CURRENCY_QUOTE_SECOND, AUTHORISED FROM XTR.XTR_AUTH_CCY_COMBINATIONS WHERE AUTHORISED = 'Y';
• Check a single pair: SELECT AUTHORISED, FX_SEQ_NO, FORWARD_POINT_FACTOR FROM XTR.XTR_AUTH_CCY_COMBINATIONS WHERE CURRENCY_QUOTE_FIRST = :first AND CURRENCY_QUOTE_SECOND = :second;
• List all combinations involving one currency: join to XTR_MASTER_CURRENCIES on either quote column to resolve currency names.

Reporting scenarios include generating a list of tradable currency pairs for Treasury operations, auditing which pairs have forward-point factors configured, and reconciling quote pairs against buy/sell combinations maintained in XTR_BUY_SELL_COMBINATIONS. Because the key is the currency pair itself, lookups are index-driven and efficient.

Related Objects

• XTR_MASTER_CURRENCIES — referenced twice, via CURRENCY_QUOTE_FIRST and CURRENCY_QUOTE_SECOND, providing the currency code definitions for both legs of the pair.
• XTR_BUY_SELL_COMBINATIONS — references this table through CURRENCY_FIRST and CURRENCY_SECOND, linking buy/sell combination setup to the authorised currency combination records.
• XTR_AUTH_CCY_COMBINATIONS_PK — the primary key constraint enforcing uniqueness on the currency pair.
• XTR_AUTH_CCY_COMBINATIONS_U1 — the unique index serving as the business-key candidate over (CURRENCY_QUOTE_FIRST, CURRENCY_QUOTE_SECOND).

Together these objects form the currency-pair reference foundation supporting Treasury deal entry, rate maintenance, and foreign exchange processing within the XTR module.