SQL> exec fnd_conc_clone.setup_clean;
BEGIN fnd_conc_clone.setup_clean; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'FND_CONC_CLONE.SETUP_CLEAN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Reason :
This package should be executed from APPS user whereas i was executing from sys user.
connect as APPS user and execute the command.
bash-3.2$ sqlplus apps/******
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 20 11:14:59 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
We should run autoconfig in both apps and db tier once we execute cleaned fnd_nodes table.
bash-3.2$ sqlplus apps/******
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 20 11:14:59 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
We should run autoconfig in both apps and db tier once we execute cleaned fnd_nodes table.
No comments:
Post a Comment