Search Results fv_bd_controls

Overview

The FV_BD_CONTROLS table 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. As documented, its primary role is to store transactional records for budgetary discounts. In the context of U.S. federal accounting, budgetary discounts refer to reductions in payment amounts offered by vendors for early payment of invoices, which must be recorded and tracked according to federal fiscal policy. This table serves as the system of record for these transactions, ensuring compliance and enabling proper accounting for discount amounts against obligated funds.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and foreign key relationship indicate it stores critical data linking budgetary discount transactions to their associated payments. Based on its function and relationship, key fields likely include a unique transaction identifier, the associated INVOICE_PAYMENT_ID (as confirmed by the foreign key), the calculated or applied discount amount, transaction dates, and status flags. The table will also contain accounting attributes, such as the budget accounting flexfield combination (e.g., Account, Funds Center, Program) against which the discount is posted, and reference information to tie the discount back to the original purchase obligation and invoice.

Common Use Cases and Queries

The primary use case is the generation of reports for audit and funds management, showing discounts taken by payment and their corresponding budget impact. Finance analysts run queries to reconcile discount transactions with payment batches and to analyze discount performance. A common reporting pattern involves joining to the related payment table to retrieve invoice and vendor details.

Sample Query Pattern:
SELECT bd.*, ap.check_id, ap.invoice_id
FROM fv.fv_bd_controls bd,
     ap.ap_invoice_payments_all ap
WHERE bd.invoice_payment_id = ap.invoice_payment_id
AND ap.creation_date BETWEEN :p_start_date AND :p_end_date;
This query retrieves discount transactions for payments created within a specific period, which is fundamental for period-end closing and reconciliation activities within the Federal Financials module.

Related Objects

The documented foreign key relationship explicitly defines this table's primary integration point within the EBS schema. The key related object is:

• AP_INVOICE_PAYMENTS_ALL: This table in the Payables module stores records for each payment made against an invoice. The relationship is established via the column FV_BD_CONTROLS.INVOICE_PAYMENT_ID, which references a corresponding record in AP_INVOICE_PAYMENTS_ALL. This relationship is critical, as it ensures every budgetary discount transaction is directly tied to a specific invoice payment, maintaining data integrity and enabling end-to-end traceability from the discount back to the original invoice and obligation.