Technology Stack - EBS (MOSC)

MOSC Banner

Monitor pending standby and pending normal concurrent request

edited Dec 13, 2016 4:16PM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓

We are using EBS version 12.2.4

I want to write a script that monitors pending standby and pending normal concurrent request.

Say for example if pending standby and pending normal  together count up to more than 30, then it will send an alert for email for us to be aware of.

I tried the below query:

select count(*) from fnd_concurrent_requests where phase_code='P' and (status_code='C' or status_code='Q');

However, I am not sure why it also accounted for all the pending scheduled one. I do not need to account for the pending scheduled concurrent request.

Gurus, please advise. Thank you.

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