Search Results igi_dun_cust_profile_class_v




Overview
Explore in AI Chat

Overview

The view APPS.IGI_DUN_CUST_PROFILE_CLASS_V belongs to the IGI — Public Sector Financials International product family and exposes information about dunning customer profile classes. Dunning is the process of communicating with customers to collect overdue receivables, and the profile class definition controls whether letters are generated, which dunning letter set applies, and what charge type is levied. This view consolidates those attributes into a single reporting structure suitable for Oracle E-Business Suite 12.1.1 and 12.2.2 environments.

The view is particularly relevant to inquiries that reference profile_class_description. Rather than requiring a join between the Oracle Receivables profile class table and the IGI dunning extension table, the view surfaces the description directly as the column PROFILE_CLASS_DESCRIPTION, making it convenient for lookups, LOV definitions, concurrent report sources, and integration extracts. Because it is owned by APPS and defined as a standard view, it can be queried through any tool that has access to the APPS schema, including Oracle Reports, BI Publisher, OAF pages, and SQL*Plus.

Underlying Base Objects

The view text identifies four referenced objects:

The join keys are CUSTOMER_PROFILE_CLASS_ID between ARCP and IDCP, and DUNNING_LETTER_SET_ID between ARCP and ARDL. Filter predicates restrict results to profile classes where DUNNING_LETTERS = 'Y' and DUNNING_LETTER_SET_ID IS NOT NULL. Results are ordered by profile class name. Documented metadata also lists DUAL as a referenced synonym, a common artifact in ETRM catalog entries.

Key Columns

  • CUSTOMER_PROFILE_CLASS_ID — primary key of the underlying profile class; the join column to other AR tables.
  • PROFILE_CLASS_NAME — the profile class name (ARCP.NAME).
  • PROFILE_CLASS_DESCRIPTION — the descriptive text sought by searches on profile_class_description.
  • STATUS — active/inactive status of the profile class.
  • DUNNING_LETTER_SET_ID / DUNNING_LETTER_SET_NAME — the letter set used for dunning correspondence.
  • USE_DUNNING_FLAG — indicates whether dunning is enabled for the class.
  • DUNNING_CHARGE_TYPE / DUNNING_CHARGE_TYPE_DESC — the charge type code and its decoded meaning from IGI_LOOKUPS.
  • DUNNING_LETTERS — flag confirming letter-based dunning.
  • ROW_ID and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — standard WHO columns for traceability.

Common Use Cases and Queries

The view is typically used to list dunning-enabled profile classes with their descriptions, or to resolve a profile class description for display on a form or report.

List all dunning profile classes:

SELECT profile_class_name,
       profile_class_description,
       dunning_letter_set_name,
       dunning_charge_type_desc
FROM   apps.igi_dun_cust_profile_class_v
ORDER BY profile_class_name;

Retrieve description for a specific class:

SELECT profile_class_description
FROM   apps.igi_dun_cust_profile_class_v
WHERE  customer_profile_class_id = :p_class_id;

Find active classes only:

SELECT profile_class_name, profile_class_description
FROM   apps.igi_dun_cust_profile_class_v
WHERE  status = 'A';

These queries form the basis for LOVs, dunning setup validation reports, and data extracts feeding downstream collections processing.