1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Po approval workflow throwing error when approving through mail

Discussion in 'Oracle Apps Technical' started by Younus, Apr 18, 2016.

  1. Younus

    Younus Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Dubai
    HI Guys,


    I have customized the PO approval workflow as per my Requirement & My Requirement was to Attach Files to the PO approval Notification in the Mail.The Files are getting Attached but when i'am Approving the PO through mail i'am getting error.

    I have Created a Custom Package and this custom package i'am calling in package PO_POAPPROVAL_INIT1.Get_PO_Attributes.

    Error i'am getting as follows..

    An Error occurred in the following Workflow.

    Item Type = POAPPRV
    Item Key = 160705-92780
    User Key =8929

    Error Name = WF_ERROR
    Error Message = [WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: [WFMLR_DOCUMENT_ERROR]' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
    xx_attach_package.xx_notif_attach_procedure(523500, text/html)
    Wf_Notification.GetAttrblob(605959, FILE_NO_1, text/html)
    WF_XML.GetAttachment(605959, text/html)
    WF_XML.GetAttachments(605959, http://vmapp01.adnip.com:8030/, 11876)
    WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 605959)
    WF_XML.Generate(oracle.apps.wf.notification.send, 605959)
    WF_XML.Generate(oracle.apps.wf.notification.send, 605959)
    Wf_Event.setMessage(oracle.apps.wf.notification.send, 605959, WF_XML.Generate)
    Wf_Event.dispatch_internal()
    Error Stack =

    Activity Id = 324920
    Activity Label = NOTIFY_APPROVER_SUBPROCESS:pO_PO_APPROVE_PDF
    Result Code = #MAIL
    Notification Id = 605959
    Assigned User = MOBA

    I don't know where i'm going wrong.


    Any Help will be Highly Appreciated.


    Regards,
    Younus