Search Results ar_customer_profile_class

Overview

The IGI_DUN_CUST_PROF_CLASS table is a core data object within the Oracle E-Business Suite module IGI - Public Sector Financials International. It functions as an extension table, storing one record for each corresponding record in the standard Oracle Receivables (AR) table AR_CUSTOMER_PROFILE_CLASS. Its primary role is to support the dunning and charge management functionality specific to public sector and international financial requirements, enabling organizations to define and manage customer-specific collection rules and policies that extend beyond the base application's capabilities.

Key Information Stored

The table's central purpose is to link a standard customer profile class to extended dunning configurations. Its primary key, CUSTOMER_PROFILE_CLASS_ID, is a foreign key referencing AR_CUSTOMER_PROFILE_CLASS.CUSTOMER_PROFILE_CLASS_ID. This establishes a one-to-one relationship with the base Oracle Receivables table. While the provided metadata does not list additional columns, the table's description and relationships indicate it serves as a parent entity for storing supplementary attributes related to dunning charges and policies. These extended attributes are likely referenced by related tables like IGI_DUN_CHARGE_ALL to determine applicable fees or actions for a given customer profile class.

Common Use Cases and Queries

This table is pivotal in scenarios involving the assessment of late payment charges or the execution of customized dunning processes for different classes of customers. A common use case is querying to identify all extended dunning profiles or joining with related tables to generate reports on configured charge rules per customer class. A typical SQL pattern involves joining this table with its parent to fetch extended details:

• SELECT ar_cpc.name, igi_dcpc.* FROM ar_customer_profile_class ar_cpc, igi_dun_cust_prof_class igi_dcpc WHERE ar_cpc.customer_profile_class_id = igi_dcpc.customer_profile_class_id;

Another critical query joins this table with its child table to analyze all charge assignments linked to a specific customer profile class, which is essential for auditing and validating dunning rule setups.

Related Objects

The IGI_DUN_CUST_PROF_CLASS table sits at the center of a key relationship hierarchy within the IGI dunning module. Its primary relationship is as a child to the standard Oracle Receivables table AR_CUSTOMER_PROFILE_CLASS, from which it derives its foundational identifier. As documented, it acts as a parent table to the IGI_DUN_CHARGE_ALL table via a foreign key relationship. Specifically, the column IGI_DUN_CHARGE_ALL.CUSTOMER_PROFILE_CLASS_ID references IGI_DUN_CUST_PROF_CLASS.CUSTOMER_PROFILE_CLASS_ID. This relationship indicates that the extended profile class record is used to govern and group specific dunning charge rules defined in the IGI_DUN_CHARGE_ALL table.