WAM FGA Policy Function Execution Error - ORA-00036: Maximum Number of Recursive SQL Levels (50) Exceeded

(Doc ID 1296367.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms

Policy function execution error when FGA policy is created on the table SA_USER_FGA_RESPONSIBILITY:

SYNERGEN.SDBP_FINE_GRAIN_ACCESS.FINE_GRAIN_GENERIC_RETRIEVAL
ORA-00036: maximum number of recursive SQL levels (50) exceeded

The Trace file gives the following error.

Policy function execution error:

Table/View : SYNERGEN.SA_USER_FGA_RESPONSIBILITY
Policy name: SA_USER_FGA_RESPONSIBILITY
Policy function: SYNERGEN.SDBP_FINE_GRAIN_ACCESS.FINE_GRAIN_GENERIC_RETRIEVAL
ORA-00036: maximum number of recursive SQL levels (50) exceeded

The Drop policy does not execute either. The execution keeps processing without completion.

execute DBMS_RLS.DROP_POLICY('synergen','SA_USER_FGA_RESPONSIBILITY','SA_USER_FGA_RESPONSIBILITY');
commit;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms