Search Results igi_dun_cust_prof_u1

Overview

IGI.IGI_DUN_CUST_PROF is a table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environment, owned by the IGI schema. It is an extension table that stores one row for each valid row in HZ_CUSTOMER_PROFILES, meaning it complements Oracle Receivables customer profile data with configuration specific to dunning and dunning charge processing. In practice, this table allows an organization to decide, per customer profile, whether dunning charges should be applied and, if so, whether those charges should be generated as adjustments or as invoices. The object is registered in FND Design Data as IGI.IGI_DUN_CUST_PROF and resides in the APPS_TS_TX_DATA tablespace.

From a data modeling perspective, the table is heuristic classified as hub-leaning. Using Data Vault terminology as a modeling suggestion, IGI_DUN_CUST_PROF behaves like a hub: it holds a stable, unique business concept (the customer profile) and its identity key, with minimal descriptive attributes. The documented primary key is IGI_DUN_CUST_PROF_PK on CUSTOMER_PROFILE_ID, reinforcing the hub interpretation.

Key Information Stored

The table contains eight documented columns. The most important are:

• CUSTOMER_PROFILE_ID (NUMBER(15), mandatory): Identifier of the customer profile. This is the surrogate primary key of the table and the join point back to HZ_CUSTOMER_PROFILES.
• USE_DUNNING_FLAG (VARCHAR2): Controls whether dunning charges should be applied for the customer profile.
• DUNNING_CHARGE_TYPE (VARCHAR2): Determines the type of dunning charge to create. A value of Adjustment (A) creates adjustments in Receivables, while Invoice (I) invokes AutoInvoice to create an invoice detailing the charges.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: Standard "Who" columns recording the user who created the row, the creation date, the user who last updated it, the update date, and the operating system login of the last updater.

The unique index IGI_DUN_CUST_PROF_U1 on CUSTOMER_PROFILE_ID is documented as the business-key candidate for this object, and it enforces the one-row-per-profile rule that gives the table its extension-table character.

Common Use Cases and Queries

The primary use case is dunning configuration reporting. Because the table stores a flag and a charge type per customer profile, it is commonly queried to determine which profiles are subject to dunning charges and how those charges will be posted. A typical query pattern is:

SELECT p.CUSTOMER_PROFILE_ID, p.USE_DUNNING_FLAG, p.DUNNING_CHARGE_TYPE FROM IGI.IGI_DUN_CUST_PROF p WHERE p.USE_DUNNING_FLAG = 'Y';

Analysts also use the table in account-level reporting by joining CUSTOMER_PROFILE_ID to HZ_CUSTOMER_PROFILES to view the profile name and status alongside the dunning settings. The DUNNING_CHARGE_TYPE column is of particular interest to Receivables administrators and financial reporting teams, since Adjustment versus Invoice determines whether the resulting entries flow through adjustments or through AutoInvoice. The standard Who columns support audit queries that trace configuration changes by user and date.

Related Objects

The most significant objects related to IGI_DUN_CUST_PROF, based on the documented dependencies, include:

• HZ_CUSTOMER_PROFILES: The parent application table; IGI_DUN_CUST_PROF stores one extended row for each valid row in HZ_CUSTOMER_PROFILES, joined on the customer profile identifier.
• IGI_DUN_CUST_LETTER_SET_CUR: Contains a foreign key CUSTOMER_PROFILE_ID referencing IGI_DUN_CUST_PROF. This child table links the customer profile to dunning letter set currency configuration.
• IGI_DUN_CUST_PROF_PK: The primary key constraint on CUSTOMER_PROFILE_ID.
• IGI_DUN_CUST_PROF_U1: The unique index on CUSTOMER_PROFILE_ID, which is the unique search path used when looking up records by the user search term "igi_dun_cust_prof_u1".

No database objects are referenced by IGI_DUN_CUST_PROF itself in the documented metadata; its dependencies flow outward to the Receivables and IGI dunning tables that consume its configuration.