Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Script to disable a Request Set in a Cloned APPS environment.

edited Jun 1, 2016 12:18AM in Core Concurrent Processing - EBS (MOSC) 11 commentsAnswered

I clone our production environment daily through a scripted process.

How would I script to cancel a request set?

Please advise.

Below is what I currently use to cancel our Concurrent Requests:

 

begin

declare

ret boolean;

v_message varchar2(2000);

cursor req is

        select r.request_id request_id,

        r.requested_by requested_by,

        r.responsibility_id responsibility_id,

        r.responsibility_application_id responsibility_application_id


        from fnd_concurrent_requests r,

        fnd_concurrent_programs_vl cp


        where r.concurrent_program_id = cp.concurrent_program_id

        and r.program_application_id = cp.application_id

        and cp.user_concurrent_program_name in ('

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