APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-00904 while having Faceted Search With multiple facets search Items

Bilal AwwadSep 2 2021 — edited Sep 2 2021

Hi everyone,
I am using APEX 21.1 and I am facing the below error while running a page having two regions (Faceted Search and Classic Report) :
Error in Page :
Ajax call returned server error ORA-00904: "APPS"."HR_API": invalid identifier for .
Error in Debug :
APEX - Column Gender, referenced by facet P24_G, is not available or unauthorized. - Contact your application administrator. ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1370 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1405
The issue is happening when I am adding more than one facet item in the Faceted Search.
Can anyone let met know is if it is a bug or not?
Note that I am using a DB view from a different Schema in the Classic Report.

Thanks

This post has been answered by Carsten Czarski-Oracle on Sep 3 2021

Jump to Answer

Added on Sep 2 2021

#apex, #apex-discussions

12 comments

3,408 views

1 mention