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
Some times we might end up in a situation to delete Data Definition and Template but interestingly oracle doesn’t provide the option to delete.. As… Read More »How to Delete XML Publisher Definition and Template
ICX_PARAMETERS table helps us to find out the application URL. SELECT home_url FROM icx_parameters;SELECT home_url FROM icx_parameters; We can also get the application URL from… Read More »To Findout Oracle Application URL from Database
Method I : ‘ADIDENT’ utility To find out a file version, oracle have provided ‘ADIDENT’ utility (AD Identification). This is an oracle apps based utility.… Read More »How to find report/package file version in Oracle Apps
/********************************************************* *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