My Oracle Support Banner

IEX: Send Dunnings for Delinquent Customers Fails with Unexpected Exception (Doc ID 1547152.1)

Last updated on NOVEMBER 27, 2018

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.


The IEX: Send Dunnings for Delinquent Customers program is failing in the log file with the following:

p_correspondence_date :17-APR-13
p_running_level : BILL_TO
p_org_id : 8
l_billto_tot_acctd_amt_rem : 382923.87
l_billto_cm_tot_acctd_amt_rem : 0
l_billto_total_acctd_amount : 382923.87
unexpect exception

The FND debug shows the following error:

IEX_UTILITIES IEX_UTILITIES.StagedDunningMinAmountCheck - l_stage :98
IEX_DUNNING_PVT Send_Level_Staged_Dunning - Other Exception
IEX_DUNNING_PVT Send_Level_Staged_Dunning - error=ORA-06502: PL/SQL: numeric or value error
IEX_DUNNING_PUB Send_Dunning - send_level_Failed - CONTINUE
IEX_DUNNING_PUB Send_Dunning - fetched 91642

Steps to Reproduce:
: Collections Agent
: Collections Adminstrator > Submit Request
Submit IEX: Send Dunnings for Delinquent Customers program


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

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