Tuesday 9 February 2016

How to create Query only form in oracle apps

Step 1 : Find the function name of the form to create Query only form in EBS



Step 2 :Query the function name in System Admin --> Application --> Function

Function Name : FND_FNDSCAUS



Step 3 : To create new Read only function on the User form.... Copy the sanded function and modify custom name like "XX_FND_FNDSCRSP_VIEW" and go to FORM TAB parameter part give
QUERY_ONLY="YES"



FROM TAB
 

Step 4: Now create new menu & responsibility and attach the function.


Monday 1 February 2016

How to to find out the existing version for Oracle GRC

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;


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;

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;