4 Replies Latest reply on Feb 4, 2013 9:10 PM by Yuvaraj C.

    ORA-01403: no data found ORA-06512: at "APPS.FUN_RECIPIENT_WF"

    Azar
      When users are trying to update intercompany inbound transaction, it shwoing below error


      EBS Versoin : 12.1.3
      OS platform : redhat 5.6

      oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
      ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1903
      ORA-06512: at line 1

           at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
           at oracle.apps.fun.transaction.entry.webui.UpdateInTrxCO.processFormRequest(UpdateInTrxCO.java:452)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
           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 com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:662)
      ## Detail 0 ##
      java.sql.SQLException: ORA-01403: no data found
      ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1903
      ORA-06512: at line 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           at oracle.apps.fun.transaction.entry.server.InboundAMImpl.approveTrx(InboundAMImpl.java:513)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
           at oracle.apps.fun.transaction.entry.webui.UpdateInTrxCO.processFormRequest(UpdateInTrxCO.java:452)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
           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 com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:662)
      java.sql.SQLException: ORA-01403: no data found
      ORA-06512: at "APPS.FUN_RECIPIENT_WF", line 1903
      ORA-06512: at line 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           at oracle.apps.fun.transaction.entry.server.InboundAMImpl.approveTrx(InboundAMImpl.java:513)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
           at oracle.apps.fun.transaction.entry.webui.UpdateInTrxCO.processFormRequest(UpdateInTrxCO.java:452)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
           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 com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:662)

      How do i fix this issues?