You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to reduce execution time

in Reporting & Analytics for Fusion Service 2 comments

Hi,

I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.

First SQL statement fetches the balance from gl_balance table quickly without any issue

Second SQL statement fetches the balance from gl_je_lines ( Need Journal & category) and it takes more than 40 minutes hence report execution fails every time. so i am looking for suggestions to reduce the execution time of the report (especially the 2nd SQL statement).

I have attached a SQL query for reference.


Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!