We have recently setup up NLQ on EBS instance following the MOS note Enabling Natural Language Query of Oracle E-Business Suite (EBS) Release 12.2, Leveraging Oracle Generative AI (MOS Note 3059877.1).
We are able to run Select AI queries on the ADB using the SQL Developer console.
However, on the EBS frontend - While trying to access - Ask Oracle E-Business Suite (EBS) as sysadmin user.
Getting below error -
ERROR\_MESSAGE
Sorry, a valid query could not be constructed. Please rephrase the question.
- Below is the error from Apex, after enabling debug.
Cursor leak: difference in "opened cursors current" is 4:
- user=APEX_240200, type=OPEN-RECURSIVE, sql_id=4u81susj9vpz8, sql_text=select priv.priv#, aggr.implied_priv# from sys.xs$priv priv,
Kindly let us know if you have any inputs or references on how to resolve this error.
