How to find an AD patchset level ?

SQL> select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

PATCH_LEVEL
——————————
11i.AD.I

This query works for both 11i and R12 instance

How to merge two apps patches.

Merging apps patches will be useful when you want to reduce the downtime for patch application

Simple steps to merge two patches.

1. Download two required apps patches (pR12_xxxxx_Solaris.zip) and (P12_yyyyy_Solaris.zip).
2. Create one source directory (for e.g. src )
3. Unzip two apps patches into src directory.
4. Create one destination directory (for e.g. dest)
5. Source the Apps env and issue the following command.
   1. Perl <ad_top>/bin/admerge.pl –s src –d dest
6. Patch is merged and created u_merged.drv . Use this driver file for adpatch application