Performance : Payment Batch Is Taking Too Much Time To Complete Cannot Process Paysheets .

(Doc ID 2311295.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Payment Batch is taking too much time ( 5+ hours) to complete and user cannot process paysheets during normal business hours.

285217.log
Input Parameters Payrun_id = 300000003667726
Input Parameters Batch_id = 84047
Current time = 5 15-09-2017 12:10:01
Create worksheet for = 10103 salesrepID
*****Start creation of paysheet record for participant:10103
Entered the procedure cn_tp_paysheets_pvt.create_worksheet
The validations for creation of paysheet is successful for participant :10103
for the payrun :300000003667726
Calling cn_tp_participant_pay_pkg.insert_record
****Entered the procedure cn_tp_paysheets_pvt.calculate_totals****
Entering the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
Leaving the procedure cn_tp_paysheets_pvt.proc_pmt_trans_by_pe
Leaving the procedure cn_tp_paysheets_pvt.calculate_totals
updated 682504 srp_earning rows to posted status
updated 657866 srp_earning reversals rows to posted status
Leaving the procedure cn_tp_paysheets_pvt.create_worksheet
Finish time = 5 15-09-2017 17:44:51
Batch time = 334.833333333333333333333333333333333333 minutes

... It took 335 minutes ( about 6 hours ) to process 682,504 changed earning records for 1 participant.


EXPECTED BEHAVIOR
The paysheets should have been created quicker and without error.

STEPS
1. Navigator > Payments > Create Payment Batches ... when save, request_id 243345 is submitted
OR
2. Navigator > Payments > Create Payment Batches ( request_id 243345)

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