Search Results dunning_letter_set_name




Overview
Explore in AI Chat

Overview

IGI_DUN_LETTER_SETS_V is an Oracle E-Business Suite 12.1.1 and 12.2.2 view owned by the APPS schema. It presents dunning letter set configuration data by joining the standard Receivables dunning letter set definition to an extension table maintained for the IGI (Public Sector / Financials) product family. The view exposes a flat, query-friendly projection that combines the business-meaningful letter set name with the configuration flags that govern how dunning correspondence is generated and charged.

Its principal role is to surface the value dunning_letter_set_name — the user-facing name of a dunning letter set — alongside Internal Controls-style attributes such as whether dunning is enabled and whether the customer is charged per invoice. This makes the view a convenient source for reports, concurrent program data extraction, and integration lookups that need the letter set name without traversing the underlying IGI configuration table directly.

Underlying Base Objects

The view is defined over two base objects, both exposed as APPS synonyms:

  • AR_DUNNING_LETTER_SETS (ARD) — the standard Receivables table holding the dunning letter set header, including the primary key dunning_letter_set_id and the descriptive name.
  • IGI_DUN_LETTER_SETS (IDLS) — the IGI extension table holding the product-specific configuration flags and standard WHO audit columns.

The join is an equi-join on dunning_letter_set_id between the two tables, so only letter sets that exist in both tables are returned. The Receivables side supplies identity and naming; the IGI side supplies the behavioral flags and audit metadata.

Key Columns

Common Use Cases and Queries

Typical scenarios include resolving a letter set name from its internal ID, validating whether dunning is enabled, and driving charging behavior in dunning reports. A representative query filtering by name:

SELECT dunning_letter_set_id,
       dunning_letter_set_name,
       use_dunning_flag,
       charge_per_invoice_flag
FROM   apps.igi_dun_letter_sets_v
WHERE  dunning_letter_set_name = :p_letter_set_name;

To list all actively used letter sets:

SELECT dunning_letter_set_id,
       dunning_letter_set_name,
       charge_per_invoice_flag
FROM   apps.igi_dun_letter_sets_v
WHERE  use_dunning_flag = 'Y'
ORDER BY dunning_letter_set_name;

Because the view performs an inner join, organizations should confirm that the corresponding IGI configuration rows exist before relying on the view for a complete inventory of letter sets; the standard AR table alone may contain entries not represented here.