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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

ORC Viwes giving performance issue

Summary

ORC views on questionnaures add a load to the custom built ORC BI Report

Content

Hi

We have used ORC Views on questionnaires in an ORC report which deals with questionnaires, questions, responses and answers. These worked fine in lower instances which we were developing it while in PROD instance they are causing performance issues. Oracle is now suggesting us to remove views and use tables instead. Has any one faces a similar issue in ORC. The issue also is coming up for other modules.

Regards,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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