Calculate Depreciation Job Set Performance Issue After Changing Query Timeout
Last updated on NOVEMBER 06, 2016
Applies to:Oracle Fusion Assets Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Assets - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Information in this document applies to any platform.
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)
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.
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