GL Account Analysis report Tunning — Cloud Customer Connect
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

GL Account Analysis report Tunning

Summary:

In ERP we have GL Account Analysis Report used by our Thailand and Malysia country client, But Malysia team reported performance issue for RESA and RETEK source as the report was taking 5hrs and failing in few cases. We have tried to tune the report and found that NVL in period_name parameter is causing issue, if we remove that the report is completing in less time but that makes period name parameter mandatory. Help us to resolve the issue.

this is the condition we have in the report h.period_name = NVL(:p_period, h.period_name)

I tried to change it to h.period_name = :p_period

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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