3 Replies Latest reply on Mar 7, 2007 10:13 PM by 308313

    Error: java.sql.SQLException: ORA-20001

    557755
      Hi All,

      Can anybody explain what is this message means:
      oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_289680_TXN_INV_WFL:
      ORA-06512: at "APPS.HR_WIP_TXNS", line 1020
      ORA-06512: at line 1

      Thanks in advance!

      JTM
        • 1. Re: Error: java.sql.SQLException: ORA-20001
          518374
          When are you getting this error? ORA-20001 referes to user defined exception in PL/SQL procedures/functions. Is APPS.HR_WIP_TXNS some procedure/function?
          Can you provide the complete stack trace of OAF exception.
          • 2. Re: Error: java.sql.SQLException: ORA-20001
            557755
            Thank you so much!!! Here is the complete error details
            oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_289680_TXN_INV_WFL:
            ORA-06512: at "APPS.HR_WIP_TXNS", line 1020
            ORA-06512: at line 1

                 at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:972)
                 at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:210)
                 at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152)
                 at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:721)
                 at oracle.apps.per.irc.common.webui.IrcDraftAndWorkflowCO.processFormRequest(IrcDraftAndWorkflowCO.java:636)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
                 at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
                 at oracle.apps.fnd.framework.webui.beans.nav.OAPageButtonBarBean.processFormRequest(OAPageButtonBarBean.java:370)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1010)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
                 at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
                 at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
                 at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
                 at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
                 at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
                 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
                 at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
                 at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
                 at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
                 at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
                 at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
                 at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
                 at oa_html._OA._jspService(_OA.java:86)
                 at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
                 at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
                 at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
                 at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
                 at oracle.jsp.JspServlet.service(JspServlet.java:156)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
                 at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
                 at org.apache.jserv.JServConnection.run(JServConnection.java:294)
                 at java.lang.Thread.run(Thread.java:534)
            • 3. Re: Error: java.sql.SQLException: ORA-20001
              308313
              ORA-20001 Says there is some custom error is done on Oracle Standard package. "APPS.HR_WIP_TXNS."

              the below forum says
              http://www.orafaq.com/forum/t/17065/2/

              This forum says The ORA-06512 exception is part of the error stack, so it would be the responsiblity of the calling program to display the desired part of the stack:


              Please check your "APPS.HR_WIP_TXNS" package.