5 Replies Latest reply on Nov 4, 2016 7:44 AM by Beauty_and_dBest

    Invalid objects

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      11gR2

      OL6

       

      We have the following invalid objects in our APPS schema.

      I tried to recompile them using utlrp.sql but they are still invalid.

       

      How do I know if they affect or caused errors to our business and systems process?

      Or when to ignore or not to ignore invalid objects?

       

      OWNER||''||OBJECT_NAME||''||CREATED||''||STATUS     

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

      APPS IGW_BUDGET_CATEGORY_V 11-OCT-00 INVALID        

      APPS IGW_REPORT_PROCESSING 11-OCT-00 INVALID        

      APPS OZF_EARNING_SUMMARY_MV 27-OCT-04 INVALID       

      APPS OE_ITEMS_MV 25-NOV-08 INVALID                  

      APPS MTL_DEMAND_SN 18-AUG-15 INVALID                

      APPS MTL_SUPPLY_SN 18-AUG-15 INVALID                

      APPS XXGME_QTY 06-AUG-15 INVALID                    

      APPS MTL_SYS_ITEMS_SN 18-AUG-15 INVALID             

      APPS MRP_SCHD_DATES_SN 18-AUG-15 INVALID            

      APPS MRP_FORECAST_DSGN_SN 18-AUG-15 INVALID         

      APPS MTL_OH_QTYS_SN 18-AUG-15 INVALID               

      APPS MTL_MTRX_TMP_SN 18-AUG-15 INVALID              

      APPS MRP_FORECAST_DATES_SN 18-AUG-15 INVALID        

      APPS MTL_TXN_REQUEST_LINES_SN 18-AUG-15 INVALID     

      APPS MRP_FORECAST_ITEMS_SN 18-AUG-15 INVALID        

      APPS MTL_RESERVATIONS_SN 18-AUG-15 INVALID          

      APPS MTL_ITEM_CATS_SN 18-AUG-15 INVALID             

      APPS PO_CHANGE_REQUESTS_SN 18-AUG-15 INVALID        

      APPS MTL_ITEM_RELATIONSHIPS_SN 18-AUG-15 INVALID    

      APPS OE_ODR_LINES_SN 18-AUG-15 INVALID              

      APPS WSH_TRIP_SN 18-AUG-15 INVALID                  

      APPS WSH_TRIP_STOP_SN 18-AUG-15 INVALID             

      APPS MLG_PRINT_DAILY_REPORT 21-MAY-16 INVALID       

      APPS MLG_PAYABLE_LEDGER1 07-OCT-16 INVALID          

       

      24 rows selected.

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: Invalid objects
          Kanda-Oracle

          Hi JC,

           

          ERROR #4 => Provide some guidance.

          https://blogs.oracle.com/stevenChan/entry/top_five_errors_customers_make

           

          Hope this helps!

           

          Thanks


          N Kandasamy

          • 2. Re: Invalid objects
            911172

            Hi,

             

            Please check what all modules are in use/active/installed in your EBS instance. (adutconf.sql -- can be used to check installed modules and from front end using OAM also we can check)

             

            Relevant objects of installed module must be in valid state. If installed module objects are invalid then better to check what errors you are getting when you compiled them manually and this way you may get exact cause of it.

             

            The modules which not in use and you see invalid objects then I believe that can be ignored.

             

            Thanks,

            • 3. Re: Invalid objects
              Beauty_and_dBest

              Thanks ALL,

               

              Apparently, the above object tables are basic installed modules like PO or Inventory (MTL).

              So I assume they are needed? Or do the forms specifically show the invalid table error when they accessed an invalid one?

              Or will I assume that the above tables are not needed since the user did not show any invalid forms error when they do transact business processes?

              I am confused

               

              Please help...

               

              Kind regards,

              • 4. Re: Invalid objects
                911172

                Hi,

                 

                Forms specifically may not show the table details.

                If a user getting error message while accessing forms there may be other issues and in the error stack we will get details of the same.

                All tables of installed module are very much needed. If forms having issue then we can consider to regenerate forms executable using adadmin  and log file will record the details of errors if any.

                 

                You try to compile them manually and check for errors which help help identifying exact cause of the error.

                ex:

                 

                SQL> Alter package owner.packagename compile;

                 

                subsequently after completing above command run below command to see errors.

                SQL>show error

                 

                Thanks,

                • 5. Re: Invalid objects
                  Beauty_and_dBest

                  Thanks ALL