Tuesday 12 May 2020

How to make a responsibility read only in oracle apps r12

How to make a responsibility read only in oracle apps r12

In this post , We will be discuss about how to make a responsibility read only in oracle apps r12. Read only responsibility means , we will be provide the view only access in oracle apps application. In Read only responsibility , we cannot make any changes in the application data. We will only have the rights to inquiry the existing data in the oracle apps application. Read only responsibility required , when we want to provide the inquiry access rather then the complete access for application. We do create the read only responsibility usually for the marketing and  sales team which just want to inquiry the existing data from oracle apps for their day to day work but don't have the access to make any changes in the existing data. We will share the complete steps to make a responsibility read only in oracle apps r12. Here below is the detail about how to make a responsibility read only in oracle apps r12.

Step by Step to make a responsibility read only in oracle apps r12

Step1:- For Example , Here below is the Responsibility which have the Function 'Invoice'. Using this We can view and create the Invoices in Oracle Apps. We need to only create the View Only access. Now we need to Copy the Menu 'AP_NAVIGATE_GU12'.

 Menu =  'AP_NAVIGATE_GU12'.

Identify the menu that is attached to the responsibility, for example GL super user.

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

Step2 :- Navigation : System Administrator ==> Application ==> Menu

Query the Menu and then Copy the Name of Sub Menu 'AP_INVOICES_GUI12'

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12
Step3 :- Navigation : System Administrator ==> Application ==> Menu

Query the Menu and then Copy the Name of Sub Menu 'AP_INVOICES_ENTRY'

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

Identify the form functions that are attached to this menu as below 'Invoices'

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

How to make a responsibility read only in oracle apps r12

Step 4:-  Navigation : System Administrator ==> Application ==> Function

Now create a new form function exactly like the standard one but with the option

QUERY_ONLY="YES" in the location "Application"-->"function"-->"Form"-->"Parameter".
How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

This makes the function read only.

How to make a responsibility read only in oracle apps r12
How to make a responsibility read only in oracle apps r12

Step5 :-

Now create a new menu with these read-only functions and attach the menu to the new responsibility.

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *