Results for “default_margin”

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

Overview

XTR_PRODUCT_TYPES is a Treasury (XTR) module reference table in Oracle EBS 12.1.1 and 12.2.2 that stores product type information for treasury deals. It defines the valid combinations of deal type and product type that the Treasury application recognizes, and it acts as the central classification hub against which deals, dealer limits, and time restrictions are validated. Because the primary key is a composite of business attributes — DEAL_TYPE and PRODUCT_TYPE — and because multiple downstream transactional and setup tables carry foreign keys back to this table, the object exhibits the characteristics of a hub in a Data Vault model. This classification is a heuristic modeling suggestion derived from the foreign key topology rather than an Oracle-mandated design; the table itself is a conventional relational master table.

Key Information Stored

The table contains 17 documented columns in the XTR schema. The composite primary key, XTR_PRODUCT_TYPES_PK, is defined on DEAL_TYPE and PRODUCT_TYPE; a unique index XTR_PRODUCT_TYPES_U1 on the same two columns is the business-key candidate, confirming that the deal type and product type pairing is the natural identifier. The most significant columns are:

• DEAL_TYPE — foreign key to XTR_DEAL_TYPES; identifies the treasury deal category.
• PRODUCT_TYPE — the product classification within the deal type.
• PRODUCT_DESC — descriptive text for the product type.
• PRODUCT_AUTH — authorization indicator controlling permitted use of the product.
• CALC_BASIS — calculation basis used for pricing or interest computations.
• DEFAULT_PRICING_MODEL — default pricing model applied when deals use this product type.
• DEFAULT_MARKET_DATA_SET — default market data set for valuation.
• DEFAULT_MARGIN — default margin applied to the product type.
• REVAL_CROSS_REF — revaluation cross-reference used in accounting and revaluation processing.
• ALLOW_REVAL_OVERWRITE_FLAG — controls whether revaluation values may be overwritten.
• AUDIT_INDICATOR — audit tracking flag.
• CLIENT_ADVICE and CPARTY_ADVICE — advice generation controls for the client and counterparty.
• CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON — standard EBS audit columns.

Common Use Cases and Queries

Typical usage includes validating deal setup, driving default pricing and market data selection during deal capture, and reporting on authorized products. A representative query listing products for a deal type is:

SELECT product_type, product_desc, product_auth FROM xtr.xtr_product_types WHERE deal_type = :deal_type AND product_auth = 'Y';

Joining to deals for reporting is equally common:

SELECT d.deal_number, p.product_type, p.product_desc FROM xtr.xtr_deals d JOIN xtr.xtr_product_types p ON d.deal_type = p.deal_type AND d.product_type = p.product_type;

Because the DEFAULT_PRICING_MODEL and DEFAULT_MARKET_DATA_SET columns feed valuation logic, reporting on those defaults supports treasury configuration reviews and migration validation.

Related Objects

The table participates in the following documented relationships:

• XTR_DEAL_TYPES — referenced by XTR_PRODUCT_TYPES.DEAL_TYPE; the parent deal type definition.
• XTR_DEALS — references this table via DEAL_TYPE and PRODUCT_TYPE.
• XTR_DEALER_LIMITS — references this table via DEAL_TYPE and PRODUCT_TYPE.
• XTR_TIME_RESTRICTIONS — references this table via DEAL_TYPE.

These relationships establish XTR_PRODUCT_TYPES as a shared reference object underpinning treasury deal processing, limit management, and time restriction enforcement across the XTR module.