Patch 5472959: Encounter error while running fnd_datasec_postupgrade.sql
Running patch show error message in adwork01.log as following:
sqlplus -s APPS/***** @/d01/PROD/prodappl/ipd/11.5.0/patch/115/sql/fnd_datasec_postupgrade.sql
l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
*
ERROR at line 12:
ORA-06550: line 12, column 22:
PLS-00201: identifier 'FND_GRANTS.INSTANCE_PK1_VALUE' must be declared
ORA-06550: line 12, column 22:
PL/SQL: Item ignored
ORA-06550: line 15, column 22:
PLS-00201: identifier 'FND_GRANTS.GRANTEE_KEY' must be declared
ORA-06550: line 15, column 22:
PL/SQL: Item ignored
ORA-06550: line 16, column 22:
PLS-00201: identifier 'FND_GRANTS.START_DATE' must be declared
ORA-06550: line 16, column 22:
PL/SQL: Item ignored
ORA-06550: line 17, column 22:
PLS-00201: identifier 'FND_GRANTS.END_DATE' must be declared
Tagged:
0