Results for “xtr_party_defaults”

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

Overview

XTR_PARTY_DEFAULTS is a Treasury (XTR) module table within Oracle E-Business Suite 12.1.1 and 12.2.2 that stores counterparty default settlement information. It defines the settlement, taxation, and brokerage defaults applied to a given party (counterparty, broker, or other trading partner) for specific combinations of product type, deal type, and deal subtype. In practice, the table acts as a configuration and rules repository that influences how Treasury deals are settled, where interest and principal flows are directed, and which tax and brokerage treatments apply by default when transactions are created or processed.

From a Data Vault modeling perspective, the metadata's heuristic classification is link. This reflects the table's role as an associative structure connecting parties to brokerage categories, tax categories, and settlement categories, rather than serving as a pure descriptive satellite. The classification is a modeling suggestion only; functionally, the table is a transactional setup table with audit columns and reference foreign keys.

Key Information Stored

The table contains 23 documented columns in the XTR schema. The rows are uniquely identified by the primary key constraint XTR_PARTY_DEFAULTS_PK, which is defined on the surrogate/business identifier TRANSACTION_NUMBER. The most operationally significant columns are:

• TRANSACTION_NUMBER — Primary key column for the XTR_PARTY_DEFAULTS_PK constraint; identifies each default record.
• PARTY_CODE — The counterparty or party to which the default settlement rules apply, forming the primary business-key candidate alongside transaction context.
• PRODUCT_TYPE — The Treasury product category for which the defaults are defined.
• DEAL_TYPE — The deal type that qualifies the default rule.
• DEAL_SUBTYPE — A finer qualification of the deal type, narrowing the applicable default.
• DEFAULT_TYPE — Indicates the nature of the default record.
• SETTLEMENT_DEFAULT_CATEGORY — Foreign key to XTR_SETTLEMENT_CATEGORIES, defining the default settlement treatment.
• BROKERAGE_CATEGORY — Foreign key to XTR_BROKERAGE_CATEGORIES, defining default brokerage handling.
• TAX_CATEGORY — Foreign key to XTR_TAX_CATEGORIES, defining default tax treatment.
• TAX_REFERENCE and INCOME_TAX_REFERENCE — Tax reference identifiers applied to the default.
• BROKERAGE_REFERENCE — Brokerage reference associated with the default.
• DFLT_PRINCIPAL_ACTION and DFLT_INTEREST_ACTION — Actions to take on defaulted principal and interest amounts.
• PRINCIPAL_SETTLED_BY, INTEREST_SETTLED_BY, and FREQ_INTEREST_SETTLED — Settlement direction and frequency information.
• Audit columns — CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, AUDIT_DATE_STORED, and AUDIT_INDICATOR support standard EBS audit tracking.

Common Use Cases and Queries

Typical usage centers on default resolution for Treasury deal processing and on reporting of counterparty settlement configuration. A common query retrieves the settlement, tax, and brokerage defaults for a party and product combination:

• Resolve defaults by party and product: SELECT party_code, product_type, deal_type, deal_subtype, settlement_default_category, brokerage_category, tax_category FROM xtr_party_defaults WHERE party_code = :party_code AND product_type = :product_type;
• Join to reference tables to decode categories: join SETTLEMENT_DEFAULT_CATEGORY to XTR_SETTLEMENT_CATEGORIES, BROKERAGE_CATEGORY to XTR_BROKERAGE_CATEGORIES, and TAX_CATEGORY to XTR_TAX_CATEGORIES.
• Audit and change tracking: filter on UPDATED_ON, CREATED_BY, or AUDIT_INDICATOR to review recently modified default records.
• Validation reporting: identify parties lacking complete settlement, brokerage, or tax defaults for a given deal type.

Related Objects

The table is linked to several reference objects through documented foreign keys, and it participates in the broader XTR Treasury data model:

• XTR_BROKERAGE_CATEGORIES — referenced via XTR_PARTY_DEFAULTS.BROKERAGE_CATEGORY.
• XTR_TAX_CATEGORIES — referenced via XTR_PARTY_DEFAULTS.TAX_CATEGORY.
• XTR_SETTLEMENT_CATEGORIES — referenced via XTR_PARTY_DEFAULTS.SETTLEMENT_DEFAULT_CATEGORY.
• XTR_PARTY_DEFAULTS_PK — the primary key constraint on TRANSACTION_NUMBER.
• Counterparty and deal tables in the XTR module that reference PARTY_CODE and product/deal attributes to apply the configured defaults during deal entry and settlement processing.
• XTR Treasury setup and deal lifecycle objects that consume settlement, tax, and brokerage defaults for transaction generation and reporting.