Search Results fv_fin_chrg_cust_classes_u1

Overview

FV.FV_FINANCE_CHRG_CUST_CLASSES is a transactional configuration table in the Oracle E-Business Suite Receivables (FV) schema that stores the customer class assignments used to drive finance charge assessment. Each row associates a finance charge definition, held on FV_FINANCE_CHARGE_CONTROLS_ALL, with a specific customer class, thereby determining which customers are subject to a given late-payment interest calculation, rate, and grace period. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, is owned by the FV schema, and carries FND Design Data registration FV.FV_FINANCE_CHRG_CUST_CLASSES.

Heuristic Data Vault classification mined from the foreign key structure identifies this object as a link table. This is a modeling suggestion: the table resolves a many-to-many relationship between finance charges and customer classes rather than acting as a standalone hub of business entities or a satellite of descriptive attributes. The presence of effective-dating columns (START_DATE, END_DATE) and an ENABLED_FLAG further suggests a time-variant association history, which is typical of link-style structures carrying relationship validity.

Key Information Stored

The mandatory surrogate primary key is CHARGE_CUST_ID (NUMBER(15)), which uniquely identifies each finance charge customer row. The documented unique index FV_FIN_CHRG_CUST_CLASSES_U1 serves as the business-key candidate over (CHARGE_ID, CUSTOMER_CLASS, FINANCE_CHARGE_GROUP_HDR_ID); the ETRM excerpt for the same index lists CHARGE_ID and CUSTOMER_CLASS, reflecting the constraint as shipped and later extended with FINANCE_CHARGE_GROUP_HDR_ID in the 12.2.2 physical schema.

• CHARGE_ID — foreign key to FV_FINANCE_CHARGE_CONTROLS_ALL; identifies the parent finance charge configuration.
• CUSTOMER_CLASS — VARCHAR2(25); the customer class code to which the charge applies.
• FINANCE_CHARGE_GROUP_HDR_ID — identifier of the finance charge group header used for grouped charge processing.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I; the ledger context for the assignment.
• START_DATE / END_DATE — effective dating that governs when the customer class assignment is active.
• ENABLED_FLAG — Y/N flag controlling whether the row is currently in force.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns providing audit lineage.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments for customer-specific extensions.

Common Use Cases and Queries

The primary reporting need is to determine which customer classes are assessed a given finance charge and over what effective window. A representative query joins the assignment to its parent charge definition:

• SELECT c.charge_id, c.customer_class, c.start_date, c.end_date, c.enabled_flag FROM fv_finance_chrg_cust_classes c WHERE c.charge_id = :charge_id AND SYSDATE BETWEEN NVL(c.start_date, SYSDATE) AND NVL(c.end_date, SYSDATE + 1);
• Ledger-scoped reporting: filter by SET_OF_BOOKS_ID to reconcile finance charge coverage per set of books.
• Effective-dating audits: identify rows where END_DATE has passed but ENABLED_FLAG remains Y, indicating stale configuration.
• Duplicate detection: group by CHARGE_ID, CUSTOMER_CLASS, FINANCE_CHARGE_GROUP_HDR_ID to validate the unique business key before data migration.
• Descriptive flexfield extraction: query ATTRIBUTE_CATEGORY with ATTRIBUTE1–ATTRIBUTE15 for client-specific classifications.

Related Objects

• FV.FV_FINANCE_CHARGE_CONTROLS_ALL — parent table; joined on CHARGE_ID = FV_FINANCE_CHRG_CUST_CLASSES.CHARGE_ID.
• GL.GL_SETS_OF_BOOKS_11I — ledger definition; joined on SET_OF_BOOKS_ID.
• FND_USER — referenced by LAST_UPDATED_BY and CREATED_BY.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.
• AR_CUSTOMER_PROFILES / customer class definitions — supply the CUSTOMER_CLASS values validated by this table.