Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Errors while Creating Summary

DiscoUserSep 20 2006 — edited May 25 2009

While creating Summary on some of the folders based on custom views using ASM or mannually, I am getting this fine grain access policy error.
ORA-30372: fine grain access policy conflicts with materialized view
While creating Summary using query statistics, I am getting this following error.
ORA-30353: expression not supported for query rewrite

We are using Discoverer 10g. We have an APPS mode EUL and I am doing this by logging into Discoverer Admin as EUL owner, which is EUL_US. This user has all the previlages specified in Discoverer Admin Doc.

ORA-30372, I could figure out is the problem with tables HZ_ORGANIZATION_PROFILES and HZ_PERSON_PROFILES which I used in the view for the folder I need to summarize.
Tried creating materialized views on these folders seperately in SQL plus, but have the same error.
Can Somebody help me to get through this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2009

Added on Sep 20 2006

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

18 comments

5,059 views