While I get the whole idea of the public database schema, it does not cover all eventualities. We want to be able to report against some of the workflow tables/views but the reporting functionality simply says they don't exist.
My assumption is that this is down to only a limited set of database privileges and/or synonyms granted to the ACMDB user for IGL.
How can we report? I would really like to be able to use the OOTB reporting functionality as that also allows scheduling, automated delivery, etc.
The reporting engine using the AVDWUSER
To be able to query a new view (or a view which is not covered by AVDWUSER) you will need to grant relevant permissions using grant command
Here is an example from V_USERS:
000030679 - 'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Governance & Lifecycle