Search Results xtr_dealer_codes_v




Overview
Explore in AI Chat

Overview

XTR_DEALER_CODES_V is a read-only reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product module. It exposes dealer code configuration maintained in Treasury together with the corresponding Oracle EBS application user identity. In Treasury and risk management workflows, a "dealer" represents an internal or external counterparty authorised to transact deals — foreign exchange contracts, money market instruments, and similar treasury products. The view resolves the numeric USER_ID stored against each dealer code into a human-readable application user name, allowing report authors, integrators, and support analysts to join dealer definitions to the FND_USER directory without writing the join themselves.

The object has been present since the 11i lineage and remains valid on both Oracle EBS 12.1.1 and 12.2.2. On 12.2.2, which runs on the Oracle Database 11.2.0.4 or 12.1.0.2 technology stack and introduces online patching, this view is an APPS-owned editioning-compatible object; its definition is identical across the two releases. It is intended purely for query access and carries no DML capability of its own.

Underlying Base Objects

The view is defined over two documented base objects, both accessed through synonyms in the APPS schema:

  • XTR_DEALER_CODES — the Treasury dealer code definition table. This is the primary source of all dealer-specific attributes exposed by the view.
  • FND_USER — the Oracle Applications user repository, joined on USER_ID to resolve the application login name associated with the dealer record.

The join condition is an inner equi-join on USER_ID: WHERE XDC.USER_ID = FU.USER_ID. A row is therefore returned only when the dealer's USER_ID has a matching and normally active entry in FND_USER; dealer records whose referenced user has been removed or never existed will not appear in the view.

Key Columns

  • DEALER_CODE — the Treasury-defined identifier for the dealer; the natural business key used throughout Treasury transaction and limit screens.
  • DEALER_USER_NAME — the dealer name as captured on the XTR_DEALER_CODES record, distinct from the FND_USER login name.
  • USER_ID — the foreign key to FND_USER; the join key between the two base objects.
  • APPLICATION_USER — the FND_USER.USER_NAME value, i.e. the Oracle EBS login assigned to the dealer.
  • AUDIT_INDICATOR — treasury-specific flag controlling whether dealer activity for this code is audited.
  • ALLOW_OVERRIDE — flag indicating whether the dealer is permitted to override standard limits or validations in Treasury processing.
  • CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON — standard Oracle EBS "who column" audit attributes recording the application user and timestamp of insertion and last update on the underlying dealer record.

Common Use Cases and Queries

Typical scenarios include validating dealer-to-user mappings during implementation or user migration, reconciling dealer codes before and after an FND_USER cleanup, and driving dealer lookup lists in custom reports and integrations such as Treasury deal extracts.

List all dealers with their application users:

SELECT dealer_code, dealer_user_name, application_user
FROM   apps.xtr_dealer_codes_v
ORDER BY dealer_code;

Identify dealers permitting overrides, for control review:

SELECT dealer_code, dealer_user_name, application_user, allow_override
FROM   apps.xtr_dealer_codes_v
WHERE  allow_override = 'Y';

Find dealer codes mapped to a specific EBS login:

SELECT dealer_code, dealer_user_name
FROM   apps.xtr_dealer_codes_v
WHERE  application_user = 'JSMITH';

Review recent configuration changes:

SELECT dealer_code, updated_by, updated_on, audit_indicator
FROM   apps.xtr_dealer_codes_v
WHERE  updated_on >= SYSDATE - 30;

Because the view is APPS-owned, queries should be issued against the APPS synonym. No DML should be attempted against XTR_DEALER_CODES_V; dealer maintenance is performed through the Treasury setup forms against XTR_DEALER_CODES.