When login to oracle I can query the oracle instance AVEKSA DB.
Specifically, I'm getting useful data from pv_review_component.
However, when I attempt to run this query via an IGL report, I get - Table or View does not exist.
Why would that be?
When login to oracle I can query the oracle instance AVEKSA DB.
Specifically, I'm getting useful data from pv_review_component.
However, when I attempt to run this query via an IGL report, I get - Table or View does not exist.
Why would that be?
Hello Janusz,
Unfortunately this is a known issue. RSA released a fix for this: 000036669 - PersistenceException Error when previewing an RSA Identity Governance & Lifecycle report that has not yet been saved
If you click continue it should still work.
The reporting engine uses a different user than AVUSER. So if you are calling a table or view in AVUSER you would need to:
References:
000030679 - ORA-00942: Table of View does not exist encountered with Reports on custom table/view in Identity Management and Governance