4 Replies Latest reply: Dec 20, 2012 6:07 AM by SarojaKandepuneni RSS

    FROM USER IS NULL FOR NOTIFICATION IN HOME PAGE

    885913
      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
          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
            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
              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
                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