Dunning Program Errors With: Cannot find callback date
(Doc ID 2472834.1)
Last updated on NOVEMBER 09, 2020
Oracle Advanced Collections - Version 12.1.3 and later Information in this document applies to any platform.
When running the 'IEX: Send Dunning for Delinquent Customers' program for all customers, the program creates a letter for the first customer, but fails with the following error for all other customers in the run (as seen in the log file):
Cannot find callback date Error:Cannot find the callback date
When running for > 1 customer, the first one works, all others always fail. The problem is the following as seen in the log file and the debug.
1. For the first customer in the log, it retrieves the following date: correspondence date - 14-MAR-18
For all other customers in the log, it shows: correspondence date - 18-03-14
The date format is different. The debug also shows the following for those same records:
IEX_DUNNING_PVT Send_Level_Dunning - CallbackFlag is Y: GetCallbackDate IEX_DUNNING_PVT get_callback_date - Start IEX_DUNNING_PVT get_callback_date - string=SELECT to_date(' 18-03-13','DD-MON-RR') + 1 , TO_NUMBER(TO_CHAR(to_date(' 18-03-13','DD-MON-RR') + 1 ,'D')) FROM DUAL IEX_DUNNING_PVT get_callback_date - exception IEX_DUNNING_PVT get_callback_date - errmsg=ORA-01843: not a valid month