We can find current execution stage of any PL/SQL code from table GV$SQLTEXT_WITH_NEWLINES but we need its session ID. If that PL/SQL code belongs to… Read More »Long Running Programs – SQL Query to Find Current Execution Stage of a Concurrent Request
SELECT fcr.request_id , fcpt.user_concurrent_program_name || NVL2(fcr.description, ‘ (‘ || fcr.description || ‘)’, NULL) conc_prog , fu.user_name requestor , fu.description requested_by , fu.email_address , frt.responsibility_name requested_by_resp… Read More »SQL Query to Find Scheduled Concurrent Programs List
/******************************************************* *PURPOSE: SQL Query to find DFF Structure from backend* *AUTHOR: Shailender Thallam * *******************************************************/ SELECT apps.application_name "Application", d_flex.title "DFF Title", d_flex.application_table_name "Table Name", d_flex.context_user_override_flag… Read More »SQL Query to Find DFF Structure from backend
/******************************************** *PURPOSE: To Delete Lookup or Lookup Code * *AUTHOR: Shailender Thallam * *********************************************/ SET serveroutput ON; — DECLARE CURSOR cur_lkp_values IS SELECT lookup_type,… Read More »PL/SQL Script to Delete Lookup or Lookup Code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /************************************************************ *PURPOSE: To change/reset… Read More »PL/SQL Script to Reset User Password from Backend
/******************************************************************************** *PURPOSE: To delete concurrent program definition and executable from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON; DECLARE l_prog_short_name VARCHAR2 (240);… Read More »Script to Delete Concurrent Program and Executable from backend
/********************************************************* *PURPOSE: Query to list all DB Links in a database * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT obj.object_type "Object Type", obj.owner "Object Owner", obj.object_name… Read More »SQL Query to list all DB Links in a database
We can use the same fnd_request.submit_request API which we use to submit a program for scheduling a program too. The only difference is the value… Read More »How to Schedule a concurrent program from Backend
While working on interfaces we face some requirements like submitting a concurrent program sequentially one after the other. In some scenarios we need to submit… Read More »How to make a Concurrent Program WAIT untill completion of another Concurrent Program execution?
/********************************************************* *PURPOSE: To find out profile option Values * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT DISTINCT POT.PROFILE_OPTION_NAME "PROFILE_CODE" , POT.USER_PROFILE_OPTION_NAME "PROFILE_NAME" , DECODE (a.profile_option_value ,… Read More »SQL Query to findout Profile Option Values