5 Replies Latest reply on Jun 17, 2015 4:29 PM by Srini Chavali-Oracle

    After upgrade many invalids objects in AQ and OKC...

    1466728


      HI Gurus,

       

      About our environment --> 11i it used for HRMS HP server..It is upgraded database to 11g at 2013 and later they have upgraded to R12.1.3 at 2014 (with OVM oracle linux server).

       

      Now our ideas is to use the R12.1.3  Finance,EAM,OKC,AQ,... 

       

      We have many invalid objects in system which is affecting  the setup,Conv phase for new modules like EAM,AQ,OKC .Where this are unused modules in 11i now trying to configure it and use it.

       

       

      FYI

      OWNER             OBJECT_TYPE     OBJECT_NAME STATUS

      AMV   VIEW     AQ$AMV_MATCHING_QUEUE_TBL        INVALID

      AMV   VIEW     AQ$_AMV_MATCHING_QUEUE_TBL_F                INVALID

      APPLSYS            VIEW     AQ$ECX_INQUEUE          INVALID

      APPLSYS            VIEW     AQ$ECX_IN_OAG_Q_TABLE       INVALID

      APPLSYS            VIEW     AQ$ECX_OUTQUEUE     INVALID

      APPLSYS            VIEW     AQ$_ECX_INQUEUE_F  INVALID

      APPLSYS            VIEW     AQ$_ECX_IN_OAG_Q_TABLE_F               INVALID

      APPLSYS            VIEW     AQ$_ECX_OUTQUEUE_F              INVALID

      APPS   SYNONYM           AQ$OKC_AQ_EV_TAB   INVALID

      APPS   SYNONYM           AQ$XDP_FA_QTAB         INVALID

      APPS   SYNONYM           AQ$XDP_ORDER_PROCESSOR_QTAB     INVALID

      APPS   SYNONYM           AQ$XDP_PENDING_ORDER_QTAB          INVALID

      APPS   SYNONYM           AQ$XDP_WF_CHANNEL_QTAB INVALID

      APPS   SYNONYM           AQ$XNP_IN_TMR_QTAB             INVALID

      APPS   SYNONYM           AQ$XNP_OUT_MSG_QTAB        INVALID

      APPS   SYNONYM           AQ$_OKC_AQ_EV_TAB_F           INVALID

      AR        VIEW     AQ$AR_REV_REC_QT    INVALID

      AR        VIEW     AQ $_AR_REV_REC_QT_F             INVALID

      ASO     VIEW     AQ$ASO_ORDER_FEEDBACK_T INVALID

      ASO     VIEW     AQ$_ASO_ORDER_FEEDBACK_T_F          INVALID

      CCT      VIEW     AQ$CCT_IBME_QUEUE_TBL       INVALID

      CCT      VIEW     AQ$_CCT_IBME_QUEUE_TBL_F                INVALID

      CS        VIEW     AQ$CS_SERVICE_REQUEST_IQT                INVALID

      CS        VIEW     AQ$CS_SERVICE_REQUEST_OQT              INVALID

      CS        VIEW     AQ$_CS_SERVICE_REQUEST_IQT_F        INVALID

      CS        VIEW     AQ$_CS_SERVICE_REQUEST_OQT_F      INVALID

      IBU      VIEW     AQ$IBU_SUBS_TABLE    INVALID

      IBU      VIEW     AQ$_IBU_SUBS_TABLE_F            INVALID

      IEO 

      OKC

      JTF

      XDP

      XNP

       

       

      Regards

      Madhan