This discussion is archived
9 Replies Latest reply: Jul 19, 2013 7:40 AM by Hussein Sawwan-Oracle RSS

Workflow Inbound Mail Error

MAXQIAN Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    Hi;

     

    Do not forget to apply patch to test env first

     

    Regard

    Helios

  • 6. Re: Workflow Inbound Mail Error
    MAXQIAN Newbie
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated

    You're welcome!

     

    Regards,

    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points