Results for “dunning_letter_set_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_DUN_LETTER_SETS is an extension table owned by the IGI schema (Public Sector Financials International) in Oracle EBS 12.1.1 and 12.2.2. It stores one record for each corresponding record in the Oracle Receivables base table AR_DUNNING_LETTER_SETS. In other words, it mirrors the set of dunning letter configurations defined in AR, adding IGI-specific attributes for public sector/IGI customers. Dunning letter sets group dunning letters and define the sequence and behavior used during the collections and dunning process, so this table participates directly in the dunning and collections configuration workflow.

The table's structure carries the surrogate identifier DUNNING_LETTER_SET_ID as its primary key (constraint IGI_DUN_LETTER_SETS_PK), and additionally holds a unique index IGI_DUN_LETTER_SETS_U1 on the same DUNNING_LETTER_SET_ID column. The unique index therefore exposes DUNNING_LETTER_SET_ID as the primary business-key candidate; because the table also mirrors AR, the same identifier ties each IGI row back to the AR base row. Eight columns are documented.

Based on the foreign-key structure, the metadata suggests a hub-leaning Data Vault modeling classification: IGI_DUN_LETTER_SETS behaves like a hub surrounded by the dependent table IGI_DUN_LETTER_SET_CUR, which references it via DUNNING_LETTER_SET_ID. This is a modeling suggestion, not a physical enforcement requirement.

Key Information Stored

The documented columns are:

• DUNNING_LETTER_SET_ID — surrogate primary key and unique business-key candidate; the identifier shared with AR_DUNNING_LETTER_SETS.
• USE_DUNNING_FLAG — indicates whether dunning is enabled/used for the letter set.
• CHARGE_PER_INVOICE_FLAG — controls whether a charge is assessed per invoice when dunning letters are produced.
• CREATED_BY, CREATION_DATE — audit columns capturing the creating user and creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns capturing the last modifying user, timestamp, and login session.

These fields provide the IGI-specific configuration and standard EBS audit trail needed for the dunning letter set extension.

Common Use Cases and Queries

Typical reporting scenarios involve resolving IGI-specific dunning behavior against the AR base configuration:

• Listing all dunning letter sets and whether dunning is active: SELECT DUNNING_LETTER_SET_ID, USE_DUNNING_FLAG, CHARGE_PER_INVOICE_FLAG FROM IGI.IGI_DUN_LETTER_SETS;
• Joining the IGI extension to the AR base table: SELECT a.DUNNING_LETTER_SET_ID, a.NAME, i.USE_DUNNING_FLAG FROM AR.AR_DUNNING_LETTER_SETS a, IGI.IGI_DUN_LETTER_SETS i WHERE a.DUNNING_LETTER_SET_ID = i.DUNNING_LETTER_SET_ID;
• Auditing recent configuration changes: query on LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Cross-referencing the dependent currency/rate table: SELECT c.DUNNING_LETTER_SET_ID FROM IGI.IGI_DUN_LETTER_SET_CUR c JOIN IGI.IGI_DUN_LETTER_SETS s ON c.DUNNING_LETTER_SET_ID = s.DUNNING_LETTER_SET_ID;

Related Objects

• AR_DUNNING_LETTER_SETS — the Receivables base table this object extends, joined on DUNNING_LETTER_SET_ID.
• IGI_DUN_LETTER_SET_CUR — dependent table referencing IGI_DUN_LETTER_SETS via DUNNING_LETTER_SET_ID (foreign key documented).
• IGI_DUN_LETTER_SETS_PK — primary-key constraint on DUNNING_LETTER_SET_ID.
• IGI_DUN_LETTER_SETS_U1 — unique index on DUNNING_LETTER_SET_ID.
• Related AR dunning objects — the dunning letters, dunning letter sets, and collections configuration entities that consume the same DUNNING_LETTER_SET_ID key, referenced through the Receivables dunning subsystem.