Hi!
From the release notes.
"Known Issues
Oracle Database may report 'ORA-01031: insufficient privileges' for queries that involve CURSOR expressions
In a number of cases, ORDS executes queries which include a CURSOR expression. An issue has been found executing these queries for some schemas in Oracle 18c and Oracle 19c databases. Depending on the roles and privileges involved, the issue does not occur for all schemas, which can give the impression that the issue is intermittent. Refer to RDBMS bug 29049673 for more information. The issue is manifest as follows in the exception returned:
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
This is a problem with view-merging of nested cursors introduced in Oracle 18.1 database. Please use the following as a workaround:
alter system set "_fix_control"='20648883:OFF';"
This known bug makes us hesitant to upgrade at the moment.
Will this issue be solved in the Ords product ?
Br Ola