Category Archives: Anonmys Scripts

Concurrent Program Scripts

Concurrent Program With Executable:

 Concurrent Request Details:

 

Related posts:

Current Running SQL for a Concurrent Program

Current Running SQL for a Concurrent Program

SELECT C.sql_text
,C.module
FROM APPS.fnd_concurrent_requests A
,V$SESSION B
,V$SQLAREA C
WHERE A.oracle_session_id = B.audsid
AND B.sql_hash_value = C.hash_value
AND A.request_id = <p_request_id>;

Pass the Request ID for the above Query.

SELECT SQLT.hash_value
,SQLT.sql_text
,VSES.username
,VSES.module
,VSES.command
FROM v$sqltext SQLT
,v$session VSES
,APPS.fnd_concurrent_requests FCONC
WHERE SQLT.hash_value = VSES.sql_hash_value
AND FCONC.oracle_session_id = VSES.audsid
AND FCONC.request_id = <p_request_id>
ORDER BY SQLT.piece

Related posts:

Trace File Location for Request ID

Below Query is used for fetching the Trace File location the server:

Thanks for Khadeer B for Providing the Query

Related posts:

Concurrent Program with Parameter Details

Below query is used to pull Concurrent Program, Parameters and from which Responsibility it can be Run.

Thanks Khadeer B for Providing the Query.

Related posts:

Query to Find Schema and its status

Query to list out the Schemas and the status of the products in Oracle Applications.


 

Related posts: