Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher Reports pulling blank and/or timeout errors with no modifications done

Received Response
12
Views
1
Comments

Wondering if anyone has run in to similar situations. We have custom SQL/BI Publisher Reports that are encountering unexplained issues. For example reports that have been in place for an extended period of time are now randomly pulling blank data or experiencing time out issues for users. In most cases there have been no modifications done to the data model or report themselves. We have seen some instances where clearing cache/cookies will resolve but in others we are seeing where data models have to be completely recreated to allow for functionality. Also, with timeouts the exact same data models with the only difference being the use of this NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) in place of a static value. Has anyone encountered similar issues? Any recommendations for solutions?

Answers