Core Concurrent Processing - EBS (MOSC)

MOSC Banner

How to disable/enable fnd concurrent programs using sql script?

edited January 2017 in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

Dear friends,

I have requirement to put on hold all the jobs and alerts scheduled in fnd concurrent programs using sql script?

Instead of doing it from front-end, Is there a way run update table query and disable them?

approx 100 jobs are configured in concurrent manager.

Select * from  apps.fnd_concurrent_programs

WHERE    application_id='XXX' and ENABLED_FLAG ='Y'

select * from apps.alr_alerts

WHERE ENABLED_FLAG='Y' AND CREATION_DATE  >= '1-JAN-2009' AND ALERT_NAME NOT LIKE '%ADP%'

Can someone help please......

Howdy, Stranger!

Log In

To view full details, sign in.

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