Results for “ar_dunning_letter_set_lines_u1”

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

Overview

AR_DUNNING_LETTER_SET_LINES is an Oracle Receivables (AR) table that stores the individual lines belonging to a dunning letter set. In Oracle EBS, dunning letters are used to notify customers of overdue balances. A dunning letter set groups multiple dunning letters into an ordered sequence, and each row in this table represents one entry in that sequence. The table therefore acts as the child of AR_DUNNING_LETTER_SETS at the set-header level and as a reference to AR_DUNNING_LETTERS_B at the letter-definition level.

Each line defines the conditions under which a specific dunning letter is generated. These conditions include the range of overdue days, the range of dunning levels, whether currently due invoices are included, and the minimum interval since the last dunning action. Because a line links a set to a letter and captures range thresholds, the table functions as an associative relationship between two parent entities.

From a heuristic Data Vault perspective, AR_DUNNING_LETTER_SET_LINES is best classified as a link. It resolves a many-to-many-style association between dunning letter sets and dunning letters while also carrying descriptive thresholds that could be modelled as a dependent satellite. This classification is a modelling suggestion derived from the foreign key structure, not a statement of Oracle's physical design.

Key Information Stored

The most significant columns include:

• DUNNING_LETTER_SET_ID — Identifies the parent dunning letter set to which the line belongs.
• DUNNING_LINE_NUM — The sequence number of the line within the set.
• DUNNING_LETTER_ID — References the dunning letter definition in AR_DUNNING_LETTERS_B that is applied at this line.
• RANGE_OF_DAYS_FROM and RANGE_OF_DAYS_TO — The lower and upper bounds of the overdue-day range that qualifies for this line.
• RANGE_OF_DUNNING_LEVEL_FROM and RANGE_OF_DUNNING_LEVEL_TO — The dunning-level range for which this line is applicable.
• INCLUDE_CURRENT — A flag indicating whether currently due items are included.
• INVOICE_COPIES — Controls whether invoice copies accompany the letter.
• MIN_DAYS_BETWEEN_DUNNING — The minimum number of days that must elapse between dunning actions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY — Standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns for extensibility.

The surrogate primary key is AR_DUNNING_LETTER_SET_LINES_PK on (DUNNING_LETTER_SET_ID, DUNNING_LINE_NUM). A unique index, AR_DUNNING_LETTER_SET_LINES_U1, also covers (DUNNING_LETTER_SET_ID, DUNNING_LINE_NUM), reinforcing this pair as the business-key candidate. The metadata also documents AR_DUNNING_LETTER_SET_LINES_UK on (DUNNING_LETTER_SET_ID, RANGE_OF_DAYS_FROM).

Common Use Cases and Queries

Typical use cases include reporting on dunning configuration, validating that day ranges do not overlap within a set, and auditing which letter is applied at each stage. A simple query retrieves all lines for a set, ordered by sequence:

• SELECT DUNNING_LINE_NUM, DUNNING_LETTER_ID, RANGE_OF_DAYS_FROM, RANGE_OF_DAYS_TO, MIN_DAYS_BETWEEN_DUNNING FROM AR_DUNNING_LETTER_SET_LINES WHERE DUNNING_LETTER_SET_ID = :set_id ORDER BY DUNNING_LINE_NUM;

Joining to the letter definition provides the letter name, while joining to the set header provides the set name:

• SELECT s.NAME, l.DUNNING_LINE_NUM, lb.NAME, l.RANGE_OF_DAYS_FROM, l.RANGE_OF_DAYS_TO FROM AR_DUNNING_LETTER_SET_LINES l JOIN AR_DUNNING_LETTERS_B lb ON lb.DUNNING_LETTER_ID = l.DUNNING_LETTER_ID JOIN AR_DUNNING_LETTER_SETS s ON s.DUNNING_LETTER_SET_ID = l.DUNNING_LETTER_SET_ID WHERE l.DUNNING_LETTER_SET_ID = :set_id;

Reporting queries often group by set to count configured lines, or filter on MIN_DAYS_BETWEEN_DUNNING to identify aggressive collections strategies. Overlap detection between day ranges is another common validation query.

Related Objects

• AR_DUNNING_LETTER_SETS — Parent header table; joined on DUNNING_LETTER_SET_ID.
• AR_DUNNING_LETTERS_B — Letter definition; joined on DUNNING_LETTER_ID.
• AR_DUNNING_LETTERS_TL — Translated letter names and descriptions.
• AR_DUNNING_LETTER_SETS_TL — Translated set-level names and descriptions.
• AR_DUNNING_LETTER_SET_LINES participates in the Receivables dunning letter generation process, which reads these lines to determine which letter applies to each customer's overdue balance.

The documented foreign keys confirm that AR_DUNNING_LETTER_SET_LINES.DUNNING_LETTER_ID references AR_DUNNING_LETTERS_B, and DUNNING_LETTER_SET_ID references AR_DUNNING_LETTER_SETS.