Search Results xtr_source_types




Overview
Explore in AI Chat

Overview

The XTR_SOURCE_TYPES table is a core reference data object within the Oracle E-Business Suite Treasury (XTR) module. It functions as a master repository for classifying and identifying the internal Oracle E-Business Suite applications that are integrated with the system's derivative and hedge accounting capabilities. This table is foundational for establishing the source system context for hedge policies and relationships, ensuring that treasury accounting activities are correctly mapped and processed according to their originating application. Its role is critical for maintaining data integrity and auditability across the integrated financial landscape of Oracle EBS.

Key Information Stored

While the provided metadata does not list specific column details beyond the primary key, the table's structure is designed to catalog distinct source applications. The primary identifier, SOURCE_TYPE_ID, is a unique key that categorizes each integrated source system, such as Payables, Receivables, or General Ledger. Other typical columns in such a reference table would include a code (e.g., SOURCE_TYPE_CODE) and a descriptive name (e.g., DESCRIPTION) for the source application. Additional columns may track status (e.g., ENABLED_FLAG), creation date, and last update date to manage the reference data's lifecycle. The SOURCE_TYPE_ID serves as the critical link to subordinate tables in the hedge accounting process.

Common Use Cases and Queries

The primary use case for the XTR_SOURCE_TYPES table is to support the setup and validation of hedge accounting definitions. When a treasury manager defines a new hedge policy or relationship, they must specify the source application from which the hedged item originates. This table provides the valid list of choices. Common queries involve listing all enabled source types for use in a list of values (LOV) or reporting on hedge activities grouped by their source application. A typical SQL pattern to retrieve all active source types would be:

SELECT source_type_id, source_type_code, description
FROM xtr.xtr_source_types
WHERE enabled_flag = 'Y'
ORDER BY source_type_code;

Another frequent query joins this table to related hedge tables for comprehensive reporting:

SELECT h.hedge_number, s.description AS source_application
FROM xtr_hedge_policies h,
     xtr_source_types s
WHERE h.source_type_id = s.source_type_id;

Related Objects

The XTR_SOURCE_TYPES table is a parent table with defined foreign key relationships to two key hedge accounting entities, as documented in the provided metadata:

  • XTR_HEDGE_POLICIES: The SOURCE_TYPE_ID column in XTR_HEDGE_POLICIES references XTR_SOURCE_TYPES.SOURCE_TYPE_ID. This links each hedge accounting policy to its designated source application.
  • XTR_HEDGE_RELATIONSHIPS: The SOURCE_TYPE_ID column in XTR_HEDGE_RELATIONSHIPS references XTR_SOURCE_TYPES.SOURCE_TYPE_ID. This links individual hedge relationships to their source application, ensuring proper accounting treatment.

These relationships enforce referential integrity, guaranteeing that any hedge policy or relationship recorded in the system is associated with a valid, pre-defined source application from the XTR_SOURCE_TYPES master table.