12 Replies Latest reply on Jun 22, 2017 10:34 PM by mdtaylor

    Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"

    Vinayak K

      Hi All,

       

      I am on R12.2.5 application and Database is on 12.1.0.2 which are on Windows 2012 64 OS

      It is single node instance

      From last 2 days, Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"

      Will attach the screenshot of error.

      We have not done any changes

       

      Waiting for your reply.

      Thanks in advance

      Vinayak K

        • 1. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
          Vinayak K

          Also when I try compiling APPS schema using adadmin, i get the below message

          Enter your choice [5] : 3

           

           

                  Compile/Reload Applications Database Entities

             ---------------------------------------------------

           

           

             1.    Compile APPS schema

           

           

             2.    Compile menu information

           

           

             3.    Compile flexfields

           

           

             4.    Reload JAR files to database

           

           

             5.    Return to Main Menu

           

           

           

           

          Enter your choice [5] : 1

           

           

           

           

          AD utilities can support a maximum of 999 workers. Your

          current database configuration supports a maximum of 323 workers.

          Oracle recommends that you use between 32 and 128 workers.

           

           

           

           

          Enter the number of workers [32] : 16

           

           

          Run Invoker Rights processing in incremental mode [No] ?

           

           

           

           

          Creating the AD_UTIL_PARAMS table...

          Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.

           

           

          Creating FND_INSTALL_PROCESSES table...

           

           

          The table FND_INSTALL_PROCESSES created by AD Administration already exists.

           

           

          If you are sure you do not want to keep the information from the failed

          AD Administration session,you may drop FND_INSTALL_PROCESSES table and

          continue with AD Administration.

           

           

          If you choose not to drop FND_INSTALL_PROCESSES table, AD Administration

          cannot continue successfully.

           

           

          Drop FND_INSTALL_PROCESSES table [No] ? Yes

           

           

          AD Administration error:

          The following ORACLE error:

           

           

          ORA-00604: error occurred at recursive SQL level 1

          ORA-06550: line 5, column 5:

          PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE

          ORA-06550: line 4, column 37:

          PL/SQL: Statement ignored

          ORA-06550: line 5, column 5:

          PLS-00174: a static boolean expression must be used

          ORA-01434: private synonym to be dropped does not exist

           

           

           

           

          occurred while executing the SQL statement:

           

           

          DROP SYNONYM AD_DEFERRED_JOBS

           

           

          AD Administration error:

          Error dropping FND_INSTALL_PROCESSES table

           

           

           

           

          You should check the file

          E:\oracle\PROD\fs_ne\EBSapps\log\adadmin\log\adadmin.log

           

           

          for errors.

           

           

           

           

          E:\oracle\PROD\fs1\inst\apps\PROD_erpprod\admin\scripts>

          • 2. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
            mdtaylor

            Please source your run environment and type adop -status.

             

            You should see one line fs_clone for phase and status completed.  If you have an open adop cycle, please complete it.

             

            Also disable fnd_adg% triggers and reload this package from the command line:

             

            cd %FND_TOP%\patch\115\sql

            sqlplus apps

            alter trigger fnd_adg_error_trigger disable;

            alter trigger fnd_adg_logoff_trigger disable;

            alter trigger fnd_adg_logon_trigger disable;

            @AFDGCPDS.pls

             

            This package has a spec only in my 12.2.6 Windows install.

             

            Regards,

            Michael

            • 3. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
              Vinayak K

              Dear Michael,

               

              Thanks for you reply.

              Below is the status of adop

              E:\oracle\PROD\fs1\EBSapps\appl\fnd\12.0.0\sql>adop -status

              ECHO is off.

              ECHO is off.

              Mon 06/19/2017 09:54 AM

              ECHO is off.

              ECHO is off.

              APPSORA.cmd exiting with status 0

               

               

              Enter the APPS password:

              Connected.

              ==============================================================

              ADOP (C.Delta.8)

              Session Id: 26

              Command: status

              Output: E:\oracle\PROD\fs_ne\EBSapps\log\adop\26\20170619_095417/adzdshowstatus.out

              ===============================================================

              Node Name       Node Type  Phase           Status          Started              Finished

              Elapsed

              --------------- ---------- --------------- --------------- -------------------- --------------------

              ------------

              erpprod         master     PREPARE         SESSION ABORTED 2017/05/30 10:18:43  2017/05/30 11:18:46

              1:00:03

                                         APPLY           SESSION ABORTED

                                         FINALIZE        SESSION ABORTED

                                         CUTOVER         SESSION ABORTED

                                         CLEANUP         COMPLETED       2017/05/31 14:10:55  2017/05/31 14:13:31

              0:02:36

               

               

              isupplier       slave      PREPARE         SESSION ABORTED 2017/05/30 12:20:14  2017/05/30 13:16:08

              0:55:54

                                         APPLY           SESSION ABORTED

                                         FINALIZE        SESSION ABORTED

                                         CUTOVER         SESSION ABORTED

                                         CLEANUP         COMPLETED       2017/05/31 14:10:55  2017/05/31 14:13:31

              0:02:36

               

               

               

               

               

               

              File System Synchronization Type: Light

               

               

              INFORMATION: Patching cycle aborted, so fs_clone will run automatically on erpprod,isupplier nodes i

              n prepare phase of next patching cycle.

               

               

               

               

              adop exiting with status = 0 (Success)

               

               

              E:\oracle\PROD\fs1\EBSapps\appl\fnd\12.0.0\sql>

              • 4. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                Vinayak K

                Dear Michael,

                 

                Will update you once this, action plan is performed on Production tonight after backup.

                • 5. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                  mdtaylor

                  The FND_ADG objects are related to Active Data Guard.  Do you have this implemented and/or recently had the standby instance go down?

                  • 6. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                    Vinayak K

                    We have not implemented Active Data guard yet. But we have plan to implement it in future.

                    • 7. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                      VishnuVinnakota

                      Hi Vinayak,

                       

                          Did you check the invalids? How many invalids are there?

                       

                          select owner,count(*) from dba_objects where status='INVALID' group by owner order by 2 desc;

                       

                          select last_ddl_time from dba_objects where object_name='FND_ADG_COMPILE_DIRECTIVE'

                       

                          select count(*) from fnd_log_messages where message_text like '%FND_ADG_COMPILE_DIRECTIVE%';

                       

                          provide the invalids list and message_text if you find any rows. Lets fix this

                       

                      Thanks,

                      Vishnu

                      • 8. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                        Vinayak K

                        Hi Vishnu,

                         

                        Thanks for the reply.

                        SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner order by 2 desc;

                         

                         

                        OWNER        COUNT(*)

                        ---------- ----------

                        APPS                4

                         

                         

                        SQL> select last_ddl_time from dba_objects where object_name='FND_ADG_COMPILE_DIRECTIVE';

                         

                         

                        LAST_DDL_TIME

                        ------------------

                        29-DEC-15

                        It was last modified in 2015

                         

                        SQL>  select count(*) from fnd_log_messages where message_text like '%FND_ADG_COMPILE_DIRECTIVE%';

                         

                          COUNT(*)

                        ----------

                                 0

                        SQL>

                        • 9. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                          Vinayak K

                          This is my observation after michael provided last action plan. I am yet apply the action plan

                           

                           

                          TRIGGER_NAME                   STATUS

                          ------------------------------ --------

                          FND_ADG_CONCURRENT_REQUEST_U   ENABLED

                          FND_ADG_CONCURRENT_REQUEST_I   ENABLED

                          FND_ADG_LOGON_TRIGGER          ENABLED

                          FND_ADG_LOGOFF_TRIGGER         ENABLED

                          FND_ADG_ERROR_TRIGGER          ENABLED

                           

                           

                          SQL> select object_name,LAST_DDL_TIME from all_objects where object_type like 'TRIGGER' and object_n

                          ame like '%ADG%';

                           

                           

                          OBJECT_NAME                    LAST_DDL_TIME

                          ------------------------------ ------------------

                          FND_ADG_CONCURRENT_REQUEST_I   29-APR-16

                          FND_ADG_CONCURRENT_REQUEST_U   29-APR-16

                          FND_ADG_LOGON_TRIGGER          07-JUN-17

                          FND_ADG_LOGOFF_TRIGGER         07-JUN-17

                          FND_ADG_ERROR_TRIGGER          07-JUN-17

                           

                           

                          SQL>

                          • 10. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                            mdtaylor

                            The 3 triggers I asked you to disable are disabled in my Windows 12.2.6 instance, so please disable those if you want users to access forms.

                            • 11. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                              Vinayak K

                              Hi Michael,

                               

                              The Action plan mentioned by you has worked. Thanks for the support.

                              What could be the reason for triggers getting enabled.

                               

                              Also Thanks for support from all.

                              • 12. Re: Every form is giving error "PLS-00754: illegal reference to editioned object APPS.FND_ADG_COMPILE_DIRECTIVE"
                                mdtaylor

                                Maybe some DBA was working on implementing Active Data Guard and enabled the triggers in your production instance without completing all of the required steps.