Performance Issue With OIC Calculation on ON FND_CONCURRENT_REQUESTS
(Doc ID 1080362.1)
Last updated on AUGUST 06, 2020
Applies to:
Oracle Incentive Compensation - Version 12.0.0 to 12.0.5 [Release 12.0]Information in this document applies to any platform.
Symptoms
The Calculation process is taking more than 1 hour and 20 minutes to run 2000 transactions.
The profile OIC: Frequency of Batch Runners Status Check is set at correct value - passed it from 15 to 60 seconds
The tkprof'd trace file shows the explain plan with PL/SQL Lock Timer events
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
library cache lock 1 0.00 0.00
row cache lock 12 0.00 0.00
library cache pin 14 0.00 0.00
PL/SQL lock timer 315 180.01 32761.70
**********************************************************
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
library cache lock 1 0.00 0.00
row cache lock 12 0.00 0.00
library cache pin 14 0.00 0.00
PL/SQL lock timer 315 180.01 32761.70
**********************************************************
The issue can be reproduced at will with the following steps:
(R) Compensation Manager
(N) Calculate Compensation
The select statement that is causing the problem is:
Cause
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
| Symptoms |
| Cause |
| Solution |
| Community Discussions |
| References |