Tuesday, 20 September 2016

How to find Oracle GRC - AACG/CCG and PCG version And Patch level

GOAL

How to to find out the existing version for Oracle GRC - AACG/CCG/PCG products applications ?

SOLUTION

A) For AACG : 8.6.4.x and above releases

Front End:
- Login to the AACG Application
- Click on the Idle Icon on the right top corner
- a pop-up message will contains the version

                            Or

Backend :
- Run : select * from grc_sys_version;


For CCG : 5.5.x and above

Front End:
- Login to the CCG Application
- Click on Help > About Products
- Release Number will give you the version details, and the Patch history will give the list of critical patches which are applied on the instance

                     Or

Backend :
- Run : select * from am_product_patches order by patch_start_date desc; 


For PCG : 7.x and above

Front End:
- Login to the EBS Application
- GRC Controls Responsibility, Navigator select Administration, and then Install History. 

                        Or 

Backend :
- Run : select * from la_install_history order by install_time desc;

No comments:

Post a Comment