My Oracle Support Banner

Pacipol.sql Failed While Runing DBMS_RLS.ADD_POLICY (Doc ID 2650764.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Project Planning and Control - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Upgrading from 12.1.3 to 12.2.0
pacipol.sql failed while runing DBMS_RLS.ADD_POLICY


ERROR
-----------------------
sqlplus -s APPS/***** @/oracle/SID/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/SID/apps/fs1/EBSapps/appl/pa/12.0.0/patch/115/sql/pacipol.sql &un_pa &un_apps'
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-28104: input value for statement_types is not valid
ORA-06512: at line 82
ORA-06512: at "SYS.DBMS_RLS_INT", line 23
ORA-06512: at "SYS.DBMS_RLS", line 54
ORA-06512: at "APPS.FND_ACCESS_CONTROL_UTIL", line 227
ORA-06512: at "APPS.FND_ACCESS_CONTROL_UTIL", line 127
ORA-06512: at line 60


Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.