Search Results dunning_line_num




Overview
Explore in AI Chat

Overview

The table IGI_DUN_CUST_LETTER_SET_LINES is a core data object within the IGI (Public Sector Financials International) product of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It plays a critical role in the dunning process, which is the systematic procedure of communicating with customers to collect overdue payments. Specifically, this table stores the multi-currency thresholds and parameters for individual dunning letters that are part of a defined sequence, known as a dunning letter set. It enables organizations operating across different currencies to define currency-specific aging and amount criteria for each escalation step in the dunning workflow, ensuring the process is tailored to the customer's transaction currency.

Key Information Stored

The table's structure is designed to uniquely identify and configure a dunning line for a specific customer profile, letter set, and currency. Its primary key is a composite of four columns, reflecting this granularity. Important columns include:

  • CUSTOMER_PROFILE_ID: Links to the customer's credit profile, defining the specific business rules applied.
  • DUNNING_LETTER_SET_ID: Identifies the parent dunning letter set to which this line belongs.
  • DUNNING_LINE_NUM: Indicates the sequential order of this letter within the set (e.g., first reminder, second reminder, final notice).
  • CURRENCY_CODE: The currency for which the thresholds on this line are applicable (e.g., USD, EUR, GBP).

Additional columns, implied by the table's purpose, would typically store values like the minimum days overdue, the minimum overdue amount in the specified currency, and the identifier for the corresponding dunning letter template to be used.

Common Use Cases and Queries

This table is primarily accessed during the execution of the dunning process to determine which letter, if any, should be generated for a customer's overdue invoices in a given currency. A common reporting use case is to audit or review the configured dunning rules. A sample query to list all currency-specific lines for a customer profile would be:

SELECT DUNNING_LETTER_SET_ID, DUNNING_LINE_NUM, CURRENCY_CODE FROM IGI.IGI_DUN_CUST_LETTER_SET_LINES WHERE CUSTOMER_PROFILE_ID = :profile_id ORDER BY DUNNING_LETTER_SET_ID, DUNNING_LINE_NUM;

For technical support or data fixes, one might need to identify lines missing corresponding currency definitions or join to the letter template table to validate configuration integrity before running the dunning program.

Related Objects

IGI_DUN_CUST_LETTER_SET_LINES is part of a key relationship hierarchy within the IGI dunning module. Based on the provided metadata, the documented foreign key relationship is:

  • Foreign Key Reference: The columns CUSTOMER_PROFILE_ID and CURRENCY_CODE in IGI_DUN_CUST_LETTER_SET_LINES reference the table IGI_DUN_CUST_LETTER_SET_CUR. This parent table likely holds the header-level, currency-specific enablement for a dunning letter set, to which these detailed line configurations belong.

Logically, this table also has a fundamental relationship with the core dunning letter set definition table (likely named similarly to IGI_DUN_CUST_LETTER_SETS) via DUNNING_LETTER_SET_ID and CUSTOMER_PROFILE_ID, and with the standard Oracle Receivables customer profile (HZ_CUSTOMER_PROFILES) via CUSTOMER_PROFILE_ID, though these are not explicitly listed in the provided excerpt.