Search Results fv_treasury_confirmation_pk

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:

• TREASURY_CONFIRMATION_ID — surrogate primary key, enforced by unique index FV_TREASURY_CONFIRMATION_U1 and constraint FV_TREASURY_CONFIRMATION_PK. This is the sole documented business-key candidate and the join anchor to child tables.
• CHECKRUN_NAME — the payment run (check run) identifier for the confirmation batch.
• TREASURY_DOC_DATE and ACCEPTANCE_DATE — the Treasury document date and the date the confirmation was accepted, used for aging and settlement reporting.
• BEGIN_DOC_NUM and END_DOC_NUM — the starting and ending Treasury check/document numbers for the confirmed range.
• TREASURY_AMOUNT and PAYMENT_BATCH_AMOUNT — the amount confirmed by Treasury versus the amount in the originating payment batch.
• CONFIRMATION_STATUS_FLAG — the lifecycle state of the confirmation (e.g., transmitted, accepted, rejected).
• GL_PERIOD — the accounting period to which the confirmation activity is attributed.
• DIT_CASH_TRAN_CODE — the disbursement-in-transit cash transaction code tied to the fund balance with Treasury account.
• SET_OF_BOOKS_ID, INVOICE_PAYMENT_ID, PAYMENT_INSTRUCTION_ID, ORG_ID — the foreign-key and operating-unit context.
• RANGE_TYPE, EVENT_ID — classification of the document range and the originating event.
• Standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY) and fifteen ATTRIBUTE1–15 / ATTRIBUTE_CATEGORY descriptor columns.

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.