Search Results igi_dun_cust_prof




Overview
Explore in AI Chat

Overview

IGI_DUN_CUST_PROF is a table in the IGI schema, belonging to the IGI — Public Sector Financials International product family within Oracle E-Business Suite (validated for 12.1.1 and 12.2.2). It is an extension table that stores one row for each row in HZ_CUSTOMER_PROFILES, adding dunning-specific configuration attributes that the standard Trading Community Architecture (TCA) customer profile model does not carry. In practice, it acts as the IGI-owned side-car to the TCA customer profile, allowing dunning (delinquency letter) behavior to be defined per customer profile without modifying the base HZ table.

From a Data Vault modeling perspective, the metadata's heuristic classification is hub-leaning. The table is keyed on a single identifier and is referenced by dependent tables, which is characteristic of a hub entity holding a stable business key. Analysts designing a warehouse layer over IGI dunning data should treat CUSTOMER_PROFILE_ID as a candidate hub key, with the remaining descriptive columns (USE_DUNNING_FLAG, DUNNING_CHARGE_TYPE) modeled as satellite attributes.

Key Information Stored

The documented physical schema contains eight columns. The most significant are:

  • CUSTOMER_PROFILE_ID — The surrogate primary key defined by IGI_DUN_CUST_PROF_PK. It is also enforced by the unique index IGI_DUN_CUST_PROF_U1, making it the sole documented business-key candidate. The value corresponds to the customer profile record in HZ_CUSTOMER_PROFILES, giving the table its one-to-one relationship with TCA.
  • USE_DUNNING_FLAG — Indicates whether dunning processing is enabled for the referenced customer profile. This is the principal functional switch consulted by dunning letter generation.
  • DUNNING_CHARGE_TYPE — Classifies the charge type applied in dunning processing for the profile, allowing interest or penalty charges associated with delinquency letters to be categorized.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification user, timestamp, and login context.

The audit columns follow the conventional EBS WHO column pattern and are populated by the application tier rather than by user entry.

Common Use Cases and Queries

Typical scenarios include identifying which customer profiles have dunning enabled, reporting on charge types applied to delinquent customers, and driving letter-set selection for public sector receivables. A simple existence query against the primary key is common in integration code:

  • List profiles with dunning enabled: SELECT customer_profile_id, dunning_charge_type FROM igi.igi_dun_cust_prof WHERE use_dunning_flag = 'Y';
  • Join to TCA to enrich profile detail: SELECT p.customer_profile_id, h.profile_class, p.use_dunning_flag FROM igi.igi_dun_cust_prof p, hz.hz_customer_profiles h WHERE p.customer_profile_id = h.customer_profile_id;
  • Audit recent maintenance: filter on LAST_UPDATE_DATE to find profiles changed within a period, useful for reconciliation of dunning configuration changes.

Because the table is one row per HZ customer profile, it can be safely outer-joined to TCA extracts without row multiplication.

Related Objects

  • HZ_CUSTOMER_PROFILES — The parent TCA table. The IGI table stores one extension row per row in HZ_CUSTOMER_PROFILES, joined on CUSTOMER_PROFILE_ID.
  • IGI_DUN_CUST_LETTER_SET_CUR — References IGI_DUN_CUST_PROF through the foreign key column CUSTOMER_PROFILE_ID. This child table carries currency-specific letter set configuration, so a single profile may have multiple letter-set rows.
  • IGI_DUN_CUST_PROF_PK / IGI_DUN_CUST_PROF_U1 — The primary key constraint and unique index on CUSTOMER_PROFILE_ID, enforcing the one-to-one relationship with TCA.
  • HZ_CUST_ACCOUNTS and related TCA entities — Reached indirectly through the customer profile hierarchy for reporting on account-level dunning behavior.

Developers extending dunning functionality should treat IGI_DUN_CUST_PROF as the authoritative source for profile-level dunning flags and charge types, and resolve letter-set detail through IGI_DUN_CUST_LETTER_SET_CUR.