Current position:  Home > Default > How to create a HTML Table in Workflow Notification ?

How to create a HTML Table in Workflow Notification ?

Time:November 30
Advertisement
Hi,
I have a requirement to display multiple records in a HTML table in Workflow Notification. I have developed the code. In my Notification, I am seeing HTML tags and not a formatted HTML report. Appreciate your help and comments.
The following is what I have done in WF.
1. Define attribute in WF of type Document
2. Define Message in Text Body ( Should i also copy the same thing in HTML Body ??)
The following is my PL/SQL
Variable l_table is defined as varchar2(30000)
-- HTML Table Heading
l_table := '<table><tr><td>Amount</td>
<td>Description</td>
<td>Type 1099</td>
</tr>';
WF_ENGINE.SetItemAttrText(itemtype,
itemkey,
'FRB_DISTRIBUTION_HISTORY',
l_table);
When I get a notification, I get the following sample
<table><tr><td>Amount</td>
<td>Description</td>
<td>Type 1099</td>
<td>Receipt Required Flag</td>
<td>Invoice Id</td>
<td>Invoice Distribution Id</td>
</tr><tr><td>100</td>
<td></td>
<td>MISC7</td>
<td></td>
<td>429684</td>
<td>464834</td>
</tr></table>
I am missing something, Can you please let me know, what am i missing.
Kiran
Advertisement
Hi Matt,
I am working on AP_WFAPPROVAL_PKG (Oracle EBS Invoice Approval Package).
I have defined a Workflow Attribute as Type 'Document' (in Workflow Builder)
In my AP_WFAPPROVAL_PKG Package, I am retrieving my values and returning it to a variable of type varchar2(32000) and seting the WF variable(displayed below).
WF_ENGINE.SetItemAttrText(itemtype,
itemkey,
'FRB_DISTRIBUTION_HISTORY', -- This is my WF Attribute of type 'Document'
l_table);
When I see the notification, i get the format displayed below (I do see the correct values generated, but they appear as tag, and not as a HTML Table Report)
<table><tr><td>Amount</td>
<td>Description</td>
<td>Type 1099</td>
<td>Receipt Required Flag</td>
<td>Invoice Id</td>
<td>Invoice Distribution Id</td>
</tr> <tr><td>60</td>
<td></td>
<td>MISC7</td>
<td></td>
<td>429681</td>
<td>464827</td>
</tr><tr><td>40</td>
<td></td>
<td>MISC7</td>
<td></td>
<td>429681</td>
<td>464828</td>
</tr>
Please advise
Kiran

Error while creating Cross-reference table using Xreftool (PIP Ins)

2015-10-11

Error while running xref.sh script unable to create cross reference table. **Error: Exception in thread "main" java.lang.NoClassDefFoundError: oracle/tip/xref/tool/AdminTool** Could not find xref directory within tip folder (/OracleAS_1/bpel/doc

How to feel interal table in Workflow?

2015-10-11

Hi Experts, Right now i m creating one workflow in which i have an internal table with 2 fields. This internal table is multiline internal table. But the thing is i dont know how to feel entry into the internal table. I hv created one workarea with 2

Alignment in dynamic table in workflow mail

-0001-11-30

I have a workflow with a task of sending mail to SAP inbox. The body of the mail should display a table with a structure that is dynamically determined at run time. The workflow is triggered from a report in which a dynamic table is first created, fi

Workflow notification on importing to hierarchy table

-0001-11-30

Hi! I came on the following problem: I use MDM Import Server to load some records from XML-files to flat and hierarchy tables. And I also want to receive e-mail notification with the list of imported records when import is finished. So for each of th

How can I create a new table in a MySQL database in MVC 5

2015-10-11

I have an MVC 5 app, which uses MySQL hosted in Azure as a data source. The point is that inside the database, I want to create a new table called "request". I have already activated migrations for my database in code. I also have the following

Error while creating the DWH tables using DAC

2015-10-11

Hi, I am getting error while creating the DWH tables using DAC. I have created a ODBC DSN using merant driver with DAC repository DB credentials and the test connection is successful. And while creating the tables i gave the olap dw credentials and t

How do I create new user table in program and then access it?

2015-10-11

I am writing an application where I check for the existence of user objects when the add on starts and run the setup if the objects do not exist. I can create the user tables and fields but after the setup completes these objects still are not visibl

How to create a custom table in the below format

2015-10-11

Dear Friends           can any one please let me know hot to create a custom table as below outpatient |employeeno | class | startdate | enddate | spouse |1stchild | 2nchild|  Rate | amount| My FO wants to enter in the SM30 as above ......i.e he want

How to create the custom table?

2015-10-11

Hi, how to create the custom table and how to integrate the table with defferent R/3? my requiremnt is i have to create the two tables and those i have to integrate with the existed R/3 and using those R/3 i have to update my custom tables .....can g

Creating a Detail Table Based on an Action in Another Table or Matrix to Display in the Same Report (Not a Drill-Through)

2015-10-11

Hello, I was wondering if it's possible have a matrix which shows total credits by month and have drill-down groupings to display the invoice numbers for each credit.  Then, once the drill-down is expanded for a particular month, be able to click on

How to Create a Temporary Table with SQL Server

2015-10-11

I know you can create a temporary table in SQL Server 2000, but not quite sure how to do it in CFMX 7, i.e., does the SQL go inside a <CFQUERY dbtype="query"> tag? I'm pulling the main set of records from an Oracle server (1st data source)

How to use create-default-dbms-tables in SQL Server 2000

2015-10-11

Hi everyone, I'm new in EJB development. I'm trying to deploy a CMP to Weblogic 8.1 SP1 using JBuilderX. I configured a ConnectionPool and DataSource to allow the CMP to access the SQL Server 2000. However, I cannot deploy the CMP if I didn't create

How can I create an active table of content in the sidebar to help readers to get to the section?

2015-10-11

How can I create an active table of content in the sidebar to help readers to get to the section?You can create bookmarks with Adobe Acrobat.Read other 2 answers

How can I create a new table from a filed cell?

2015-10-11

Every time that I fill a row of cells I want to creat a new table with the content of that cells. How can I do it? Donw here it´s the example. From the top table, I want to fill these rows, and everytime that it´s done, I want that a new table apears

How can i create a custom table in to my banking services server

2015-10-11

I am having product type and account type details for those things I need to create a table Product Id.                 Account Type DP_PYGO_P     21 DP_BASIC     25 DP_UNLIMIT     24 DP_ADVANTG     17 DP_SAV                     34 DP_TBILL          

How to create an internal table in a Report from File of FTP Server.

2015-10-11

Hi All, I want to create an internal table in a Report program. But the problem is I have to download two latest files from FTP server. Now, based in those file I have to design internal tables in current program. The problem is the program from whic

Is there a way to create a temp table each time someone hits a procedure?

2015-10-11

I am creating a procedure in Oracle 10g to take data from Oracle to be put in a cognos report. The problem with creating a perminent table is that several people will be running this report at the same time, which means the procedure will be run each

How to process each records in the derived table which i created using cte table using sql server

2015-10-11

I want to process each row from the CTE table I created, how can I traverse from first row to second row and so on.... how to process each records in the derived table which i created using  cte table using sql serverIdeally you would be doing a set

How to Create Event polling table

2015-10-11

hi, 1)How to Create Event polling table 2) wahts RPD stands for. 3) when we are prefer Dynamic variables. thanks. raj1) http://obiee101.blogspot.com/2008/07/obiee-managing-cache-emptyingpurging.html 2) Repository Project Design ? - More than likely t