Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 5472959: Encounter error while running fnd_datasec_postupgrade.sql

edited Jul 8, 2012 5:19PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 16 commentsAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center