Search Results fv_finance_charge_controls_all




Overview
Explore in AI Chat

Overview

The FV_FINANCE_CHARGE_CONTROLS_ALL table is a core data repository within the Oracle E-Business Suite Federal Financials (FV) module. It serves as the master control table for configuring and managing finance charge policies, which are critical for automating the calculation and assessment of late payment charges on receivables in a federal government context. Its role is to define the rules—such as interest rates, grace periods, and calculation methods—that govern how finance charges are applied to specific transaction types and sets of books, ensuring compliance with federal fiscal regulations.

Key Information Stored

The table's primary structure is anchored by the CHARGE_ID, which uniquely identifies each finance charge control rule. Two critical foreign key columns establish its operational scope: SET_OF_BOOKS_ID links the rule to a specific accounting ledger, while TRX_TYPE_ID associates it with a particular Receivables transaction type. Although the provided metadata does not list all columns, typical data stored includes parameters for the annual interest rate, minimum finance charge amount, calculation frequency (e.g., monthly), days of grace before charges apply, and effective date ranges. The ALL suffix indicates the table supports multi-organization access control (MOAC), storing data for multiple operating units.

Common Use Cases and Queries

This table is central to the periodic process of generating finance charges. A common operational query involves retrieving active charge rules for a specific ledger to be processed by a concurrent program. For example:

  • Identifying Active Rules: SELECT charge_id, trx_type_id FROM fv_finance_charge_controls_all WHERE set_of_books_id = :sob_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
  • Troubleshooting Configuration: Analysts often join this table with RA_CUST_TRX_TYPES_ALL and GL_SETS_OF_BOOKS to verify that a charge rule is correctly assigned to the intended transaction type and ledger.
  • Reporting: The table is a primary source for audit reports detailing the configured finance charge policies across the enterprise, ensuring policy consistency and regulatory adherence.

Related Objects

The table maintains integral relationships with several other Federal Financials and Receivables objects, as indicated by its foreign keys. It is a parent table to FV_FINANCE_CHARGE_HISTORY, which logs the detailed results of charge calculations, and to FV_FINANCE_CHRG_CUST_CLASSES, which can refine charge applicability by customer classification. Its key dependencies are on foundational EBS tables: GL_SETS_OF_BOOKS_11I (now GL_LEDGERS in R12) for the accounting context and RA_CUST_TRX_TYPES_ALL for the transactional context. Any customization or data fix involving finance charge logic must carefully consider these relationships to maintain data integrity.