9 Replies Latest reply: Jul 19, 2013 9:40 AM by Hussein Sawwan-Oracle RSS

    Workflow Inbound Mail Error

    MAXQIAN

      Hi, Everyone,

      I am using workflow inbound mail for email approval in a R12.1.3 instance. The approval email looks like the following:

      ----------------------------------------------------------------------

      Action: 'Approve'

      Note: 'Email Approve'

      NID[5144/267014093358809284322702024985511576410@WFMAIL]

      ---------------------------------------------------------------------

      this email has arrived in the inbound mail box and has been moved to PROCESS folder.

      There is also records in the WF_NOTIFICATION_ID table


      however, after a few minutes, syste will send out another email to the approver's email box.


      Subject: Invalid: Expense 16490 for xxxx, xxx (100.00 USD)

      Body:

      Warning: Your previous response to this message was invalid (see error message below). Please resubmit your response.

      Error Message: ORA-01722: invalid number
      Value Found: 16490
      Remarks: None


      and this expense report remains unapproved.


      I can't find any document in metalink for this issue.

      Is there anyone have any idea?


      Thanks,


      max

        • 2. Re: Workflow Inbound Mail Error
          MAXQIAN

          Hi, Helios,

           

          Thanks very much for your reply! I checked these documents, but they don't provide a direct solution to my issue. the error message says

           

          Error Message: ORA-01722: invalid number


          Is there any way i can see the number that has been passed?

           

          Best regards,

           

          Max

          • 3. Re: Workflow Inbound Mail Error
            Helios-GunesEROL

            Hi,

             

            You may face with bug, please review:

              Workflow Mailer Approve Expense Report Via EMail Receive Error Message Back [ID 1345823.1]


            Regard

            Helios

            • 4. Re: Workflow Inbound Mail Error
              MAXQIAN

              Hi, Helious,

              I will try the patch and update in the thread.

              thanks very much for your information.

              Max

              • 5. Re: Workflow Inbound Mail Error
                Helios-GunesEROL

                Hi;

                 

                Do not forget to apply patch to test env first

                 

                Regard

                Helios

                • 6. Re: Workflow Inbound Mail Error
                  MAXQIAN

                  Hi, Helios,

                  After this patch is applied, there are fatal errors when entering a new iexpense report.

                  when click the detail icon on the second step on an expense line, it will show an error page.

                   

                  You have encountered an unexpected error. Please contact the System Administrator for assistance.

                  Click here for exception details.

                   

                  when i click here, there are a lot of error messages.

                   

                  Exception Details.

                  oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

                    at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

                    at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)

                    at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)

                    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.ap.oie.common.lines.webui.DetailsCO.processRequestInitializeAM(DetailsCO.java:847)

                    at oracle.apps.ap.oie.common.lines.webui.DetailsCO.processRequest(DetailsCO.java:127)

                    at oracle.apps.ap.oie.entry.lines.webui.DetailsPageGlueCO.processRequest(DetailsPageGlueCO.java:50)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)

                    at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)

                    at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)

                    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)

                    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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)

                    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

                    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)

                    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)

                    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)

                    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)

                    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)

                    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)

                    at _OA._jspService(_OA.java:221)

                    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:619)

                  ## Detail 0 ##

                  java.lang.NullPointerException

                    at oracle.apps.ap.oie.common.server.ExpenseReportLinesVORowImpl.updateReceiptRequired(ExpenseReportLinesVORowImpl.java:702)

                    at oracle.apps.ap.oie.common.server.OIECommonAMImpl.ChangeExpenseType(OIECommonAMImpl.java:1098)

                    at oracle.apps.ap.oie.common.server.OIECommonAMImpl.InitializeSDP(OIECommonAMImpl.java:911)

                    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.ap.oie.common.lines.webui.DetailsCO.processRequestInitializeAM(DetailsCO.java:847)

                    at oracle.apps.ap.oie.common.lines.webui.DetailsCO.processRequest(DetailsCO.java:127)

                    at oracle.apps.ap.oie.entry.lines.webui.DetailsPageGlueCO.processRequest(DetailsPageGlueCO.java:50)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)

                    at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)

                    at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)

                    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)

                    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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)

                    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

                    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)

                    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)

                    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)

                    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)

                    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)

                    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)

                    at _OA._jspService(_OA.java:221)

                    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:619)

                  java.lang.NullPointerException

                    at oracle.apps.ap.oie.common.server.ExpenseReportLinesVORowImpl.updateReceiptRequired(ExpenseReportLinesVORowImpl.java:702)

                    at oracle.apps.ap.oie.common.server.OIECommonAMImpl.ChangeExpenseType(OIECommonAMImpl.java:1098)

                    at oracle.apps.ap.oie.common.server.OIECommonAMImpl.InitializeSDP(OIECommonAMImpl.java:911)

                    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.ap.oie.common.lines.webui.DetailsCO.processRequestInitializeAM(DetailsCO.java:847)

                    at oracle.apps.ap.oie.common.lines.webui.DetailsCO.processRequest(DetailsCO.java:127)

                    at oracle.apps.ap.oie.entry.lines.webui.DetailsPageGlueCO.processRequest(DetailsPageGlueCO.java:50)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)

                    at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)

                    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)

                    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)

                    at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)

                    at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)

                    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)

                    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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)

                    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

                    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)

                    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)

                    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)

                    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)

                    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)

                    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)

                    at _OA._jspService(_OA.java:221)

                    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:619)

                  • 7. Re: Workflow Inbound Mail Error
                    Hussein Sawwan-Oracle

                    Please see if (Unexpected Error When Choose Details Button On Cash And Other Expenses Page java.lang.NullPointerException at ExpenseReportLinesVORowImpl.updateReceiptRequired [ID 1274552.1]) helps.

                     

                    Thanks,

                    Hussein

                    • 8. Re: Workflow Inbound Mail Error
                      MAXQIAN

                      Hi, Hussein,


                      It's working, this is the exact fix to my problem. 

                      thanks very much!

                      Max

                      • 9. Re: Workflow Inbound Mail Error
                        Hussein Sawwan-Oracle

                        You're welcome!

                         

                        Regards,

                        Hussein