Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating custom Action history table in PO Approval Workflow notification

957930Aug 25 2012
I want create custom action action History table in PO Approval workflow notification.
My issue is when the action history is too big it doesnot shows complete action history. so i am creating my custom action history table.

But I am able to suppress the standard action history till now.

I have defined an item attribute whose internal name is #history, type is document. I have copied this in the respective message in the workflow.
In the perticular notification go to message-> Edit -> Body-> (Text or HTML)-> there use <BR>&#HISTORY<BR> at the end.

This way we can suppress the standard action history.

But now i want to generate my own custom action history table. I have set the below attribute property and writted a procedure to generate custom action history table
wf_engine.SetItemAttrText(itemtype => p_itemtype,
itemkey => p_itemKey,
aname => 'ACTION_HISTORY',
avalue => 'PACKAGE_NAME.PROCEDURE_NAME/'||p_itemKey);
but still i am not able to get this.

Any suggestion how to get this ??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2012
Added on Aug 25 2012
0 comments
735 views