This discussion is archived
1 Reply Latest reply: Jul 9, 2013 6:33 AM by majid RSS

Reject Oracle iExpense Report through WF_NOTIFICATION.SetAttrText

majid Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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);

Legend

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