Search Results fv_finance_chrg_cust_classes




Overview
Explore in AI Chat

Overview

FV_FINANCE_CHRG_CUST_CLASSES is a Federal Financials (FV) application table that stores the finance charge customer type definitions used to determine how finance charges (interest on overdue receivables) are assessed against customer classifications. Each row associates a customer class with a finance charge control record and a set of books, allowing the Receivables-based Federal Financials finance charge engine to apply different charge rules, rates, and grace periods to distinct categories of federal customers.

In Oracle E-Business Suite 12.1.1 and 12.2.2, the table resides in the FV schema and is part of the configuration layer for the Federal Financials finance charge feature. It is populated through the finance charge setup forms and is referenced at transaction processing time when a finance charge is calculated on a delinquent customer account. The ETRM metadata classifies this object heuristically as a link table. Following a Data Vault modeling convention, it would best be modeled as a link entity that resolves the many-to-many relationship between finance charge controls and customer classes within a specific ledger context, rather than as a hub (which would hold only the unique CHARGE_CUST_ID business key) or a satellite.

Key Information Stored

The table contains 29 documented columns. The most operationally significant are:

The unique index FV_FIN_CHRG_CUST_CLASSES_U1 on (CHARGE_ID, CUSTOMER_CLASS, FINANCE_CHARGE_GROUP_HDR_ID) represents the documented business-key candidate, distinct from the surrogate CHARGE_CUST_ID primary key.

Common Use Cases and Queries

Typical uses include auditing finance charge setup by customer classification, troubleshooting why a particular customer was or was not charged, and reporting active charge rules by ledger. A representative query joining to the charge control parent is:

  • SELECT fcc.charge_cust_id, fcc.customer_class, fcc.enabled_flag, fca.charge_name FROM fv.fv_finance_chrg_cust_classes fcc, fv.fv_finance_charge_controls_all fca WHERE fcc.charge_id = fca.charge_id AND fcc.set_of_books_id = :ledger_id;
  • Filtering on CHARGE_CUST_ID = :charge_cust_id to retrieve a single classification record.
  • Restricting by SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE) to return only currently effective rules.
  • Joining to GL_SETS_OF_BOOKS_11I to resolve ledger names for cross-ledger configuration reporting.

Related Objects

  • FV_FINANCE_CHARGE_CONTROLS_ALL — Parent table; joined via CHARGE_ID. Holds the finance charge control definitions.
  • GL_SETS_OF_BOOKS_11I — Ledger reference; joined via SET_OF_BOOKS_ID.
  • FV_FINANCE_CHARGE_CONTROLS_ALL child reference chain — used to trace the DFF and rate configuration consumed at charge calculation time.
  • AR_CUSTOMERS / AR_CUSTOMER_PROFILES — Provide the CUSTOMER_CLASS values resolved against this table during receivables processing.
  • FV_FINANCE_CHRG_CUST_CLASS_PK and FV_FIN_CHRG_CUST_CLASSES_U1 — Primary key constraint and unique business-key index enforcing integrity.