AnsweredAssumed Answered

12.1 Universes Don't Work

Question asked by DeNunzio on Jul 29, 2011
Latest reply on Jul 29, 2011 by DeNunzio
For us, anyways...

Simply put, we run a very simple query in Webi.... say, "Project Name" only. The report returns "No data to retrieve".

Now, if we go into the Query Editor, and look directly at the SQL, there's a clause....

WHERE ((EXISTS (SELECT user_id
FROM cmn_sec_assgnd_obj_perm_r_v
WHERE object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code = 'ProjectViewManagement'
AND component_code = 'PRJ'
AND user_name = @variable('BOUSER')))

If we take this out, the query works and the report returns the data it should. This only occurs in the four 12.1 universes, and not in the old 12.0 universe.

I don't know much about rights, permissions and the CMC, but it seems to me that this is an artifact of our conversion from 12.0 to 12.1. Can anyone offer guidance on what to check (such as settings in the CMC) to get us working in the new universes? I don't want to have to hack every report and remove permissions clauses to make our reports work.

Thanks!

Outcomes