5 Replies Latest reply on Sep 11, 2017 8:19 AM by Beauty_and_dBest

    Invalid objects in APPS schema

    Beauty_and_dBest

      Hi ALL,

       

      EBS 12.2.6

      12c

      OL6

       

      I have recompiled invalid objects in apps schema, but there are still objects left invalid

       

      I connected to apps/apps

      and tun >

        1* select object_name ||', '||object_type from user_objects where status='INVALID'

       

       

       

      OBJECT_NAME||','||OBJECT_TYPE

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

      FFP50296_01042007, PACKAGE BODY

      FFP50296_01122012, PACKAGE BODY

      FFP50296_06042005, PACKAGE BODY

      FFP52473_01010001, PACKAGE BODY

      FFP53354_01012004, PACKAGE BODY

      FFP53354_01012005, PACKAGE BODY

      FFP53354_01012014, PACKAGE BODY

      FFP53354_01072007, PACKAGE BODY

      FFP53354_01092011, PACKAGE BODY

      FFP53354_01102008, PACKAGE BODY

      FFP55409_01012005, PACKAGE BODY

      FFP55409_01012013, PACKAGE BODY

      FFP57308_01011900, PACKAGE BODY

      FFP57309_01011900, PACKAGE BODY

      FFP57310_01011900, PACKAGE BODY

      FFP57311_01011900, PACKAGE BODY

      FFP57312_01011900, PACKAGE BODY

      FFP58913_01010001, PACKAGE BODY

      FFP60315_01010001, PACKAGE BODY

      FFP60315_01012010, PACKAGE BODY

      FFP60357_01011951, PACKAGE BODY

      FFP60676_01010001, PACKAGE BODY

      FFP61152_01010001, PACKAGE BODY

      FFP61156_01010001, PACKAGE BODY

      FFP61156_01012010, PACKAGE BODY

      FFP61161_01010001, PACKAGE BODY

      FFP62837_01012009, PACKAGE BODY

      FFP67218_01032013, PACKAGE BODY

      FFP67219_01032013, PACKAGE BODY

      FFP67224_01032013, PACKAGE BODY

      FFP67231_01032013, PACKAGE BODY

      FFP67240_01032013, PACKAGE BODY

      FFP67241_01032013, PACKAGE BODY

      FFP67251_01032013, PACKAGE BODY

      FFP67270_01032013, PACKAGE BODY

      FFP67271_01032013, PACKAGE BODY

      FFP67280_01032013, PACKAGE BODY

      PROC1, PROCEDURE

       

      38 rows selected.

       

      SQL> l

       

      What are these FFP objects?

       

       

      Kind regards,

      jc

        • 1. Re: Invalid objects in APPS schema
          mdtaylor

          Hi jc,

           

          Please recompile all Payroll fast formulas.

           

          App-FF-33186 Failed to Execute NI_Validation (Doc ID 352284.1)

           

          Troubleshooting Oracle Payroll Common Errors (Doc ID 1345874.1)

          How to Compile Fast Formulas From the Server (via FFXBCP) (Doc ID 167689.1)

           

          compile fast formulas with

           

          sqlplus apps/apps @$FF_TOP/patch/115/sql/ffgenwrap.sql

          $FF_TOP/bin/FFXBCP apps/apps 0 Y %% %%

           

          Regards,

          Michael

          • 2. Re: Invalid objects in APPS schema
            Beauty_and_dBest

            Thanks Michael

             

             

            I run it but still the  invalid objects stays invalid

             

            $ sqlplus apps/apps @$FF_TOP/patch/115/sql/ffgenwrap.sql $FF_TOP/bin/FFXBCP apps/apps 0 Y %% %%

             

            SQL*Plus: Release 10.1.0.5.0 - Production on Mon Sep 11 01:08:20 2017

            Copyright (c) 1982, 2005, Oracle.  All rights reserved.

             

            Connected to:

            Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

            With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

             

            PL/SQL procedure successfully completed.

             

            Commit complete.

             

            Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

            With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

            [oracle@a6dd6a ~]$

            [oracle@a6dd6a ~]$ sqlplus apps/apps

             

            SQL*Plus: Release 10.1.0.5.0 - Production on Mon Sep 11 01:09:26 2017

             

            Copyright (c) 1982, 2005, Oracle.  All rights reserved.

             

            Connected to:

            Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

            With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

             

             

            SQL> select object_name ||', '||object_type from user_objects where status='INVALID';

            OBJECT_NAME||','||OBJECT_TYPE

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

            FFP50296_01042007, PACKAGE BODY

            FFP50296_01122012, PACKAGE BODY

            FFP50296_06042005, PACKAGE BODY

            FFP52473_01010001, PACKAGE BODY

            FFP53354_01012004, PACKAGE BODY

            FFP53354_01012005, PACKAGE BODY

            FFP53354_01012014, PACKAGE BODY

            FFP53354_01072007, PACKAGE BODY

            FFP53354_01092011, PACKAGE BODY

            FFP53354_01102008, PACKAGE BODY

            FFP55409_01012005, PACKAGE BODY

            FFP55409_01012013, PACKAGE BODY

            FFP57308_01011900, PACKAGE BODY

            FFP57309_01011900, PACKAGE BODY

            FFP57310_01011900, PACKAGE BODY

            FFP57311_01011900, PACKAGE BODY

            FFP57312_01011900, PACKAGE BODY

            FFP58913_01010001, PACKAGE BODY

            FFP60315_01010001, PACKAGE BODY

            FFP60315_01012010, PACKAGE BODY

            FFP60357_01011951, PACKAGE BODY

            FFP60676_01010001, PACKAGE BODY

            FFP61152_01010001, PACKAGE BODY

            FFP61156_01010001, PACKAGE BODY

            FFP61156_01012010, PACKAGE BODY

            FFP61161_01010001, PACKAGE BODY

            FFP62837_01012009, PACKAGE BODY

            FFP67218_01032013, PACKAGE BODY

            FFP67219_01032013, PACKAGE BODY

            FFP67224_01032013, PACKAGE BODY

            FFP67231_01032013, PACKAGE BODY

            FFP67240_01032013, PACKAGE BODY

            FFP67241_01032013, PACKAGE BODY

            FFP67251_01032013, PACKAGE BODY

            FFP67270_01032013, PACKAGE BODY

            FFP67271_01032013, PACKAGE BODY

            FFP67280_01032013, PACKAGE BODY

            PROC1, PROCEDURE

             

             

            38 rows selected.

            • 3. Re: Invalid objects in APPS schema
              Kanda-Oracle

              you can compile one of them to see what is the errors.

              • 4. Re: Invalid objects in APPS schema
                Narsi M-Oracle

                Hello JC,

                 

                Looks like the FFP Objects are related to Oracle Payroll.

                Can you please review following MOS Notes:

                Invalid FFP Objects in the Database after Upgrade to EBS 12.1.3 (Doc ID 1331911.1)

                Invalid FFP Objects, Error: PLS-00306: wrong number or types of arguments in call to <Formula_Name> (Doc ID 1324560.1)

                 

                Hope this helps.

                 

                Regards,

                Narsi

                • 5. Re: Invalid objects in APPS schema
                  Beauty_and_dBest

                  Thanks Narsi and ALL,

                   

                  Anyways, we do not implement  payroll module so I can ignore it for now, because I have other important tasks to do.

                   

                   

                  Kind regards,