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?
Thanks Mostafa. I’m getting closer.
I added AVUSER before the view name
(Select * from AVUSER.pv.review_component)
I also granted select to AVDWUSER
In return the reporting engine only displays the names of the columns. No actual data.
I would appreciate any additional direction.
Thanks
Janusz Sidor
Please try the following.
(Select * from AVUSER.pv_review_component)
I see you have a period after PV instead of an underscore.
The type was only in the question, the real query does have the underscore
Can you add some screenshots?
Once I type avuser.pv_review_component in the FROM Clause text box, it works as expected.
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