Search Results fv_finance_chrg_cust_classes




Overview
Explore in AI Chat

Overview

The FV_FINANCE_CHRG_CUST_CLASSES 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. It functions as a reference or lookup table that defines and stores distinct customer types or classifications for the purpose of applying finance charges. Its primary role is to enable differentiated finance charge policies within the federal government's receivables management process. By categorizing customers into specific classes, agencies can configure and automate the application of varying finance charge rates, terms, and rules based on the debtor's classification, ensuring compliance with federal fiscal policies.

Key Information Stored

The table's structure is designed to link customer classifications to specific financial contexts and control rules. Based on the provided metadata, the critical columns include:

  • CHARGE_CUST_ID: The primary key column that uniquely identifies each customer class record within the system.
  • CHARGE_ID: A foreign key column that links the customer class to a specific finance charge rule defined in the FV_FINANCE_CHARGE_CONTROLS_ALL table. This establishes which set of finance charge parameters applies to this customer class.
  • SET_OF_BOOKS_ID: A foreign key column linking to GL_SETS_OF_BOOKS_11I. This ties the customer class definition to a specific ledger or financial reporting entity, ensuring charge rules are applied within the correct accounting context.

While the exact names of descriptive columns (e.g., for the class name or code) are not listed in the excerpt, the table inherently stores the definitional data for each finance charge customer type.

Common Use Cases and Queries

This table is central to setup and operational reporting for federal receivables. A common administrative use case is querying all configured customer classes for a given ledger to validate setup or during a period-end close. For example:

SELECT charge_cust_id, name, charge_id
FROM fv_finance_chrg_cust_classes
WHERE set_of_books_id = :ledger_id
ORDER BY name;

From a transactional and reporting perspective, the table is typically joined to finance charge control and transaction tables to determine the applicable charge rate for an invoice based on the customer's classification. A critical reporting use case involves analyzing finance charge applicability or revenue by customer class, which requires joining this table to invoice and customer data.

Related Objects

The FV_FINANCE_CHRG_CUST_CLASSES table is a key reference point within the Federal Financials schema. As per the documented foreign keys, its two primary relationships are:

  • FV_FINANCE_CHARGE_CONTROLS_ALL: This is the parent table for charge rules. The CHARGE_ID foreign key enforces that a customer class must be associated with a valid, pre-defined finance charge control setup.
  • GL_SETS_OF_BOOKS_11I: This relationship anchors the customer class definition to a specific ledger via the SET_OF_BOOKS_ID, maintaining the integrity of multi-ledger implementations.

In practice, this table is also fundamentally related to the AR_CUSTOMERS or similar TCA (Trading Community Architecture) tables, though this relationship is likely managed through application logic or other intermediary setup tables not listed in the provided metadata.