Search Results fv_treasury_confirmations_all




Overview
Explore in AI Chat

Overview

The table FV_TREASURY_CONFIRMATIONS_ALL is a core data object within the Oracle E-Business Suite Federal Financials (FV) module, specifically for versions 12.1.1 and 12.2.2. It serves as the system of record for tracking and confirming payment information transmitted to the U.S. Treasury. Its primary role is to manage the reconciliation of federal disbursements by storing critical confirmation details for payment schedules, including check number ranges and associated accounting information. This table is essential for federal agencies to maintain compliance with Treasury reporting requirements and to facilitate the accurate posting of disbursement transactions to the appropriate fund balance with Treasury accounts.

Key Information Stored

The table stores transactional and control data related to Treasury confirmations. Based on the provided metadata, key columns include the primary key, TREASURY_CONFIRMATION_ID, which uniquely identifies each confirmation record. The SET_OF_BOOKS_ID links the confirmation to a specific ledger or accounting entity. The INVOICE_PAYMENT_ID creates a critical link to the source payment transaction in the Accounts Payable module via the AP_INVOICE_PAYMENTS_ALL table. Other significant data, as indicated by the description, includes paid schedule numbers, Treasury check number ranges, the disbursement in transit account number, and the fund balance with the Treasury account number. This structure enables the tracking of a payment from its creation in Oracle Payables through its confirmation by the U.S. Treasury.

Common Use Cases and Queries

A primary use case is the reconciliation of Treasury-reported disbursements against internal payment records. Financial analysts run queries to identify unmatched payments or to confirm the status of transmitted schedules. Common reporting needs include listing all confirmations for a specific payment batch or within a date range to support month-end closing procedures. A typical SQL pattern involves joining to the AP_INVOICE_PAYMENTS_ALL and related invoice tables to get payment details.

SELECT ftc.treasury_confirmation_id,
       ftc.paid_schedule_number,
       aipa.check_id,
       aipa.invoice_id
FROM   fv_treasury_confirmations_all ftc,
       ap_invoice_payments_all aipa
WHERE  ftc.invoice_payment_id = aipa.invoice_payment_id
AND    ftc.set_of_books_id = :p_sob_id
AND    aipa.creation_date BETWEEN :p_date_from AND :p_date_to;

Another critical use case is generating audit trails for Treasury reporting, ensuring every disbursement has a corresponding Treasury confirmation record for accountability.

Related Objects

The table maintains defined foreign key relationships with other core EBS tables, as documented in the metadata:

  • GL_SETS_OF_BOOKS_11I: Joined via the SET_OF_BOOKS_ID column. This relationship ties the Treasury confirmation to the specific general ledger set of books.
  • AP_INVOICE_PAYMENTS_ALL: Joined via the INVOICE_PAYMENT_ID column. This is the most critical operational link, connecting the Treasury confirmation record back to the original payment transaction recorded in the Accounts Payable module.

These relationships are fundamental for any data integrity checks, reporting, or process flows that require tracing a payment from its Treasury confirmation back to its source invoice and ledger.

  • Table: FV_TREASURY_CONFIRMATIONS_ALL 12.2.2

    owner:FV,  object_type:TABLE,  fnd_design_data:FV.FV_TREASURY_CONFIRMATIONS_ALL,  object_name:FV_TREASURY_CONFIRMATIONS_ALL,  status:VALID,  product: FV - Federal Financials ,  description: Contains information about the paid schedule numbers, Treasury check number ranges, and payment schedules sent to the U.S. Treasury; stores the disbursement in transit account number of the fund balance with the Treasury account number aft ,  implementation_dba_data: FV.FV_TREASURY_CONFIRMATIONS_ALL , 

  • Table: FV_TREASURY_CONFIRMATIONS_ALL 12.1.1

    owner:FV,  object_type:TABLE,  fnd_design_data:FV.FV_TREASURY_CONFIRMATIONS_ALL,  object_name:FV_TREASURY_CONFIRMATIONS_ALL,  status:VALID,  product: FV - Federal Financials ,  description: Contains information about the paid schedule numbers, Treasury check number ranges, and payment schedules sent to the U.S. Treasury; stores the disbursement in transit account number of the fund balance with the Treasury account number aft ,  implementation_dba_data: FV.FV_TREASURY_CONFIRMATIONS_ALL , 

  • View: FV_TC_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:FV.FV_TC_GL_V,  object_name:FV_TC_GL_V,  status:VALID,  product: FV - Federal Financials ,  implementation_dba_data: APPS.FV_TC_GL_V , 

  • View: FV_TC_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:FV.FV_TC_GL_V,  object_name:FV_TC_GL_V,  status:VALID,  product: FV - Federal Financials ,  implementation_dba_data: APPS.FV_TC_GL_V ,