Find out the Applied AD patches and Current Patch level in R12

To Find the Applied AD Patches

From Application

1. Login to Sysadmin

2. Navigate to the System Administrator->Oracle Applications Manager       ->Patching and Utilities

3. Then Search the patch with relevant parameter and click 'Go' Button

From SQL

1.

SELECT DISTINCT 
  e.patch_name Patch_NO, 
  d.patch_abstract Patch,
  e.CREATION_DATE Applied_Date
FROM 
  ad_patch_drivers d , 
  ad_applied_patches e 
WHERE 
  d.applied_patch_id = e.applied_patch_id
ORDER BY e.CREATION_DATE desc;

2.

SELECT DISTINCT 
  a.bug_number, 
  e.patch_name, 
  d.patch_abstract,
  e.CREATION_DATE,
  c.end_date, 
  b.applied_flag
FROM 
  ad_bugs a, 
  ad_patch_run_bugs b, 
  ad_patch_runs c, 
  ad_patch_drivers d , 
  ad_applied_patches e 
WHERE 
  a.bug_id = b.bug_id AND 
  b.patch_run_id = c.patch_run_id AND 
  c.patch_driver_id = d.patch_driver_id AND 
  d.applied_patch_id = e.applied_patch_id AND 
  b.applied_flag='Y'
order by e.CREATION_DATE desc

To Find The Current Patch Level

From Application
                
1. Login to Sysadmin

2. Navigate to the System Administrator->Oracle Applications Manager and     open one of Java Page

3. Click Support Cart –> Applications Signature –> Collect->Check “Product     Information” box and Click on “View” (eyeglasses) to run the patch set       level report 

From SQL 

SELECT 
  a.application_name, a.APPLICATION_SHORT_NAME,
  DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status, 
  patch_level 
FROM 
  apps.fnd_application_vl a,
  apps.fnd_product_installations b 
WHERE 
  a.application_id = b.application_id;

To Verify the Code Level

select * from fnd_product_installations where patch_level like '%AD%';

'Application Diagnostics is not a valid responsibility for the current user...' Error in R12.

Problem

When try to run Oracle Diagnostic the error prompt that  'Application Diagnostics is not a valid responsibility for the current user'

Solution

Must have one of the below roles to be assigned to the User to run Oracle Diagnostics.

• Diagnostics Super user
• Application Super user
• Application End User

1. Login to the system as Sysadmin User

2. Select the "User Management" responsibility

3. Click 'Users' in the right hand side menu

4. Enter 'User Name' and click 'Go'

5. Click 'Update' on the correct user

6. Click 'Assign Roles' button

7. Enter role name (or partial with %) you want to assign. You can enter any of the seeded roles (Diagnostics Super User Role, Application Super     User Role, Application End User Role), or your own one

8. Check the box before to the appropriate role and click 'Select' Button

9. Click 'Save' and 'Apply' Button.

10. Run Concurrent Program "Workflow Directory Services User/Role              Validation" with parameters 

         Batch Size - 100000

         Fix dangling users - Yes

         Add missing user/role assignments - Yes

         Update WHO columns in WF tables - No