Wednesday 1 April 2020

How to make a form read only in oracle forms

How to make a form read only in oracle forms


In this post, we will be discussing about, how to make a form read only in oracle forms. To make a form read only is very easy process in oracle apps. We just need to know that oracle form name, which we want to make read only. Then we can make the form ready only after doing some small change in the form registrations. We need to go to the Oracle Form registration, to make any form read only. Here below is the complete detail about how to make a form read only in oracle forms.

Step by Step to make a form read only in oracle forms


Step1: - For Example in Our Case, We want to make the Oracle Purchasing Form a read only for some users.
Go to that Form as below.
How to make a form read only in oracle forms
How to make a form read only in oracle forms

Go to Help => About Oracle Applications

How to make a form read only in oracle forms
How to make a form read only in oracle forms




Step 2) Now We need to go to the Application>Menu and query for this Standard form (PO_POXPOEPO) and find out the form function associate with enter purchase order form.
How to make a form read only in oracle forms
How to make a form read only in oracle forms

Step 3) Now we need to Create a new form function name for this same Form Name (PO_POXPOEPO) having logically similar name as that of original function and in the form, tab make QUERY_ONLY=YES
This New Form Function Name we have given ‘PO_POXPOEPO_V’.
 
How to make a form read only in oracle forms
How to make a form read only in oracle forms



Step4:- Now , We need to go the Responsibility Menu under which we want to Attach this new function.
How to make a form read only in oracle forms



Step5:- As below , Now our purchase order form is showing read only.
How to make a form read only in oracle forms




0 comments:

Post a Comment

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

Name

Email *

Message *