Calculate Depreciation Job Set Performance Issue After Changing Query Timeout

(Doc ID 2196710.1)

Last updated on NOVEMBER 06, 2016

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.9.2.0 to 11.1.10.0.0 [Release 1.0]
Oracle Fusion Assets - Version 11.1.9.2.0 to 11.1.10.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Calculate Depreciation Job Set has performance issues and runs for a very long time after making a change to the Query Timeout on the Journal Entry Reserve Ledger Report from solution:
Calculate Depreciation Job Set Runs for a Long Time and Ends in Error (Doc ID 2171882.1)

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Navigate to Fixed Assets > Financial Transactions > Calculate Depreciation
2. Select Asset Book and period for both Calculate Job and Journal Entry Reserve Ledger Report
3. The Depreciation Calculation completes but the Journal Entry Reserve Ledger Report (JERL) runs for a very long time.


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