This discussion is archived
4 Replies Latest reply: Dec 20, 2012 4:07 AM by SarojaKandepuneni RSS

FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE

885913 Newbie
Currently Being Moderated
Hi Experts,

Created a customized workflow that has 3 approvers going one after another, while received notification has found in home page with type and subject but from user is empty. All the approvers are generated by item_attribute not with roles can any one please help me on this issue that how to display the "*From_User*" name.

Thanks in advance,
Christ.
  • 1. Re: FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE
    SarojaKandepuneni Journeyer
    Currently Being Moderated
    You can set the from role when creating the process as below

    wf_engine.SetItemAttrText(<itemType>, <itemKey>, 'FROM_ROLE', '<FromUser>');

    <FromUser> -> is the name of the role/user which should be displayed for From role
  • 2. Re: FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE
    885913 Newbie
    Currently Being Moderated
    Thanks for the reply

    Depends on the project from users have been changed the how can i set the from user. Can you please provide the example for below syntax wf_engine.SetItemAttrText.
  • 3. Re: FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE
    885913 Newbie
    Currently Being Moderated
    i am facing the problem that in worklist of home page has workflow notifications in that for customized workflow notifications didn't get details for from column, remaining type and subject columns has been printed normallay. Can anyone please help me on this issue.
  • 4. Re: FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE
    SarojaKandepuneni Journeyer
    Currently Being Moderated
    For each workflow when launching the workflow process, set the from role value using wf_engine.SetItemAttrText() API

    eg: for launching a workflow

    declare
    l_itemType varchar2(50) ;
    l_itemKey varchar2(50);
    l_process varchar2(50);
    l_msg varchar2(50);
    l_rcpt varchar2(10);


    BEGIN


    wf_engine.CreateProcess(l_itemType, l_itemKey, 'PROC2');
    wf_engine.SetItemAttrText(l_itemType, l_itemKey, 'RECIPIENT', l_rcpt);
    wf_engine.SetItemOwner(l_itemType, l_itemKey, 'SYSADMIN');
    wf_engine.SetItemAttrText(l_itemType, l_itemKey, 'FROM_ROLE', 'PKUSER_B6702416_1'); -- To set FROM_ROLE role
    wf_engine.StartProcess(l_itemType, l_itemKey);
    COMMIT;


    end;

    or you can set FROM_ROLE when calling wf_engine.launchProcess() also


    There is also a special message attribute '#FROM_ROLE' which you can define in workflow to set 'FROM_ROLE' value

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points