Hello,
I am unable to retrieve data from certain views within E-business Suite when running my report on the desktop, but am not sure why. My version is Report Builder 10.1.2.0.2.
I have set up a very simple report which just has one standard frame, enclosing one repeating frame and one field.
I am logged in to reports as apps and am trying to run the report where the underlying query is:
SELECT *
FROM apps.fnd_flex_values_vl
The field source is "Description".
But there are no results when I run the report - the repeating frame is not printed out. When I run the query in Toad (also logged in as apps) the data is retrieved as expected.
However if I edit the query to the following
SELECT *
FROM apps.fnd_resp_sec_roles
And alter the field source to "Name" all records are output successfully on my report.
Our DBA can't see any permissions issues with the fnd_flex_values_vl view as apps has permissions to see other views/synonyms that are used to create this view.
There are other views that don't work too, e.g. per_jobs_vl, fnd_id_flex_structures_v.
I can query all synonyms and some views, e.g. fnd_flex_value_sets, fnd_grants_view or custom views we have created.
Any ideas?
Many thanks,
Hazel