My Oracle Support Banner

AR9.2: Dunning Letter Generation Incomplete If First Sequence Interval Is Not 0 (Doc ID 2878480.1)

Last updated on JUNE 28, 2022

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When changing the interval on the first reminder to 3 days after the due date, the dunning process produces unexpected results and the items are selected and the letter remains in the preview components but no letter code is assigned to it.

Replication Steps:

1. Setup new Dunning ID under navigation Setup Financials/Supply Chain -> Product Related -> Receivables -> Credit/Collections -> Dunning Methods;

First level should not start until 3 days after the invoice was due (interval =3). Can’t use grace days as grace days are applied to ALL levels and we only want to start sending dunning 3 days after the item is due, but the follow up letter should not get additional grace periods.
2. Remove hold from Customer under navigation Customers Customer -> Information -> General Information / Customer Correspondence;

3. Find overdue item that are not on a Dunning letter yet under Customer Account / Item Information / Item List;
4. Run dunning for this specific customer:
PS_DUN_CUST and PS_DUN_CUST_DTL do not have any detail for this Dunning ID
PS_AR33000_TMP does have data, but the review letter doesn’t show complete results:
No letter code is defined. But the items do exist.
5. Delete Letter from the preview letter component;
6. Change Interval to 0 for first level under navigation Setup Financials/Supply Chain -> Product Related -> Receivables -> Credit/Collections -> Dunning Methods;
6. Run dunning Dunning again for same Customer (as we deleted the incorrect letter):
Now the items are selected properly. So now the letter can be printed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.