Friday, 18 August 2017
Useful Scripts and Queries

Query to get current executing statement in concurrent program

SELECT va.sql_text
,va.module
FROM APPS.fnd_concurrent_requests fcr
,V$SESSION vs
,V$SQLAREA va
WHERE fcr.oracle_session_id = vs.audsid
AND vs.sql_hash_value = va.hash_value
AND fcr.request_id = <request_id>;

Leave a Reply