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

865185

Any idea on this?

Jiri.Machotka-Oracle
Answer

See http://docs.oracle.com/cd/E23389_01/doc.11116/e21036/perf007.htm what caching params are available for otd.

Marked as Answer by 865185 · Sep 27 2020
865185

I didn't find the corresponding parameter in that link, maybe there is no function on that.

Thanks for the help!

1 - 3
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
748 views