This content has been marked as final. Show 1 reply
When the catalog is moved from Dev to Test/prod permissions are not copied. The users are part of the system folder (i.e Catalog Manager > Users > Properties > Owner Account = System Account), which is why Catalog Manager does not transfer the permissions.
I guess that is the reason you were able to run the reports from dev and not from test/prod. To have them work you might need to refresh GUID's check the Oracle note [ID 1467256.1].
Let me know if this helped.