Hi All,
I am facing the below error message in faceted search
Error : Ajax call returned server error ORA-01031: insufficient privileges for
I have added 4 facets which are having a database column which is working fine.
Added one more facet that is a checkbox with Y and N and it is a non database column and logic for the non database column in the query as below.
(CASE WHEN NVL(ONHAND_QTY,0)=0 THEN
'N'
ELSE
'Y'
END ) onhand_flag
here the issue is raising when run the page
if I deselect the compute count property then the issue is not raising.
As per the requirement I have to show the facet counts.
Please let me know how to solve this issue.
Thank you.