/********************************************************* *PURPOSE: To findout blocking sessions and kill them * *AUTHOR: Shailender Thallam * **********************************************************/ — DECLARE CURSOR c IS SELECT c.owner, c.object_name, c.object_type, b.SID… Read More »PL/SQL script to find and Kill Blocking Sessions/Objects
Generally we use FND_REQUEST.SUBMIT_REQUEST to submit a concurrent program using a PL/SQL script. But we can not attach a layout to the concurrent request using… Read More »How to submitt XMLP Report using a PL/SQL Script
We can submit a concurrent request from backend using fnd_request.submit_request API. Before submitting the API we need to set the environment context using fnd_global.apps_initialize 1… Read More »PL/SQL Script to Submit a Concurrent Request from backend
We can not only create a concurrent program from backend but also assign the concurrent program to a Request Group by FND_PROGRAM.ADD_TO_GROUP api, below is… Read More »PL/SQL Script to Add a Concurrent Program to a Request Group from backend
We need to use FND_PROGRAM.PARAMETER api to create an concurrent program parameter from backend database, below is the sample script. Creating the Concurrent Program Parameter… Read More »PL/SQL Script to Create a Concurrent Program Parameter from backend
We need to use FND_PROGRAM.REGISTER api to create an concurrent program from backend database, below is the sample script. Creating the Concurrent Program from backend:… Read More »PL/SQL Script to Create a Concurrent Program from backend
We need to use FND_PROGRAM.EXECUTABLE api to create an executable from backend database, below is the sample script. Creating the Executable from backed: /************************************************** *PURPOSE:… Read More »PL/SQL Script to Create an Executable from backend
/********************************************************* *PURPOSE: To list physical path of APPL_TOPs in unix * * and its Parameters * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT variable_name, VALUE FROM… Read More »SQL Query to findout Application Tops unix physical path
/******************************************************************** *PURPOSE: To list information about Executable, Concurrent Program * * and its Parameters * *AUTHOR: Shailender Thallam * *********************************************************************/ SELECT DISTINCT fcpl.user_concurrent_program_name "Concurrent… Read More »SQL Query to findout Executable, Concurrent Program and its Parameters information
/********************************************************* *PURPOSE: To list information about the users who are * * loggedin in past 1 hour * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT DISTINCT… Read More »SQL Query to findout list of users connected to Oracle Apps Instance