3 Replies Latest reply on Feb 24, 2016 1:51 PM by Srini Chavali-Oracle

    CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE) in Oracle EBS

    Charan Durga

      inHi All,


      I am trying to use one standard wsdl of Oracle Integration Repository of EBS for integration. Once I deploy the service and open the generated wsdl it works fine. However, when trying to access the supporting schema of wsdl getting below error. Please help.

       

      <?xml version="1.0" ?>
      - <!--  Schema retrieval failed.
        -->
      - <SchemaRetrieval_Error>
        <ErrorMsg>CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE)</ErrorMsg>
      - <StackTrace>
      - <![CDATA[
      oracle.apps.jtf.base.resources.FrameworkException: CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE)
      at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4613)
      at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3147)
      at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:3121)
      at oracle.apps.fnd.wf.ws.server.AppsWSProviderServlet.getSchema(AppsWSProviderServlet.java:163)
      at oracle.apps.fnd.wf.ws.server.AppsWSProviderServlet.doGet(AppsWSProviderServlet.java:82)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
      at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
      at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:619)


        ]]>
        </StackTrace>
        </SchemaRetrieval_Error>

       

      Thanks,

      Durga

        • 1. Re: CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE) in Oracle EBS
          Srini Chavali-Oracle

          See the troubleshooting sections in these MOS Docs

           

          For R12 - MOS Doc 726414.1

           

          For R12.2 - MOS Doc 1317697.1

          1 person found this helpful
          • 2. Re: CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE) in Oracle EBS
            Charan Durga

            Hi Srini,

            I am getting below errors when I tried to run the mentioned steps.

             

            $

            $ $FND_TOP/patch/115/import/US/wfccache.ldt

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: LANGUAGE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: LDRCONFIG: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: DEFINE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: syntax error at line 14: `(' unexpected

            $

            $

            $ FNDLOAD apps/***** 0 Y UPLOAD

            Log filename : L6143300.log

             

             

            Report filename : O6143300.out

            $

            $ $JTF_TOP/patch/115/import/jtfprefabcache.lct

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: COMMENT: not found

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: DEFINE: not found

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: syntax error at line 36: `(' unexpected

            $

            $ $FND_TOP/patch/115/import/US/wfccache.ldt;

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: LANGUAGE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: LDRCONFIG: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: DEFINE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/wfccache.ldt: syntax error at line 14: `(' unexpected

            $

            $ $FND_TOP/patch/115/import/US/fndwspccache.ldt

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: LANGUAGE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: LDRCONFIG: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: DEFINE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: syntax error at line 12: `(' unexpected

            $

            $ FNDLOAD apps/**** 0 Y UPLOAD

            Log filename : L6143301.log

             

             

            Report filename : O6143301.out

            $

            $ $JTF_TOP/patch/115/import/jtfprefabcache.lct

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: COMMENT: not found

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: DEFINE: not found

            /apps_trng/apps/apps_st/appl/jtf/12.0.0/patch/115/import/jtfprefabcache.lct: syntax error at line 36: `(' unexpected

            $

            $ $FND_TOP/patch/115/import/US/ fndwspccache.ldt;

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/: cannot execute

             

             

            $ $FND_TOP/patch/115/import/US/fndwspccache.ldt;

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: LANGUAGE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: LDRCONFIG: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: DEFINE: not found

            /apps_trng/apps/apps_st/appl/fnd/12.0.0/patch/115/import/US/fndwspccache.ldt: syntax error at line 12: `(' unexpected

            $

            $

            $ exit

            #

            $ sqlplus

             

             

            SQL*Plus: Release 11.1.0.7.0 - Production on Wed Feb 24 12:49:07 2016

             

             

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

             

             

            Enter user-name: / as sysdba

             

             

            Connected to:

            Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

             

             

            SQL> select count(*) from JTF_PREFAB_CA_COMPS_VL where COMPONENT_KEY =

            'FND_WSP_SCHEMA_CACHE';  2

            select count(*) from JTF_PREFAB_CA_COMPS_VL where COMPONENT_KEY =

                                 *

            ERROR at line 1:

            ORA-00942: table or view does not exist

             

             

             

             

            SQL> select count(*) from JTF_PREFAB_CA_COMPS_VL where COMPONENT_KEY = 'FND_WSP_SCHEMA_CACHE';

            select count(*) from JTF_PREFAB_CA_COMPS_VL where COMPONENT_KEY = 'FND_WSP_SCHEMA_CACHE'

                                 *

            ERROR at line 1:

            ORA-00942: table or view does not exist

            • 3. Re: CacheComponent not registered (CacheKey=FND/FND_WSP_SCHEMA_CACHE) in Oracle EBS
              Srini Chavali-Oracle

              The lct files are loader files - they cannot be executed - the FNDLOAD command as noted in the MOS Docs should be executed with two parameters as the file names -

               

              FNDLOAD <apps/password> 0 Y UPLOAD  $JTF_TOP/patch/115/import/jtfprefabcache.lct $FND_TOP/patch/115/import/US/wfccache.ldt


              For the SELECT command, connect as APPS (not / as SYSDBA)

              1 person found this helpful