Search Results igi_dun_letter_sets_v




Overview
Explore in AI Chat

Overview

The IGI_DUN_LETTER_SETS_V view is a public-sector financials construct owned by the APPS schema and validated as VALID in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the IGI product family — Public Sector Financials International — which extends standard Receivables functionality for government and public-sector customers. The view exposes configuration data for dunning letter sets, the grouped collections of correspondence that an organization issues to customers whose balances have fallen past due. Dunning itself is an Oracle Receivables process: letter sets determine which letters are sent, at which delinquency intervals, and whether a fee is assessed against delinquent invoices. In EBS reporting and integration, this view provides a consolidated, query-friendly projection of that setup data, joining the Receivables letter-set header to the IGI-specific attributes that control dunning behavior and per-invoice charging. Because it is a view rather than a table, it presents no independent storage; consumers treat it as a read-only source for configuration extracts, BI Publisher data models, and diagnostic queries that must reconcile AR and IGI collection settings.

Underlying Base Objects

The view is defined over two synonym-referenced base objects:

The two objects are joined on the shared DUNNING_LETTER_SET_ID key. The view text selects IDLS.ROWID as ROW_ID together with the joined attributes, so no row is returned unless a matching IGI extension row exists for the AR letter set. This makes the view effectively an inner-join projection: it surfaces only letter sets that have been enabled or configured within the IGI context.

Key Columns

Common Use Cases and Queries

Typical uses include auditing which letter sets are dunning-active, confirming whether invoice-level charges are enabled, and feeding downstream correspondence or analytics processes.

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

A join to dunning letter lines or to AR_DUNNING_LETTERS is common when reconstructing the full correspondence hierarchy. Because the view is a simple two-table join with no aggregation, it performs efficiently and is safe for concurrent read access in reporting environments.