My Oracle Support Banner

Why Is The Volume of Data In CN_TP_PARTICIPANT_PAY_ALL Very High And Is Taking A Long Time To Refresh ? (Doc ID 2625742.1)

Last updated on JANUARY 13, 2020

Applies to:

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

Symptoms

Create Payment Batch is taking a long time.

Preliminary finding on this is that this payment batch 'PAY-OCT-19' ( request_id 477263 ) processed 108 participants.
Within those 108 participants is one participant which accounts for the long running process.
He had 1,413,084 payment transactions ( including reversals) in CN_TP_PARTICIPANT_PAY_ALL table that were picked up during this payment batch.
He had earnings that were recalculated from prior 5 months that had been paid - picked up by this payment batch. 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.