Search Results igi_dun_letter_sets_pk

Overview

The IGI_DUN_LETTER_SETS table is a core data object within the Oracle E-Business Suite (EBS) module IGI - Public Sector Financials International. It functions as an extension table, designed to store supplementary data that is directly associated with each standard dunning letter set defined in the base Oracle Receivables (AR) module. Specifically, it maintains a one-to-one relationship with the AR_DUNNING_LETTER_SETS table. Its primary role is to enable the enhanced dunning and collections functionality required by public sector and international financial regulations, which are not addressed by the standard AR features. This table is central to the custom dunning processes managed by the IGI product.

Key Information Stored

The table's structure is anchored by its primary key, which is the DUNNING_LETTER_SET_ID. This column is a foreign key that directly references the corresponding DUNNING_LETTER_SET_ID in the standard AR_DUNNING_LETTER_SETS table, ensuring a strict one-to-one correlation. While the provided ETRM metadata does not list the full column structure, the existence of this key and its relationship confirms the table's purpose. The additional columns in IGI_DUN_LETTER_SETS would typically store module-specific attributes, such as country-specific legal requirements, government reporting codes, or extended approval workflows that govern the use and application of the dunning letter set within the IGI context.

Common Use Cases and Queries

This table is primarily accessed during the configuration and execution of IGI's enhanced dunning processes. Common operational scenarios include generating regulatory compliance reports for collections activities, applying country-specific dunning rules during automatic statement generation, and validating letter set usage against public sector mandates. A fundamental query pattern involves joining this table to its base AR counterpart to retrieve a complete view of a dunning letter set's configuration.

Sample SQL Pattern:
SELECT ars.name,
ars.description,
igi.*
FROM ar_dunning_letter_sets ars,
igi_dun_letter_sets igi
WHERE ars.dunning_letter_set_id = igi.dunning_letter_set_id
AND ars.dunning_letter_set_id = :p_letter_set_id;

Related Objects

The IGI_DUN_LETTER_SETS table participates in defined key relationships within the IGI schema, as documented in the ETRM metadata.

• Primary Key: IGI_DUN_LETTER_SETS_PK on column DUNNING_LETTER_SET_ID.
• Referencing Foreign Key: The table IGI_DUN_LETTER_SET_CUR contains a foreign key constraint where its column DUNNING_LETTER_SET_ID references IGI_DUN_LETTER_SETS.DUNNING_LETTER_SET_ID. This indicates that IGI_DUN_LETTER_SETS is a parent table to IGI_DUN_LETTER_SET_CUR, which likely stores currency-specific extensions or rules for each dunning letter set.

The foundational relationship, though not a formal foreign key within the IGI schema, is its extension link to the standard Oracle Receivables table AR_DUNNING_LETTER_SETS, from which it derives its core identifier.