1 Reply Latest reply: Jul 9, 2013 8:33 AM by majid RSS

    Reject Oracle iExpense Report through WF_NOTIFICATION.SetAttrText

    majid

      Dear Gurus,

       

      I have a huge number of iExpense Reports which are pending for the user approval. I am using the following code to Reject all such reports:

       

       

      begin

      wf_notification.setattrtext ( nid => :notification_id

                                      , aname => 'RESULT'

                                      , avalue => 'REJECT' ); 

          wf_notification.respond ( nid => :notification_id );

      commit;

          end;

       

      when I query the notification table after running the above code, the status of the notification is "CLOSED" but the expense report is still waiting for approval.Further more the user who created the report never gets to be notified that his report is rejected.

       

      Am I missing anything any help would be appreciated.

        • 1. Re: Reject Oracle iExpense Report through WF_NOTIFICATION.SetAttrText
          majid

          dear All ,

           

          I resolved the issue using the following :

           

          wf_notification.setattrtext ( nid => :notification_id

                                          , aname => 'RESULT'

                                          , avalue => 'REJECTED' ); 

                                          wf_notification.setattrtext ( nid => :notification_id

                                          , aname => 'WF_NOTE'

                                          , avalue => 'Auto Rejected as the BM is older than 30 days' ); 

              wf_notification.respond ( nid => :notification_id);