IEX: Send Dunnings for Delinquent Customers Fails with Error in Log - Template: '' is Inactive (Doc ID 1567144.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

Attempting to run the IEX_SEND_DUNNING module: IEX: Send Dunnings for Delinquent Customers program and receive the following error:

SEND_DUNNING_CONCUR dunning_plan_id = 10001
CORRESPONDENCE DATE : 2013/06/21 00:00:00
PARENT REQUEST ID :
DUNNING MODE : FINAL
SINGLE STAGED LETTER : N
PROCESS ERRORED RECORD ONLY :
.......
l_cust_account_id : 3045
l_acct_tot_acctd_amt_rem : 8889625,07
l_acct_cm_tot_acctd_amt_rem : -286789,14
l_acct_total_acctd_amount : 8602835,93
****** Stage Dunning Plan 10001 has no dunning stages defined *****
l_party_cust_id = 11054
l_account_id = 3045
l_customer_site_use_id = 1425
l_delinquency_id =
inside if condn
After close dunning
Template: '' is inactive
expect exception

**************
* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *
**************

FND Debug shows the following:

IEX_DUNNING_PVT Send_Level_Staged_Dunning - Get CallbackDate
IEX_DUNNING_PVT Send_Level_Staged_Dunning - CallbackFlag=N
IEX_DUNNING_PVT Send_Level_Staged_Dunning - CallbackDays=
IEX_DUNNING_PVT Send_Level_Staged_Dunning - CallbackFlag is N: NOTGetCallbackDate
IEX_DUNNING_PVT Send_Level_Staged_Dunning - l_invoice_copies: l_invoice_copies
IEX_DUNNING_PVT Send_Level_Staged_Dunning Template ID for Invoice :
IEX_DUNNING_PVT Send_Level_Staged_Dunning - GET Invoice Template status
IEX_DUNNING_PVT Send_Level_Staged_Dunning - Template: '' is inactive
sid:27370032: Template: '' is inactive
IEX_DUNNING_PVT Send_Level_Staged_Dunning - Exc Exception
sid:27370032: expect exception
IEX_DUNNING_PVT Send_Level_Staged_Dunning - error=User-Defined Exception
IEX_DUNNING_PUB Send_Dunning - send_level_Failed - CONTINUE

Changes

Cause

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