Hello,
Has anyone ever seen asterisks getting displayed in Interactive report or classic reports in APEX instead of a columns data? Some of the columns in report display data but some columns only show asterisks.
Running the report's SQL in SQLD or sqlplus as the same user with the same parameters displays the results WITHOUT asterisks. I.e. - normal behaviour
Our web environment
APEX 5.1.1
ORDS 3.10
Tomcat 7.0.64
OL 7.3
Our DB environment
GRID 12.2
DB Rac One Node 12.1.0.2.170418
OL 7.3
Theme used is Productivity Applications - 26 *
*** WE USE Row level security (RLS) ***
The asterisks are shown in the HTML preview section of Chrome developer tools so I think the database is pulling these values rather than some AJAX or Javascript code manipulating it.
What we've tried
Create the Interactive report as a classic report - SAME ISSUE
limit the columns in the report - SAME ISSUE
downloading the report (csv,html) - SAME ISSUE ~ i.e asterisks for some columns
logging in and out of APEX and retrying the report - SAME ISSUE
Same behaviour in Firefox and IE.