Skip to content

A user gets an 'insufficient privileges' error while searching in a form window, even though their permission sets have been cross-checked against a working prod user and every API checkbox in the relevant permission set is confirmed ticked — what else can cause this?

Answer

Try restarting the underlying PL/SQL connection pool rather than continuing to chase permission-set grants: log into the IFS Middleware Server Admin Console as the 'ifs' user, navigate to Main Cluster > Data Sources > Control, click the 'Plsql-Access' row, and select Restart — then restart the application and re-test. This only refreshes the available database connections in that pool; it doesn't disconnect other users' ongoing sessions. The same approach applies on Apps9, using that version's equivalent data source.

← Browse Platform, Aurena, and customization questions