Search Results igi_dun_cust_prof




Overview
Explore in AI Chat

Overview

The table IGI_DUN_CUST_PROF is a core data object within the Oracle E-Business Suite (EBS) module IGI - Public Sector Financials International. It functions as an extension table to the standard Trading Community Architecture (TCA) table HZ_CUSTOMER_PROFILES. Its primary role is to store module-specific attributes related to customer profiles for dunning and collections processes, which are critical for public sector financial management. By maintaining a one-to-one relationship with HZ_CUSTOMER_PROFILES, it allows the IGI module to augment standard Oracle Receivables functionality with specialized international public sector compliance and reporting requirements without modifying the base application tables.

Key Information Stored

As an extension table, IGI_DUN_CUST_PROF's structure is centered on a foreign key to the parent table. The most critical column is CUSTOMER_PROFILE_ID, which serves as the primary key and uniquely identifies each extended record by linking it to a corresponding row in HZ_CUSTOMER_PROFILES. While the provided metadata does not list additional columns, tables of this nature typically store supplementary data such as jurisdiction-specific dunning thresholds, legal notice formats, grace period rules, or regulatory flags pertinent to public sector collections. The integrity of the data is enforced by the primary key constraint IGI_DUN_CUST_PROF_PK.

Common Use Cases and Queries

This table is central to configuring and executing dunning processes for public sector entities. Common use cases include generating customer-specific dunning letters that adhere to regional legal standards and running collections reports that incorporate extended profile attributes. A fundamental query involves joining the table to the standard customer profile to retrieve the complete dataset for a customer.

  • Retrieving Extended Profile Data: SELECT hcp.*, idcp.* FROM hz_customer_profiles hcp, igi_dun_cust_prof idcp WHERE hcp.customer_profile_id = idcp.customer_profile_id AND hcp.cust_account_id = :cust_account_id;
  • Data Integrity Validation: SELECT customer_profile_id FROM hz_customer_profiles MINUS SELECT customer_profile_id FROM igi_dun_cust_prof; This identifies standard profiles missing their IGI extension.

Related Objects

IGI_DUN_CUST_PROF sits at the center of a small hierarchy of related IGI dunning objects. It has a direct foreign key relationship from the table IGI_DUN_CUST_LETTER_SET_CUR, which likely stores current dunning letter set information for a customer profile.

  • Parent Table: HZ_CUSTOMER_PROFILES (Joined via CUSTOMER_PROFILE_ID).
  • Child Table: IGI_DUN_CUST_LETTER_SET_CUR (References IGI_DUN_CUST_PROF via the foreign key column IGI_DUN_CUST_LETTER_SET_CUR.CUSTOMER_PROFILE_ID).

This relationship indicates that the extended customer profile defined in IGI_DUN_CUST_PROF is a prerequisite for defining specific dunning letter sets, forming a logical configuration path from the general customer profile to detailed dunning instructions.