3 Replies Latest reply on Jun 21, 2015 1:26 PM by Ubaid ur Rehman

    Oracle EBS notification workflow

    Ubaid ur Rehman

      I have a very strange problem related to Oracle EBS notification workflow. All of the users are receiving workflow notifications in their email (related to Absence management, irecruitment and other self service related applications). I have observed that only those notifications are going over email which are destined for supervisory roles. I have created some position based roles in SSHR but any notification forwarded to any position based role is not going toward user email but only in the Universal Inbox. Then any PR/PO notification is also not going to email. I have tested all of my configurations and since users are receiving the notification from SSHR that means there is no issue with email configurations or email server behavior. Can any body guide me as what should I do or how to troubleshoot this?

       

      Regards,

      Ubaid ur Rehman

        • 1. Re: Oracle EBS notification workflow
          Ubaid ur Rehman

          Please find some log messages I found in the log file

           

          [Jun 20, 2015 8:10:01 AM AST]:1434777001505:-1:-1:erp2.amc.com:20.20.20.2:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:20.20.20.2:89248:1434777001505:11:UNEXPECTED:[SVC-GSM-WFMLRSVC-177499-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag]:Problem obtaining the RESOURCE content java.net.MalformedURLException

          [Jun 20, 2015 8:10:01 AM AST]:1434777001513:-1:-1:erp2.amc.com:20.20.20.2:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:20.20.20.2:89248:1434777001505:11:UNEXPECTED:[SVC-GSM-WFMLRSVC-177499-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages()]:Problem parsing XML -> org.xml.sax.SAXException: Problem obtaining the RESOURCE content -> java.net.MalformedURLException

          [Jun 20, 2015 8:10:01 AM AST]:1434777001514:-1:-1:erp2.amc.com:20.20.20.2:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:20.20.20.2:89248:1434777001505:11:ERROR:[SVC-GSM-WFMLRSVC-177499-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(String)]:FormatterException -> oracle.apps.fnd.wf.mailer.FormatterException: Problem parsing XML-> org.xml.sax.SAXException: Problem obtaining the RESOURCE content -> java.net.MalformedURLException

                  at oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag(NotificationFormatter.java:3470)

                  at oracle.apps.fnd.wf.mailer.NotificationFormatter.endElement(NotificationFormatter.java:578)

                  at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)

                  at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1318)

                  at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)

                  at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)

                  at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:320)

                  at oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages(NotificationFormatter.java:354)

                  at oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(SMTPMessageHandler.java:77)

                  at oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read(SMTPOutboundProcessor.java:796)

                  at oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process(SvcComponentProcessor.java:604)

                  at oracle.apps.fnd.cp.gsc.Processor.run(Processor.java:283)

                  at java.lang.Thread.run(Thread.java:744)

          Caused by: org.xml.sax.SAXException: Problem obtaining the RESOURCE content -> java.net.MalformedURLException

           

          All the notification related to Absence management are being forwarded to the approver email and he can approve or reject directly from his email as well as by opening the application and go to Manager self service--> All Actions awaiting your response. But PO and PR notifications are available only in the Purchasing --> Notification Summary and nobody is receiving these alerts in their email.

          • 3. Re: Oracle EBS notification workflow
            Ubaid ur Rehman

            Thanks a lot!

            The following document worked for me

             

            Doc 1116718.1

            I disabled the attach images with outbound emails and now I am receiving all of the notifications over email.

             

            Once again thanks Srini..

            Regards,

            Ubaid ur Rehman