My Oracle Support Banner

23C Assets Seeded Reports Error Out and Log File Shows Nothing: Asset Cost Summary Report, Asset Reserve Summary Report And Correspondent Detail Reports (Doc ID 2973893.1)

Last updated on MAY 28, 2024

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.23.07.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.23.07.0 version, Technology Management - Reports/Analytics
Few Assets Seeded Reports are getting error out, log file shows nothing. Below are the list of seeded reports:

Asset Cost Summary Report and Asset Cost Detail Report
Asset Reserve Summary Report and Asset Reserve Detail Report



ERROR
-----------------------

Query timeouts -- the one job pointed to shows ::SQL query time exc eeds the limit (10800 sec)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ESS Scheduled Processes: Attempt to run either Asset Cost Summary Report or Reserve Summary Report (/Financials/Fixed Assets/Asset Balances/CostSummary.xdo)
2. Times out after 10800 seconds or a different amount of time


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
References


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