Search Results xtr_intergroup_transfers




Overview
Explore in AI Chat

Overview

The XTR_INTERGROUP_TRANSFERS table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. It serves as the primary repository for recording and managing intercompany loans and deposits. This table is fundamental for treasury operations that involve financial transactions between different legal entities within the same corporate group. It enables the centralization and tracking of internal funding activities, ensuring proper accounting, compliance, and cash management across the organization. The table's existence underscores the XTR module's capability to handle complex internal banking functions alongside external market transactions.

Key Information Stored

The table stores transactional details for intercompany deals. Its structure is anchored by a composite primary key consisting of DEAL_NUMBER and TRANSACTION_NUMBER, which uniquely identifies each intergroup transaction record. Critical foreign key relationships define the operational context of these deals. The COMPANY_ACCT_USE_ID and CPARTY_ACCT_USE_ID columns link to the CE_BANK_ACCT_USES_ALL table, identifying the specific bank accounts used by the company (lender/depositor) and the counterparty (borrower/receiver) entities within the transaction. Furthermore, the FIRST_BATCH_ID and LAST_BATCH_ID columns reference the XTR_BATCHES table, tracking the accounting and settlement batch processing lifecycle for the transaction. Other columns typically found in such a table would include details on currency, principal amount, interest rates, start and maturity dates, and current status.

Common Use Cases and Queries

Primary use cases revolve around reporting, reconciliation, and audit of internal treasury positions. Treasury analysts use this data to monitor intercompany exposure, assess internal liquidity flows, and ensure adherence to internal lending limits. A common reporting query would join XTR_INTERGROUP_TRANSFERS with CE_BANK_ACCT_USES_ALL and CE_BANK_ACCOUNTS to list all active intercompany loans with their associated bank accounts.

  • Sample Query for Active Intercompany Deals:
    SELECT xit.deal_number, xit.transaction_number, cbaa1.bank_account_name company_account, cbaa2.bank_account_name cparty_account FROM xtr_intergroup_transfers xit JOIN ce_bank_acct_uses_all cbaa1 ON xit.company_acct_use_id = cbaa1.bank_acct_use_id JOIN ce_bank_acct_uses_all cbaa2 ON xit.cparty_acct_use_id = cbaa2.bank_acct_use_id WHERE xit.deal_status = 'ACTIVE';
  • Another critical use case involves limit monitoring, where transactions in this table are checked against pre-defined credit limits for group entities, potentially generating records in the related XTR_LIMIT_EXCESS_LOG.

Related Objects

XTR_INTERGROUP_TRANSFERS is centrally connected to several other key Treasury and Cash Management objects. It has a direct foreign key relationship with XTR_DEAL_DATE_AMOUNTS, which stores time-sensitive amount details (like principal and interest cash flows) for the deal. The XTR_LIMIT_EXCESS_LOG table references it to log any breaches of internal limits caused by these intergroup transactions. For accounting and settlement processing, it is linked to XTR_BATCHES via the FIRST_BATCH_ID and LAST_BATCH_ID. Its integration with Cash Management (CE) is established through the CE_BANK_ACCT_USES_ALL table, which provides the bank account details for both sides of the transaction. This network of relationships positions XTR_INTERGROUP_TRANSFERS as a critical hub for internal financial deal data.