Core Concurrent Processing - EBS (MOSC)

MOSC Banner

remove hold to a concurrent request

I have a FNDGSCST approx 8 records in fnd_concurrent_requests, where latest run time (of 8 records) has correct options to remove the hold flag , I did remove HOLD with below sql, do anyother one have better sql than this?


update applsys.fnd_concurrent_requests a set hold_flag = 'N' where phase_code = 'P' and status_code in ('Q','I') and exists (select 'x'

        from  applsys.fnd_concurrent_programs b

        where b.concurrent_program_id = a.concurrent_program_id

        and application_id = program_application_id

        and concurrent_program_name in ('FNDGSCST') ) and REQUEST_DATE like (SELECT MAX (fcr.REQUEST_DATE)

 FROM fnd_concurrent_requests     fcr,

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