Search Results xtr_source_of_imports




Overview
Explore in AI Chat

Overview

The XTR_SOURCE_OF_IMPORTS table is a core data repository within the Oracle E-Business Suite Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to store and manage configuration details for external data sources used in the reconciliation process. This table acts as a master reference, defining the origin and characteristics of financial data imports, such as bank statements or transaction files, before they are processed and reconciled against internal treasury records. By maintaining this metadata, the table ensures that imported data is correctly mapped, validated, and associated with the appropriate internal bank accounts and legal entities, which is critical for accurate cash positioning and treasury operations.

Key Information Stored

The table's structure is designed to define the source system and its linkage to internal EBS entities. While a full column list is not provided in the metadata, the documented foreign keys reveal its critical data points. The primary key is the SOURCE column, uniquely identifying each import source. Essential relational data includes ACCOUNT_NUMBER and COMPANY_CODE, linking to the XTR_BANK_ACCOUNTS table to identify the specific treasury account. The CURRENCY column is validated against XTR_MASTER_CURRENCIES. A key integration point is the BANK_ACCT_USE_ID, which forms a foreign key relationship with CE_BANK_ACCT_USES_ALL, connecting the treasury source definition to the underlying Cash Management bank account use, thereby bridging XTR and CE (Cash Management) modules.

Common Use Cases and Queries

This table is central to configuring and troubleshooting the automated bank statement reconciliation flow. A common operational query involves listing all configured import sources for a specific bank account to verify setup before a data load. For example: SELECT source, currency, bank_acct_use_id FROM xtr_source_of_imports WHERE account_number = '&ACCT_NUM' AND company_code = '&CO_CODE'; Another frequent use case is diagnostic reporting to identify sources that may have missing or invalid linkages, which can cause import failures. Administrators might run a query to find sources without a valid BANK_ACCT_USE_ID or where the referenced currency is inactive. The table is also directly referenced during the import process itself, where the interface logic uses the SOURCE identifier to apply the correct formatting and validation rules defined for that data feed.

Related Objects

The XTR_SOURCE_OF_IMPORTS table sits at the center of a key integration hub. Its primary foreign key relationships are:

  • XTR_BANK_ACCOUNTS: Validates the treasury account (ACCOUNT_NUMBER, COMPANY_CODE).
  • XTR_MASTER_CURRENCIES: Validates the CURRENCY of the imported data.
  • CE_BANK_ACCT_USES_ALL: A critical cross-module link to the Cash Management bank account definition.
Furthermore, it is referenced by the XTR_EXT_IMPORT_INTERFACE table, which likely holds the actual imported transaction records. The SOURCE column in that interface table is a foreign key pointing back to XTR_SOURCE_OF_IMPORTS, ensuring each imported row is tagged with its configured source definition for proper processing and reconciliation.