Forum Stats

  • 3,838,691 Users
  • 2,262,394 Discussions
  • 7,900,732 Comments

Discussions

Human Workflow Issue in 11.1.1.6

Hi Experts,

I working on a Human Workflow Project in SOA Suite 11.1.1.6.

My requirement is to pass the HTML data as content to Human Workflow Task to Notification user. Do elaborate more, the user will get email notification from Human Workflow where in the body of email he will see the HTML content.

I created Data object in Human task as "EmailDataContent" of type String. When I am passing data to HWF through BPEL. Its throwing below error.

INPUT:

=====

<initiateTaskInput>

<part  name="payload">

<initiateTask>

<task>

<title>Claim ID:1234ABCD requires your review</title>

<payload>

<EmailDataContent xsi:type="ns:string"><html> <head> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <style type="text/css">.hdrtbl{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;background-color:#f2f2f5;} .hdrsh{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;color:#755600;text-align:right;padding:3px} .hdrdt{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;color:#003D5B;text-align:left;padding:3px} .dtltbl{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;border-width:1px;spacing:0;background-color:#CCCCCC;border: 1px} .dtlth{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;background-color:#B9C9FE;text-align:center;padding:0px;height:22px;} .dtldt{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;background-color:#FFF5D5;text-align:left;padding:4px;height:22px;color:#003D5B} .sumcell{font-family:Tahoma,arial,Helvetica,sans-serif;font-size:9pt;background-color:#FFFFFF;text-align:right;padding:4px;height:22px;font-weight:bold} pre {font-family:Tahoma,arial,Helvetica,sans-serif; font-size:10pt} body {font-family:Tahoma,arial,Helvetica,sans-serif; font-size:10pt} h3 {font-family:Tahoma,arial,Helvetica,sans-serif;} h4 {font-family:Tahoma,arial,Helvetica,sans-serif;} h5 {font-family:Tahoma,arial,Helvetica,sans-serif;color:#123C73}</style> </head> <body> <hr align="left" width="1000px"> This message is automatically generated. Please do not reply to this message. <br> An incentive claim with reference number PN00000623 as been submitted and is pending review Please login to the CEQ to review the claim. <br><br> <table width="1000px" class="hdrtbl"> <tr> <td class="hdrsh">Customer Group</td> <td class="hdrdt">ANYDATA</td> <td class="hdrsh">Assigned To</td> <td class="hdrdt">XXXXXXXXX</td> <td class="hdrsh">Status</td> <td class="hdrdt">Approved</td> </tr> <tr> <td class="hdrsh">Program Notice #</td> <td class="hdrdt">XXXXXXXXXXXXXXXX</td> <td class="hdrsh">Sales PeriodStart Date</td> <td class="hdrdt">1/1/2013</td> <td class="hdrsh">End Date</td> <td class="hdrdt">3/31/2014</td> </tr> <tr> <td class="hdrsh">XXXXXXXXXXX</td> <td class="hdrdt">Paid</td> <td class="hdrsh">Purchase PeriodStart Date</td> <td class="hdrdt">1/1/2013</td> <td class="hdrsh">End Date</td> <td class="hdrdt">12/31/2013</td> </tr> <tr> <td class="hdrsh">Creation Date</td> <td class="hdrdt">10/29/2013</td> <td class="hdrsh">Quarter</td> <td class="hdrdt">CYQ1'13</td> <td class="hdrsh">Created by</td> <td class="hdrdt">XXXXXXXXXXXXXX</td> </tr> <tr> <td class="hdrsh">Description</td> <td Colspan="5" class="hdrdt">XXXXXXXXXXXXX</td> </tr> </table><br> <h4>Device Details</h4> <hr align="left" width="1000px"> <h5>Non Qualified Reporting</h5> <table width="1000px" class="dtltbl"> <th class="dtlth">Product</th> <th class="dtlth">Shipment</th> <th class="dtlth">Requested Non Qual</th> <tr> <td class="dtldt">XXXXXXXXXXXXXX</td> <td class="dtldt">16,000</td> <td class="dtldt">0</td> </tr> </table><br> <table width="1000px" class="dtltbl"> <th class="dtlth">Product/Chipset</th> <th class="dtlth">Device Type</th> <th class="dtlth">Purchase Period</th> <th class="dtlth">Purchase Start Date</th> <th class="dtlth">Purchase End Date</th> <th class="dtlth">Shipment</th> <th class="dtlth">Claim</th> <th class="dtlth">Net ASP</th> <th class="dtlth">Rebate Per Unit</th> <th class="dtlth">Extended</th> <tr> <td class="dtldt">xxxxxxxxxxxx</td> <td class="dtldt">xxxxxxxxxxxxxxxxx</td> <td class="dtldt">Purchase Period 1</td> <td class="dtldt">1/1/2013</td> <td class="dtldt">12/31/2013</td> <td class="dtldt">16,000</td> <td class="dtldt">9,450</td> <td class="dtldt">$18.810</td> <td class="dtldt">$4.710</td> <td class="dtldt">$44,509.50</td> </tr> <tr> <td colspan="9" class="sumcell">Total</td> <td class="dtldt">$44,509.50</td> </tr> </table><br> If you have any questions, contact XXXXX. <br> If you did not submit this request, please forward this email immediately to xxxx <br><br> XXXXXXXXXXXXXXXXXXXXXXXX</a> </body> </html></EmailDataContent>

</payload>

<creator>XXXXXXXXXX</creator>

<ownerUser>XXXXXXXXXX</ownerUser>

<priority>3</priority>

</task>

<routingSlip/>

</initiateTask>

</part>

</initiateTaskInput>

OUTPUT FAULT:

============

<fault>

<bpelFault>

<faultType>1</faultType>

<operationErroredFault>

<part  name="payload">

<operationErroredFault>

<faultInfo>java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column </faultInfo>

</operationErroredFault>

</part>

</operationErroredFault>

</bpelFault>

</fault>

Please can you help me in resolving this issue.

Thanks - RK.

Tagged:
This discussion has been closed.