My Oracle Support Banner

How To Detect Number of Incremental Recalculated Transaction For Some Specific Events (Doc ID 820015.1)

Last updated on APRIL 04, 2021

Applies to:

Oracle Incentive Compensation - Version 12.0.3 and later
Information in this document applies to any platform.


Q1: Using the OIC incremental calculation to avoid big re-calculation for each setup he is doing.

For example :
had a new rate table in a quota and put an end date for the previous rate table associated with
the quota instead of changing rate in the rate table associated with the quota.

A calculation is running every night, and take too much time.

When it's time to pay, the quantity of payment transactions in the 'CN_PAYMENT_TRANSACTIONS_ALL'
tables is bigger then expected.
A first analyse show that 90% of these payment transaction are a reversal(posting_batch_id = -1,
amount = -X) and a new one (amount = +X)

There is a lot of re-calculation wich are useless and not expected at all

### Impact on Business ###
the amount of recalculation is impacted :
- the request run duration of calculation run : 19 hours instead of maximum 6 hours expected
- unexpected increase of the database (payment transaction)
- request run duration of payment which have too many payment transactions to deal with.

### Area of the Application ###

Need some scripts to detect for some frequent events (due to some specific setup) the number of transactions and transaction lines. 

It seams that the main and most frequent cause of re-calculation is linked with event 'CHANGE_QUOTA_ROLL', 'CHANGE_CP_HIER' ....

- CHANGE_QUOTA_ROLL (Change plan element revenue class)
- CHANGE_CP_HIER (Change compensation group hierarchy)

1- Could you explains what transactions are re-calculated when this event appear.
About the requests given previously, and don't know if it is the only one request used to find transaction to re-calculate. (The request search salesreps and not transaction)

2- Is there any workaround to avoid having to add eligible product to Plan Element.


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

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