Concurrent Batch For Calculation Failed - ORA-01403: No Data Found (Doc ID 1092710.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 to 12 [Release 11.5 to 12.0]
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***

Goal

The Concurrent Batch For Calculation is failing with the following error:

BATCH_PROCESSOR module: Transaction Batch Processor
...
100 ORA-01403: no data found
...
Conc_dispatch2: Request completed with error for 296197
Conc_dispatch2: Request failed for physical_batch11360
conc_fail exception in cn_proc_batches_pkg.conc_dispatch

From Log file:

+---------------------------------------------------------------------------+
Incentive Compensation: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

BATCH_PROCESSOR module: Transaction Batch Processor
+---------------------------------------------------------------------------+

Current system time is 30-APR-2010 23:37:07

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

**Starts**30-APR-2010 23:37:07
**Ends**30-APR-2010 23:47:08
100 ORA-01403: no data found
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Conc_dispatch2: Request completed with error for 296197
Conc_dispatch2: Request failed for physical_batch11360
conc_fail exception in cn_proc_batches_pkg.conc_dispatch
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Finished executing request completion options.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Transaction Batch Processor" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 30-APR-2010 23:47:08

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


This can be reproduced by running a Calculation Batch with All Resources as the parameter.

For 11.5.10.2
(R) Incentive Compensation Super User
(N) Transactions
Calculation
Select All Resources and Concurrent request
Submit

For Release 12
(R) Compensation Manager
(N) Calculate Compensation
Schedule Batch
Select All resources as an option
Submit

Solution

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