Procurement - EBS (MOSC)

MOSC Banner

Workflow notification API -- PR in InProcess state

edited Jul 13, 2016 5:03AM in Procurement - EBS (MOSC) 1 commentAnswered

Hi

I am trying to approve open notification using PL/SQL for PR.

steps involved as follows

1. call wf_notification.respond, wf_notification.respond

BEGIN

mo_global.set_policy_context('S', '104');

fnd_global.APPS_INITIALIZE (USER_ID=>3639, RESP_ID=>50898, RESP_APPL_ID=> 201);

   wf_notification.setattrtext (nid         => '2585399',

                                aname       => 'RESULT',

                                avalue      =>  'APPROVED'

                               );

   wf_notification.respond (nid         => '2585399',

                                     respond_comment =>  'approved note',

                                     responder =>  'POCONNOR');

   COMMIT;

END;

2. Run Workflow Background Process

still Purchase Requisition with same user with status 'InProcess' , not sent to next approver. when checked 'View approval through workflow', Approve Requisition Notification -- Closed to that performer and activity result is APPROVED.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center