Results for “xtr_product_types_v”

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

Overview

XTR_PRODUCT_TYPES_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the configuration of product types used by Treasury deal processing, including deal type classification, authorization requirements, pricing model defaults, market data set defaults, and revaluation behavior. Because it is a view rather than a table, it presents a read-consistent, presentation-layer projection of the underlying definition data and is intended for reporting, inquiry, and integration use rather than for direct maintenance.

In practice, the view functions as the reference list that drives downstream Treasury processing: deal capture, pricing, revaluation, and advice generation all consume the attributes defined here. Report developers, integration specialists, and functional consultants query it to confirm how a given product type is configured before troubleshooting pricing, revaluation, or advice behavior.

Underlying Base Objects

The view is defined over a single documented base object, XTR_PRODUCT_TYPES, referenced through a synonym. The view text is a straightforward column projection with no joins, filters, or aggregation:

• Base object: XTR_PRODUCT_TYPES (SYNONYM)
• Owner: APPS
• Status: VALID

Because the view contains no restricting WHERE clause, it returns every row present in the base table. Row-level security, if any, is therefore not enforced by the view itself; access is governed by grants on the APPS-owned objects and by the responsibilities assigned to the querying user.

Key Columns

• DEAL_TYPE / PRODUCT_TYPE: The classification pair that identifies each product type; DEAL_TYPE groups products into Treasury deal categories.
• PRODUCT_DESC: Descriptive text for the product type, used in inquiry screens and reports.
• PRODUCT_AUTH: Authorization indicator controlling whether deals of this product type require approval.
• CALC_BASIS: The calculation basis applied to interest and related computations.
• DEFAULT_PRICING_MODEL / DEFAULT_MARKET_DATA_SET: Defaults applied during pricing and valuation for deals of this product type.
• DEFAULT_MARGIN: Default margin value used when pricing.
• REVAL_CROSS_REF / ALLOW_REVAL_OVERWRITE_FLAG: Revaluation cross-reference and the flag permitting revaluation values to be overwritten.
• CPARTY_ADVICE / CLIENT_ADVICE: Advice generation controls for counterparty and client notifications.
• AUDIT_INDICATOR: Audit tracking setting for the product type.
• CREATED_BY / CREATED_ON / UPDATED_BY / UPDATED_ON: Standard WHO audit columns recording creation and last update.

Common Use Cases and Queries

Typical scenarios include validating pricing and revaluation setup before month-end processing, driving integration extracts that populate external risk or treasury systems, and building inquiry reports over authorized product types.

List all configured product types:

• SELECT DEAL_TYPE, PRODUCT_TYPE, PRODUCT_DESC, PRODUCT_AUTH FROM XTR_PRODUCT_TYPES_V ORDER BY DEAL_TYPE, PRODUCT_TYPE;

Display default pricing and valuation configuration:

• SELECT PRODUCT_TYPE, DEFAULT_PRICING_MODEL, DEFAULT_MARKET_DATA_SET, DEFAULT_MARGIN FROM XTR_PRODUCT_TYPES_V WHERE DEFAULT_PRICING_MODEL IS NOT NULL;

Identify products permitting revaluation overwrite:

• SELECT PRODUCT_TYPE, REVAL_CROSS_REF, ALLOW_REVAL_OVERWRITE_FLAG FROM XTR_PRODUCT_TYPES_V WHERE ALLOW_REVAL_OVERWRITE_FLAG = 'Y';

Review advice and audit settings:

• SELECT PRODUCT_TYPE, CPARTY_ADVICE, CLIENT_ADVICE, AUDIT_INDICATOR FROM XTR_PRODUCT_TYPES_V WHERE AUDIT_INDICATOR = 'Y';