Search Results trans_num




Overview
Explore in AI Chat

Overview

XTR_VALIDATE_TRANSACTIONS_V is a Treasury (XTR) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that consolidates Treasury deal and transaction records into a single validation-oriented result set. Its distinguishing feature is a discriminator column named VALIDATE_TYPE, which classifies each row as one of three categories: TRANS, DEAL, or SETTLE. This design allows Treasury validation and authorization processes to query one unified structure rather than three separate source views, simplifying the identification of records awaiting dual authorization or settlement validation.

The view is documented as not implemented at the database level in the source environment, and no base objects are formally registered against it in the ETRM metadata. Nevertheless, its view text is fully defined and references other Treasury views. The view serves as a logical reporting and integration layer, exposing deal-level attributes alongside user-friendly deal type and subtype descriptions resolved from configuration tables.

Underlying Base Objects

The view text is constructed from three branches combined with UNION ALL:

All three branches share identical join predicates against the deal type and subtype configuration tables, ensuring consistent descriptive enrichment across the union.

Key Columns

Common Use Cases and Queries

The view supports pending-authorization reporting, settlement reconciliation, and integration extracts where a single, categorized feed of Treasury activity is required. Because VALIDATE_TYPE partitions the data, consumers can isolate the population relevant to each stage.

Retrieving all pending settlement validations:

SELECT validate_type, deal_num, trans_num, cparty_code,
       user_deal_type, user_deal_subtype,
       dual_authorisation_by, dual_authorisation_on
FROM   xtr_validate_transactions_v
WHERE  validate_type = 'SETTLE';

Counting records by validation category for a dashboard:

SELECT validate_type, COUNT(*) rec_count
FROM   xtr_validate_transactions_v
GROUP  BY validate_type;

Locating deals of a specific user-facing type and subtype:

SELECT deal_num, trans_num, deal_date, product_type
FROM   xtr_validate_transactions_v
WHERE  user_deal_type = :p_deal_type
AND    user_deal_subtype = :p_subtype
AND    validate_type = 'DEAL';

Because the view is documented as not implemented in the source database, administrators should confirm its presence and validity in each target instance before relying on it in concurrent programs, BI Publisher reports, or outbound interfaces.