Search Results igi_dun_cust_letter_set_cur




Overview
Explore in AI Chat

Overview

The table IGI_DUN_CUST_LETTER_SET_CUR is a core data object within the IGI (Public Sector Financials International) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a child table in the dunning letter configuration hierarchy, specifically designed to manage multi-currency dunning rules. Its primary role is to allow the definition and storage of currency-specific dunning letter sets that are linked to a parent customer profile. This structure enables organizations operating in multiple currencies to tailor their dunning and collections correspondence based on the transaction currency of the overdue invoice, ensuring compliance and appropriate communication within different monetary contexts.

Key Information Stored

The table stores the fundamental link between a customer dunning profile and the currencies for which specific dunning letter sets are defined. Its structure is defined by a composite primary key, ensuring a unique currency record per profile. The critical columns are:

  • CUSTOMER_PROFILE_ID: A foreign key column that links the record to a specific customer dunning profile defined in the parent table, IGI_DUN_CUST_PROF. This identifies the customer or customer category to which these currency rules apply.
  • CURRENCY_CODE: The currency code (e.g., USD, EUR, GBP) for which a distinct set of dunning letters is configured under the parent profile. This column, together with CUSTOMER_PROFILE_ID, forms the table's primary key.

This table acts as a header, with the detailed sequence and content of dunning letters for each currency stored in the related child table, IGI_DUN_CUST_LETTER_SET_LINES.

Common Use Cases and Queries

The primary use case is the setup and maintenance of currency-aware dunning processes. Administrators use this table to define which currencies are supported for dunning correspondence for a given customer profile. A common operational query would retrieve all configured currencies for a specific profile to validate setup or during dunning batch execution. For example:

SELECT CURRENCY_CODE FROM IGI.IGI_DUN_CUST_LETTER_SET_CUR WHERE CUSTOMER_PROFILE_ID = :1 ORDER BY CURRENCY_CODE;

Another critical scenario involves troubleshooting or reporting on the dunning setup. A join to the parent profile table provides context, while a left join to the lines table can reveal profiles with a currency defined but no actual letter sequence, indicating an incomplete configuration:

SELECT prof.PROFILE_NAME, cur.CURRENCY_CODE FROM IGI.IGI_DUN_CUST_PROF prof, IGI.IGI_DUN_CUST_LETTER_SET_CUR cur WHERE prof.CUSTOMER_PROFILE_ID = cur.CUSTOMER_PROFILE_ID;

Related Objects

This table is central to a small hierarchy of dunning configuration tables within the IGI module, as evidenced by its documented foreign key relationships.

  • Parent Table (Referenced Foreign Key): The table references IGI_DUN_CUST_PROF via the column CUSTOMER_PROFILE_ID. This is the master table for customer-level dunning profiles.
  • Child Table (Referencing Foreign Key): The table is referenced by IGI_DUN_CUST_LETTER_SET_LINES. The child table uses the composite key (CUSTOMER_PROFILE_ID, CURRENCY_CODE) to link each currency header to its detailed sequence of dunning letters, defining the specific text, days overdue, and other attributes for each letter level.

This relationship chain—from IGI_DUN_CUST_PROF (profile) to IGI_DUN_CUST_LETTER_SET_CUR (currency) to IGI_DUN_CUST_LETTER_SET_LINES (letter sequence)—forms the complete data model for configuring customer-specific, multi-currency dunning correspondence in IGI.