Search Results fv_treasury_confirmations_all




Overview
Explore in AI Chat

Overview

The FV_TREASURY_CONFIRMATIONS_ALL table resides in the FV schema, the Federal Financials product family within Oracle E-Business Suite (validated against 12.1.1 and 12.2.2). It records the confirmations exchanged with the U.S. Treasury for payment schedules transmitted from Oracle Payables. Each row captures a Treasury confirmation event — the associated paid schedule, Treasury check number ranges, amounts, and the disbursement-in-transit account balances tied to the fund balance with Treasury (FBWT) account. The table therefore sits at the junction of disbursement execution, Treasury reconciliation, and federal accounting for funds awaiting clearance.

Under a heuristic Data Vault classification mined from the foreign-key topology, this object models as a link: it connects an accounting context (SET_OF_BOOKS_ID → GL_SETS_OF_BOOKS_11I), a payment (INVOICE_PAYMENT_ID → AP_INVOICE_PAYMENTS_ALL), and a payment instruction (PAYMENT_INSTRUCTION_ID → IBY_PAY_INSTRUCTIONS_ALL). It is not a pure hub because its identity is not a single business entity but the association among these entities plus Treasury confirmation attributes.

Key Information Stored

The table documents 38 columns in the 12.2.2 physical schema. The most operationally significant are:

Common Use Cases and Queries

Typical scenarios include reconciling Treasury confirmed amounts against Payables disbursements, reporting check number ranges for audit, and analyzing disbursement-in-transit balances by fund. A representative query joining to Payables and the ledger is:

  • SELECT c.treasury_confirmation_id, c.checkrun_name, c.begin_doc_num, c.end_doc_num, c.treasury_amount, c.payment_batch_amount, c.confirmation_status_flag FROM fv_treasury_confirmations_all c WHERE c.set_of_books_id = :p_sob AND c.gl_period = :p_period;
  • Join to AP_INVOICE_PAYMENTS_ALL on INVOICE_PAYMENT_ID to trace a confirmation back to the underlying payment.
  • Join to FV_TREASURY_CHECK_RANGES on TREASURY_CONFIRMATION_ID to drill into individual check ranges within a confirmation.

Because the table is multi-org (contains ORG_ID), reporting views should filter by operating unit where applicable.

Related Objects

  • FV_TREASURY_CHECK_RANGES — child table referencing TREASURY_CONFIRMATION_ID; holds the detailed check ranges per confirmation.
  • GL_SETS_OF_BOOKS_11I — parent ledger, joined via SET_OF_BOOKS_ID.
  • AP_INVOICE_PAYMENTS_ALL — parent payment record, joined via INVOICE_PAYMENT_ID.
  • IBY_PAY_INSTRUCTIONS_ALL — parent payment instruction, joined via PAYMENT_INSTRUCTION_ID.
  • APH_PAYMENT_SCHEDULES_ALL — payments schedules transmitted to Treasury, correlating on payment identifiers.
  • FV_TREASURY_ACCT_SYMBOLS — Treasury account symbol definitions used with DIT_CASH_TRAN_CODE.