3 Replies Latest reply on Sep 9, 2017 3:00 PM by mdtaylor

    Invalid objects is APPS schema

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      11gR1

      OL6

       

       

      I have run recompile all objects but still these apps schema objects stay invalid.

      Are they needed in the apps modules? or just incomplete custom programs?

       

      SQL>  select owner||', '||object_name||', '||object_type from dba_objects where status != 'VALID';

       

      OWNER||','||OBJECT_NAME||','||OBJECT_TYPE

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

      APPS, OE_OE_FORM_LOT_SERIAL, PACKAGE BODY

      APPS, OE_ORDER_GRP, PACKAGE BODY

      APPS, OE_DEFAULT_LOT_SERIAL, PACKAGE BODY

      APPS, OE_DEFAULT_LINE_PATTR, PACKAGE BODY

      APPS, FV_FACTS_TRANSACTIONS, PACKAGE BODY

      APPS, FV_FACTS_TBAL_TRANSACTIONS, PACKAGE BODY

      APPS, FV_BUDGET_DISTRIBUTION_HDR_V, VIEW

      APPS, AHL_UTIL_UC_PKG, PACKAGE BODY

      APPS, ISC_EDW_BOOK_SUM1_F_C, PACKAGE BODY

      APPS, OPI_EDW_COGS_F_C, PACKAGE BODY

      APPS, OPI_EDW_OPMCOGS_F_C, PACKAGE BODY

      APPS, EDW_SUPPLIER_ITEM_PKG, PACKAGE BODY

      APPS, FV_SF133_NOYEAR, PACKAGE BODY

      APPS, FV_SF133_ONEYEAR, PACKAGE BODY

      APPS, FV_FACTS_TBAL_TRX, PACKAGE BODY

      APPS, FV_FACTS_TRX_REGISTER, PACKAGE BODY

      APPS, ITG_SYNCSUPPLIERINBOUND_PVT, PACKAGE BODY

      APPS, OE_OE_FORM_HEADER_PAYMENT, PACKAGE BODY

      APPS, OE_OE_FORM_LINE_PAYMENT, PACKAGE BODY

      APPS, FV_SLA_CST_PROCESSING_PKG, PACKAGE BODY

      APPS, FV_SLA_AR_PROCESSING_PKG, PACKAGE BODY

      APPS, FV_SLA_PO_PROCESSING_PKG, PACKAGE BODY

      APPS, XXMSI_INVENTORY_ITEMS_PKG, PACKAGE BODY

      APPS, F1_INVENTORY_BALANCE_PKG, PACKAGE BODY

       

       

      Please help....

       

      Kind regards,

      jc

       

      24 rows selected.

        • 1. Re: Invalid objects is APPS schema
          stejac

          prety sure this one is custom :  XXMSI_INVENTORY_ITEMS_PKG

          the other are from other module

           

          Receives Error PLS-00801 on Compiling Various Order Management Packages (Doc ID 1062560.1)

           

          funnier when they are all valid if you usa those module

          • 2. Re: Invalid objects is APPS schema
            Beauty_and_dBest

            Thanks dear friend

             

            The users or functional guys have errors on OE modules. They ask me to recompile invalid objects or OE.

            I just told the functional people who encounters error, that it is the role of developers to check the program since they know how to compile it?

             

            For example: The object OE packages, how do I know if they are being accessed by user forms? or what is the error?

             

            OE_OE_FORM_LOT_SERIAL

             

            Capture.GIF

             

            Kind regards,

            • 3. Re: Invalid objects is APPS schema
              mdtaylor

              Hi jc,

               

              In EBS, you really should not have any standard objects which are invalid.  The reason they are in valid is because some documented or possibly undocumented patch prerequisite patches were not applied.  Please download the following tool to assist in resolving your invalid objects.

               

              EBS Invalid Object Utility (Doc ID 2214169.1)

               

              Copy and paste each invalid object into support.oracle.com to see if there are known issues with it:

               

              Receives Error PLS-00801 on Compiling Various Order Management Packages (Doc ID 1062560.1)

              R12 Invalid Objects After Applying Certain Federal Financials (FV) Patches (Doc ID 1298955.1)

              R12: INVALID object FV_BUDGET_DISTRIBUTION_HDR_V (Doc ID 1326775.1)

              Package AHL_UTIL_UC_PKG Becomes Invalid after Upgrade to EBS 12.1.3 (Doc ID 1547020.1)

               

              Regards,

              Michael