Error Running IEX: Create Dunning And Broken Promise Call Backs in 12.2.4 (Doc ID 2140028.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms

On : 12.2.4 version,

When attempting to run the IEX: Create Dunning And Broken Promise Call Backs program,
the following error occurs.

ERROR
-----------------------
IEX_CALLBACK: IEX: Create Dunning And Broken Promise Call Backs
+---------------------------------------------------------------------------+

Current system time is 18-MAY-2016 09:51:05

+---------------------------------------------------------------------------+

**Starts**18-MAY-2016 09:51:05
**Ends**18-MAY-2016 09:51:10
0
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Callback_Concur
Operating Unit: All
Default Resource Id = 100130078
Dunning Running Level = ACCOUNT
>>>>>Process Dunning Callbacks
current date=20160518
*****dunning_id=10321*****
Cannot create new task
Error:ORA-01789: query block has incorrect number of result columns in Package IEX_UTILITIES Procedure get_assigned_collector
*****dunning_id=10373*****


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the request.
2. It fails with the error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the program.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms