What are Oracle Alerts?
Oracle Alert facilitates the flow of information within your organization by letting you create entities called alerts to monitor your business information and to notify you of the information you want.
What they are capable of?

Keep you informed of database exception conditions, as they occur.
Take predefined actions when it finds exceptions in your database, without user intervention.
Take the …

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 the sample script.
Adding a Concurrent Program to Request Group from backend:

DECLARE
l_program_short_name VARCHAR2 (200);
l_program_application VARCHAR2 (200);
l_request_group VARCHAR2 (200);
l_group_application VARCHAR2 …

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 from backend:

DECLARE
–
l_program_short_name VARCHAR2 (200);
l_application VARCHAR2 (200);
l_sequence …

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:

DECLARE
–
l_program VARCHAR2 (200);
l_application …

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:

DECLARE
–
l_executable VARCHAR2 (200);
l_application VARCHAR2 (200);
l_short_name …

/*********************************************************
*PURPOSE: To list physical path of APPL_TOPs in unix *
* and its Parameters *
*AUTHOR: Shailender Thallam …

Purpose of Learning Path:
A learning path is a catalog object that is used to group sequence of courses together and tracked as a whole. Learning path shows the way to achieve goals of a learner. Eg:- A new employee on board learning where the learner needs to complete a set of courses, by a relative targeted date (for example, 3 …

/********************************************************************
*PURPOSE: To list information about Executable, Concurrent Program *
* and its Parameters …

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 a techie we can achieve this from back end, here is a method to delete Data Definition and Template from back end.

SET SERVEROUTPUT ON
 
DECLARE
— Change the following two parameters
var_templateCode …

ICX_PARAMETERS table helps us to find out the application URL.

SELECT home_url FROM icx_parameters;

We can also get the application URL from profile option ‘Application Framework Agent’ which provides the host name and port number.

SELECT profile_option_value
FROM fnd_profile_option_values
WHERE profile_option_id =
(SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name =’APPS_FRAMEWORK_AGENT’
)
AND …

SELECT e.empno,
e.ename ,
e.deptno ,
d.dname
FROM emp e,
dept d
WHERE 1 = 1
AND e.deptno=d.deptno;

The above query gives the same result when WHERE condition e.deptno=d.deptno is replaced with d.deptno= e.deptno.

SELECT *
FROM emp
WHERE ename LIKE …

Oracle has provided an API UTL_SMTP which can be used to send email from PL/SQL. UTL_SMTP uses SMTP (Simple Mail Transfer Protocol) sever to send the emails. To know more about UTL_SMTP API read oracle documentation here.
Below is a sample code snippet to send email using UTL_SMTP API.

DECLARE
–
v_from VARCHAR2(80) := ‘noreply@OracleAppsDNA.com’;
v_recipient VARCHAR2(180) := ‘shailender.thallam@appsassociates.com’;
v_recipient2 VARCHAR2(180) := ‘shailender0435@gmail.com’;
v_subject VARCHAR2(180) := …

Method I : ‘ADIDENT’ utility
To find out a file version, oracle have provided ‘ADIDENT’ utility (AD Identification). This is an oracle apps based utility.
Syntax:- adident Header <file_name>
Eg:- adident Header OEXWFASG.rdf

Method II :’Strings’ utility
Strings is a UNIX based utility which is used to  print the strings of printable characters in files. We can use this utility to extract header information from …