Identity Reporting - IGA 3.5.1 - "auth_user_resource_v" does not exist
Re: Identity Reporting - IGA 3.5.1 - "auth_user_resource_v" does not exist
Please be aware that IGA is not a product but rather a suite of products that work together. The product itself is Identity Governance.
1)When you defined the external datasource in ID Reporting
a) What database did you point to?
b) What was the user ID that used?
2) Did you download the "additional downloads" zip file for the 'Current User Access' Report and execute the sql file for Oracle as outlined in the ReadMe.html within the zip? When you are on the Download page in ID Reporting on looking at the Download column, there are three (3) icons for this report. Going from left to right:
Download the generated .rpz
Download the source zip
Download the additional downloads (the icon looks like a magnifying glass)
When the 3rd icon is there, you must download this file and update your ID Gov schema/Database with the correct sql file for the Report to work correctly
*NOTE: This is the same for IDM as well*
Principal Enterprise Architect