Patch Application Assistant ( in Oracle Apps R12

PAA (Patch Application Assistant) is tool/Perl script to generate customized installation instructions for a patch in Oracle Applications R12 which helps user to track and perform manual steps during patching.
1. is under $AD_TOP/bin

2. You can run (Patch Application Assistant) in two mode
i) GUI (Graphical User Interface)
ii) CLI (Command Line Interface)

3. Once you complete manual steps as instructed in PAA report, you can record that step as completed.

How to Run PAA (Patch Application Assistant) in R12

1.Source environment file i.e. $ORACLE_R12_BASE/ apps/ apps_st/ appl/ APPS[SID]_[hostname].env

2.Run PAA using in either CLI or GUI

2.1 CLI

perl -patch_top=[patch-top-directory]-appspass=[apps-password]

For example to generate PAA report for 12.0.6 patch (6728000) run it as  

perl $AD_TOP/bin/ -patch_top=/stage/ oracle/ patches/ r12/ 6728000 -appspass=apps

Gathering Information..
Logfile for this session is located at admsi.log
Generating installation instructions for patch 6728000..
Updating database….
install_6728000.html generated successfully
install_6728000.txt generated successfully

Now view report (text or html format) containing manual steps for 12.0.6


2.2 GUI

 Invoke PAA in GUI by running as shown below

Next step is to select from one of three options, I selected option 1 i.e. to find instance specific instructions for 12.0.6 patch (6728000)



3. Once you get list of manual steps, follow instructions in report

4. Apply apps patches using AUTOPATCH utility (adpatch)

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

paulinha says February 25, 2009

Hi Atul,
This post was very helpful, I had no idea how to use I’m having an error while running it, maybe you can help. I’m new to oracle so please bear with me. I’m applying patch 6728000 (RUP6) and when I run admsi I get the following error:

[applmgr@hufflepuff bin]$ perl -patch_top=/usr/paula/patches/6728000/ -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Unable to connect to PROD database.

The log file doesn’t help, it says the exact same thing and nothing more. I’ve searched the internet and Metalink and I can’t find the cause of the error. Do you know what’s the issue and how to solve it?

Thanks in advance,

Atul Kumar says February 25, 2009

Check your environment variable is set and apps password is correct.

– echo $TWO_TASK (this sould set same as SID)
– sqlplus apps/apps (where second apps is your apps password)

paulinha says February 25, 2009

It’s all correct… 🙁

Atul Kumar says February 25, 2009

Update output of

1. echo $TWO_TASK

2. sqlplus apps/apps

3. SQL> select instance_name from v$instance;

paulinha says February 25, 2009

1. applmgr@hufflepuff bin]$ echo $TWO_TASK

2. applmgr@hufflepuff bin]$ sqlplus apps/apps
SQL*Plus: Release – Production on Wed Feb 25 11:06:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release – Production
With the Partitioning, OLAP and Data Mining options

3. SQL> select instance_name from v$instance;

Atul Kumar says February 25, 2009



perl -patch_top=/usr/paula/patches/6728000 -appspass=apps

No forward slash after patch directory if this is still an issue raise as bug with Oracle

» Oracle Apps 11i/R12 AutoPatch adpatch / Online Apps DBA: One Stop Shop for Apps DBA’s says August 12, 2009

[…] to track and perform manual steps during patching (applicable for R12 only). More information here PAA Tool in R12 4. OAM – Oracle Application Manager (OAM) is web based tool to apply oracle apps […]

Imran says June 16, 2010

Atul! What a genius you are. I am novice to Oracle Apps and I have no access to metalink. While everyone else is pointing to metalink articles you described it in layman language which at least I understood. I salute you for all your contributions. Thank you.

kishore says July 19, 2012

Hi, Am The new to Apps DBA.

Why we need to run adgrants.sql ..??

Please Reply me.

rahil says February 11, 2015

Whenever iam trying to run

Iam getting error as follows:

Invoking Oracle Patch Application Assistant….
Please set the DISPLAY variable and re-run this script

Can anyone please help me how to solve this issue.

Atul Kumar says June 8, 2015

You need X server to run

Add Your Reply