Oracle is coming up with some exciting features on “Concurrent Request” form in upcoming EBS 12.2.6 release. As per a discussion on MOS, An Oracle… Read More »A killer “Auto Refresh” option on Concurrent Request Window – New Features to Concurrent Request Form
/******************************************************************************** *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
Click on the question to see the answer Basic SQL Interview Questions Can we use a WHERE clause in TRUNCATE statement? What is the difference… Read More »Top SQL Interview Questions with Answers
Click on the question to see the answer AOL and Sysadmin Interview Questions Can we give file extensions in executable file name? What is the… Read More »Top AOL and Sysadmin Interview Questions with Answers
We can find values of System global values using FND_PROFILE and FND_GLOBAL FND_PROFILE To manipulate values stored in client and server user profile caches.Any changes… Read More »FND_GLOBAL and FND_PROFILE: Import List of System Global values
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
This is yet another post for Oracle Apps beginners! Difference 1 Value sets can be attached to parameters of a concurrent program or to a… Read More »Difference between Valuesets and Lookups
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?
A unique session id is created at each sign on – so upon signing into the application, it will create a session_id. This session_id is… Read More »How to open multiple instances of same Form in same Session?