3 Replies Latest reply: Jan 3, 2013 11:47 AM by Hussein Sawwan-Oracle RSS

    Post upgrade R12.1.1 to R12.1.3 invlid objects

    Mohammed Abdul Muqeet
      Dear Experts,

      Kindly note that i have performed the upgrade from R12.1.1 to R12.1.3 .

      I have noted the below invalid objects.

      APPS     MSC_CL_PULL     PACKAGE BODY     INVALID
      APPS     RLM_MANAGE_DEMAND_SV     PACKAGE BODY     INVALID
      APPS     RLM_RD_SV     PACKAGE BODY     INVALID
      APPS     RLM_EXTINTERFACE_SV     PACKAGE BODY     INVALID
      APPS     ISC_EDW_BOOK_SUM1_F_C     PACKAGE BODY     INVALID
      APPS     OPI_EDW_OPMINV_DAILY_STAT_F_C     PACKAGE BODY     INVALID
      APPS     OKL_REVERSE_CONTRACT_PVT     PACKAGE BODY     INVALID
      APPS     OKL_ACC_GROUP_PVT     PACKAGE BODY     INVALID
      APPS     OKL_TRANS_CONTRACTS_PVT_W     PACKAGE BODY     INVALID
      APPS     OKL_TRANSACTION_PVT_W     PACKAGE BODY     INVALID
      APPS     OKL_GENERATE_ACCRUALS_PUB     PACKAGE BODY     INVALID
      APPS     OKL_LA_JE_PUB     PACKAGE BODY     INVALID
      APPS     OKL_CONTRACT_REBOOK_PUB     PACKAGE BODY     INVALID
      APPS     OKL_TRANSACTION_PUB     PACKAGE BODY     INVALID
      APPS     OKL_AM_ASSET_DISPOSE_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_ASSET_RETURN_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_CONSOLIDATED_QTE_PVT     PACKAGE BODY     INVALID
      APPS     OKL_INTEREST_CALC_PVT     PACKAGE BODY     INVALID
      APPS     OKL_LA_JE_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_BTCH_EXP_LEASE_LOAN_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_LOAN_TRMNT_PVT     PACKAGE BODY     INVALID
      APPS     OKL_LOSS_PROV_PVT     PACKAGE BODY     INVALID
      APPS     OKL_MISC_TRANS_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_QUOTES_WF     PACKAGE BODY     INVALID
      APPS     OKL_REV_LOSS_PROV_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_REPURCHASE_ASSET_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_RESTRUCTURE_RENTS_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_RECYCLE_TRMNT_PVT     PACKAGE BODY     INVALID
      APPS     OKL_SPLIT_CONTRACT_PVT     PACKAGE BODY     INVALID
      APPS     OKL_TRANS_CONTRACTS_PVT     PACKAGE BODY     INVALID
      APPS     OKL_GENERATE_ACCRUALS_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_ACCOUNTING_UPDATE_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_ACC_GROUP_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_CONTRACT_REBOOK_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_AM_REPURCHASE_ASSET_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_TRX_CONTRACTS_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_TRANS_CONTRACTS_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_TRX_TYPES_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_TXL_QUOTE_LINES_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_TRANSACTION_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_PROCESS_TRX_TYPES_PUB_W     PACKAGE BODY     INVALID
      APPS     OKL_SERVICE_INTEGRATION_PVT     PACKAGE BODY     INVALID
      APPS     FTE_TP_GRP     PACKAGE BODY     INVALID
      APPS     OKL_VENDOR_AGREEMENT_PUB     PACKAGE BODY     INVALID
      APPS     OKL_PERIOD_SWEEP_PVT     PACKAGE BODY     INVALID
      APPS     OKL_VSS_WF     PACKAGE BODY     INVALID
      APPS     WSH_FTE_TP_INTEGRATION     PACKAGE BODY     INVALID
      APPS     WSH_TP_RELEASE_INT     PACKAGE BODY     INVALID
      APPS     OKL_AM_BAL_WRITEOFF_PVT     PACKAGE BODY     INVALID
      APPS     OKL_PROCESS_PPD_PVT     PACKAGE BODY     INVALID
      APPS     OKL_AM_TERMNT_VENDOR_PRG_PVT     PACKAGE BODY     INVALID


      please advise.

      Mohammed. Abdul Muqeet
        • 1. Re: Post upgrade R12.1.1 to R12.1.3 invlid objects
          Mohammed Abdul Muqeet
          Quick update

          I have bounced the database.

          Recompiled the invalid objects using the adadmin.

          I have noticed only these are remaining..


          OWNER     OBJECT_NAME     OBJECT_TYPE     STATUS

          APPS     MSC_CL_PULL     PACKAGE BODY     INVALID
          APPS     RLM_MANAGE_DEMAND_SV     PACKAGE BODY     INVALID
          APPS     RLM_RD_SV     PACKAGE BODY     INVALID
          APPS      RLM_EXTINTERFACE_SV     PACKAGE BODY     INVALID
          APPS     ISC_EDW_BOOK_SUM1_F_C     PACKAGE BODY     INVALID
          APPS      OPI_EDW_OPMINV_DAILY_STAT_F_C     PACKAGE BODY     INVALID
          APPS      OKL_ACCOUNTING_UPDATE_PUB_W     PACKAGE BODY     INVALID
          APPS      OKL_ACC_GROUP_PUB_W     PACKAGE BODY     INVALID

          Regards
          Mohammed Abdul Muqeet
          • 2. Re: Post upgrade R12.1.1 to R12.1.3 invlid objects
            Srini Chavali-Oracle
            Pl see if this MOS Doc can help

            After Upgrading From R12.1.1 To R12.1.3, There Are Some Invalid Objects on ASO, RLM, OPI, MSC..etc How to Fix this ? [ID 1493063.1]

            HTH
            Srini
            • 3. Re: Post upgrade R12.1.1 to R12.1.3 invlid objects
              Hussein Sawwan-Oracle
              Recompiled the invalid objects using the adadmin.
              What is the error you get if you compile the objects manually?
              I have noticed only these are remaining..

              OWNER     OBJECT_NAME     OBJECT_TYPE     STATUS

              APPS     MSC_CL_PULL     PACKAGE BODY     INVALID
              APPS     RLM_MANAGE_DEMAND_SV     PACKAGE BODY     INVALID
              APPS     RLM_RD_SV     PACKAGE BODY     INVALID
              APPS      RLM_EXTINTERFACE_SV     PACKAGE BODY     INVALID
              APPS     ISC_EDW_BOOK_SUM1_F_C     PACKAGE BODY     INVALID
              APPS      OPI_EDW_OPMINV_DAILY_STAT_F_C     PACKAGE BODY     INVALID
              APPS      OKL_ACCOUNTING_UPDATE_PUB_W     PACKAGE BODY     INVALID
              APPS      OKL_ACC_GROUP_PUB_W     PACKAGE BODY     INVALID
              If you are not using any of the above modules, you can safely ignore those invalid objects.

              Thanks,
              Hussein