Crediting Process Stuck. The Child Jobs All Completed. The Parent Job Is Still Running For Over 10+ Hours.

(Doc ID 2403201.1)

Last updated on MAY 24, 2018

Applies to:

Oracle Sales Performance Management Cloud Service - Version 11.13.18.02.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.02.0 and later
Oracle Fusion Incentive Compensation - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

User ran crediting for the first time yesterday for a quarter.  All the child processes finished within minutes but the parent process kept running for hours until it was canceled.
User then tried running it for 1 month. The same thing is happening.  All the child processes got completed and the parent is running.
There are only 148,387 transactions for the quarter.



ACTUAL BEHAVIOR
Crediting process running for 13+ hours.


EXPECTED BEHAVIOR
With the low volume of transaction, expected crediting to finish less than an hour.


STEPS
1. Import Transactions
2. Run Crediting ( first time submitting , request_id 28054 for date range 1/1/18 - 5/30/18, ALL ) - user cancelled after 3:22 hours
3. Run Crediting ( request_id 28143 for date range 1/1/18 - 3/31/18, ALL ) - user cancelled after 4:12 hours
4. Run Crediting ( request_id 28172 for date range 1/1/18 - 3/31/18, ALL ) - user cancelled after 13:40 hours
5. Run Crediting ( request_id 28210 for date range 1/1/18 - 1/31/18, ALL ) - user cancelled after 4:28 hours


Changes

User created multiple Direct Credit Rules using webservice.

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