Search Results xtr_batches




Overview
Explore in AI Chat

Overview

The XTR_BATCHES table is a core data object within the Oracle E-Business Suite Treasury (XTR) module, serving as the central repository for batch process metadata. In the context of Oracle EBS 12.1.1 and 12.2.2, it functions as the master control table for numerous automated and periodic financial operations. Its primary role is to provide an audit trail and a point of reference for critical treasury processes, including revaluations, accruals, amortizations, journal postings, and bank balance reconciliations. Each record in this table represents a distinct execution instance of a batch job, enabling traceability and integrity for downstream financial data.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the primary and foreign keys, the table's structure is designed to catalog essential batch execution details. The primary key, BATCH_ID, uniquely identifies each batch run. A critical foreign key, COMPANY_CODE, links to the XTR_PARTY_INFO table, scoping the batch to a specific legal entity or company within the treasury structure. Based on its described purpose and related objects, the table likely stores additional metadata such as the batch process type (e.g., 'REVALUATION', 'ACCRUAL'), execution date and time, status (e.g., 'RUNNING', 'COMPLETED', 'ERROR'), the initiating user, and potentially descriptive information about the batch's parameters or scope.

Common Use Cases and Queries

This table is pivotal for audit reporting, troubleshooting, and understanding the lineage of financial figures. Common operational and reporting queries include identifying batches for a specific process type within a date range, tracing the origin of journal entries or revaluation figures, and investigating errors. A typical SQL pattern involves joining XTR_BATCHES to transaction detail tables.

  • Batch Audit Report: SELECT batch_id, company_code, creation_date FROM xtr_batches WHERE batch_type = 'REVALUATION' AND TRUNC(creation_date) = :p_date ORDER BY creation_date DESC;
  • Tracing Journal Entries to a Batch: SELECT j.* FROM xtr_journals j, xtr_batches b WHERE j.batch_id = b.batch_id AND b.batch_id = :p_batch_id;
  • Finding the Latest Revaluation for a Deal: SELECT d.deal_number, b.* FROM xtr_deals d, xtr_batches b WHERE d.last_reval_batch_id = b.batch_id AND d.deal_id = :p_deal_id;

Related Objects

The XTR_BATCHES table has extensive relationships throughout the Treasury schema, as evidenced by its numerous foreign key dependencies. It is a parent table to many transactional and reporting tables, including XTR_ACCRLS_AMORT, XTR_BATCH_EVENTS, XTR_DEAL_DATE_AMOUNTS, XTR_JOURNALS, and XTR_REVALUATION_DETAILS. It also serves as a reference point for first and last batch identifiers in key ledger tables such as XTR_BANK_BALANCES, XTR_DEALS, XTR_INTERGROUP_TRANSFERS, and XTR_ROLLOVER_TRANSACTIONS. This network of relationships underscores its role as the foundational control point for batch-processed financial data, ensuring referential integrity across the module.

  • Table: XTR_BATCHES 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BATCHES,  object_name:XTR_BATCHES,  status:VALID,  product: XTR - Treasury ,  description: This table stores the fundamental information for each batch process. ,  implementation_dba_data: XTR.XTR_BATCHES , 

  • Table: XTR_BATCHES 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BATCHES,  object_name:XTR_BATCHES,  status:VALID,  product: XTR - Treasury ,  description: This table stores the fundamental information for each batch process. ,  implementation_dba_data: XTR.XTR_BATCHES , 

  • Table: XTR_RECLASS_DETAILS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_RECLASS_DETAILS,  object_name:XTR_RECLASS_DETAILS,  status:VALID,  product: XTR - Treasury ,  description: Stores reclassified effective unrealized gain/loss amounts. ,  implementation_dba_data: XTR.XTR_RECLASS_DETAILS , 

  • Table: XTR_INTERGROUP_TRANSFERS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_INTERGROUP_TRANSFERS,  object_name:XTR_INTERGROUP_TRANSFERS,  status:VALID,  product: XTR - Treasury ,  description: Intercompany loans or deposits information ,  implementation_dba_data: XTR.XTR_INTERGROUP_TRANSFERS , 

  • Table: XTR_BANK_BALANCES 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BANK_BALANCES,  object_name:XTR_BANK_BALANCES,  status:VALID,  product: XTR - Treasury ,  description: Daily bank balance information ,  implementation_dba_data: XTR.XTR_BANK_BALANCES , 

  • Table: XTR_INTERGROUP_TRANSFERS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_INTERGROUP_TRANSFERS,  object_name:XTR_INTERGROUP_TRANSFERS,  status:VALID,  product: XTR - Treasury ,  description: Intercompany loans or deposits information ,  implementation_dba_data: XTR.XTR_INTERGROUP_TRANSFERS , 

  • Table: XTR_BANK_BALANCES 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BANK_BALANCES,  object_name:XTR_BANK_BALANCES,  status:VALID,  product: XTR - Treasury ,  description: Daily bank balance information ,  implementation_dba_data: XTR.XTR_BANK_BALANCES , 

  • Table: XTR_RECLASS_DETAILS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_RECLASS_DETAILS,  object_name:XTR_RECLASS_DETAILS,  status:VALID,  product: XTR - Treasury ,  description: Stores reclassified effective unrealized gain/loss amounts. ,  implementation_dba_data: XTR.XTR_RECLASS_DETAILS , 

  • Table: XTR_ROLLOVER_TRANSACTIONS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_ROLLOVER_TRANSACTIONS,  object_name:XTR_ROLLOVER_TRANSACTIONS,  status:VALID,  product: XTR - Treasury ,  description: Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals ,  implementation_dba_data: XTR.XTR_ROLLOVER_TRANSACTIONS , 

  • Table: XTR_ROLLOVER_TRANSACTIONS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_ROLLOVER_TRANSACTIONS,  object_name:XTR_ROLLOVER_TRANSACTIONS,  status:VALID,  product: XTR - Treasury ,  description: Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals ,  implementation_dba_data: XTR.XTR_ROLLOVER_TRANSACTIONS , 

  • Table: XTR_DEALS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEALS,  object_name:XTR_DEALS,  status:VALID,  product: XTR - Treasury ,  description: Information for all financial instrument deals except exposure transactions ,  implementation_dba_data: XTR.XTR_DEALS , 

  • Table: XTR_DEALS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEALS,  object_name:XTR_DEALS,  status:VALID,  product: XTR - Treasury ,  description: Information for all financial instrument deals except exposure transactions ,  implementation_dba_data: XTR.XTR_DEALS , 

  • Table: XTR_JOURNALS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_JOURNALS,  object_name:XTR_JOURNALS,  status:VALID,  product: XTR - Treasury ,  description: Detailed journal entry information ,  implementation_dba_data: XTR.XTR_JOURNALS , 

  • Table: XTR_GAIN_LOSS_DNM 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_GAIN_LOSS_DNM,  object_name:XTR_GAIN_LOSS_DNM,  status:VALID,  product: XTR - Treasury ,  description: This table will store denormalization information for accounting purposes. ,  implementation_dba_data: XTR.XTR_GAIN_LOSS_DNM , 

  • Table: XTR_JOURNALS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_JOURNALS,  object_name:XTR_JOURNALS,  status:VALID,  product: XTR - Treasury ,  description: Detailed journal entry information ,  implementation_dba_data: XTR.XTR_JOURNALS , 

  • Table: XTR_ACCRLS_AMORT 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_ACCRLS_AMORT,  object_name:XTR_ACCRLS_AMORT,  status:VALID,  product: XTR - Treasury ,  description: Accrual amounts for deal transactions ,  implementation_dba_data: XTR.XTR_ACCRLS_AMORT , 

  • Table: XTR_ACCRLS_AMORT 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_ACCRLS_AMORT,  object_name:XTR_ACCRLS_AMORT,  status:VALID,  product: XTR - Treasury ,  description: Accrual amounts for deal transactions ,  implementation_dba_data: XTR.XTR_ACCRLS_AMORT , 

  • Table: XTR_HEDGE_RETRO_TESTS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_HEDGE_RETRO_TESTS,  object_name:XTR_HEDGE_RETRO_TESTS,  status:VALID,  product: XTR - Treasury ,  description: Stores hedge level retrospective effectiveness test and measurement details. ,  implementation_dba_data: XTR.XTR_HEDGE_RETRO_TESTS , 

  • Table: XTR_REVALUATION_DETAILS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_REVALUATION_DETAILS,  object_name:XTR_REVALUATION_DETAILS,  status:VALID,  product: XTR - Treasury ,  description: Revaluation results of Treasury deals ,  implementation_dba_data: XTR.XTR_REVALUATION_DETAILS , 

  • Table: XTR_GAIN_LOSS_DNM 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_GAIN_LOSS_DNM,  object_name:XTR_GAIN_LOSS_DNM,  status:VALID,  product: XTR - Treasury ,  description: This table will store denormalization information for accounting purposes. ,  implementation_dba_data: XTR.XTR_GAIN_LOSS_DNM , 

  • Table: XTR_REVALUATION_DETAILS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_REVALUATION_DETAILS,  object_name:XTR_REVALUATION_DETAILS,  status:VALID,  product: XTR - Treasury ,  description: Revaluation results of Treasury deals ,  implementation_dba_data: XTR.XTR_REVALUATION_DETAILS , 

  • Table: XTR_DEAL_RETRO_TESTS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEAL_RETRO_TESTS,  object_name:XTR_DEAL_RETRO_TESTS,  status:VALID,  product: XTR - Treasury ,  description: Stores deal level retrospective effectiveness test and measurement details. ,  implementation_dba_data: XTR.XTR_DEAL_RETRO_TESTS , 

  • Table: XTR_REVALUATION_RATES 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_REVALUATION_RATES,  object_name:XTR_REVALUATION_RATES,  status:VALID,  product: XTR - Treasury ,  description: Revaluation rates for a particular company in an end-of-period date ,  implementation_dba_data: XTR.XTR_REVALUATION_RATES , 

  • Table: XTR_HEDGE_RETRO_TESTS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_HEDGE_RETRO_TESTS,  object_name:XTR_HEDGE_RETRO_TESTS,  status:VALID,  product: XTR - Treasury ,  description: Stores hedge level retrospective effectiveness test and measurement details. ,  implementation_dba_data: XTR.XTR_HEDGE_RETRO_TESTS , 

  • Table: XTR_REVALUATION_RATES 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_REVALUATION_RATES,  object_name:XTR_REVALUATION_RATES,  status:VALID,  product: XTR - Treasury ,  description: Revaluation rates for a particular company in an end-of-period date ,  implementation_dba_data: XTR.XTR_REVALUATION_RATES , 

  • Table: XTR_BATCH_EVENTS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BATCH_EVENTS,  object_name:XTR_BATCH_EVENTS,  status:VALID,  product: XTR - Treasury ,  description: This table will store the information for each event within a parent batch process. ,  implementation_dba_data: XTR.XTR_BATCH_EVENTS , 

  • Table: XTR_BATCH_EVENTS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_BATCH_EVENTS,  object_name:XTR_BATCH_EVENTS,  status:VALID,  product: XTR - Treasury ,  description: This table will store the information for each event within a parent batch process. ,  implementation_dba_data: XTR.XTR_BATCH_EVENTS , 

  • Table: XTR_DEAL_RETRO_TESTS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEAL_RETRO_TESTS,  object_name:XTR_DEAL_RETRO_TESTS,  status:VALID,  product: XTR - Treasury ,  description: Stores deal level retrospective effectiveness test and measurement details. ,  implementation_dba_data: XTR.XTR_DEAL_RETRO_TESTS , 

  • Table: XTR_DEAL_DATE_AMOUNTS 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEAL_DATE_AMOUNTS,  object_name:XTR_DEAL_DATE_AMOUNTS,  status:VALID,  product: XTR - Treasury ,  description: Deal transaction information grouped by date type, amount type, and amount action ,  implementation_dba_data: XTR.XTR_DEAL_DATE_AMOUNTS , 

  • Table: XTR_PARTY_INFO 12.2.2

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_PARTY_INFO,  object_name:XTR_PARTY_INFO,  status:VALID,  product: XTR - Treasury ,  description: Created from Entity XTR PARTY by ORACLE on 06-MAY-93 ,  implementation_dba_data: XTR.XTR_PARTY_INFO , 

  • Table: XTR_DEAL_DATE_AMOUNTS 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_DEAL_DATE_AMOUNTS,  object_name:XTR_DEAL_DATE_AMOUNTS,  status:VALID,  product: XTR - Treasury ,  description: Deal transaction information grouped by date type, amount type, and amount action ,  implementation_dba_data: XTR.XTR_DEAL_DATE_AMOUNTS , 

  • Table: XTR_PARTY_INFO 12.1.1

    owner:XTR,  object_type:TABLE,  fnd_design_data:XTR.XTR_PARTY_INFO,  object_name:XTR_PARTY_INFO,  status:VALID,  product: XTR - Treasury ,  description: Created from Entity XTR PARTY by ORACLE on 06-MAY-93 ,  implementation_dba_data: XTR.XTR_PARTY_INFO , 

  • View: XTR_REVIEW_JOURNALS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XTR.XTR_REVIEW_JOURNALS_V,  object_name:XTR_REVIEW_JOURNALS_V,  status:VALID,  product: XTR - Treasury ,  implementation_dba_data: APPS.XTR_REVIEW_JOURNALS_V , 

  • View: XTR_REVIEW_JOURNALS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XTR.XTR_REVIEW_JOURNALS_V,  object_name:XTR_REVIEW_JOURNALS_V,  status:VALID,  product: XTR - Treasury ,  implementation_dba_data: APPS.XTR_REVIEW_JOURNALS_V ,