Saturday 5 August 2023

How to make a form read only in oracle forms Using Form Function Registration in EBS R12

 

How to make a form read only in oracle forms Using Form Function Registration in EBS R12

In this post, we will be discussing about, how to make a form read only in oracle forms using Form Function. 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 CUSTOM Form (Employee Master) a read only for some users.

 Go to that Form as below.

How to make a form read only in oracle forms

 Go to Help => About Oracle Applications for find the form Name

 

  

Step 2) Now We need to go to the Application Developer > Application> Function

and query for this Custom form (XXCUS_PAY_EMPLOYEE_MASTER) and find out the form function associate with enter XXCUS_PAY_EMPLOYEE_MASTER form.

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 (XXCUS_PAY_EMPLOYEE_MASTER_V) 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 ‘XXCUS_PAY_EMPLOYEE_MASTER_V.

 


How to make a form read only in oracle forms

 

In Form Function > Click on the Form Tab and Then Choose the Function (XXCUS_PAY_EMPLOYEE_MASTER_V)

And then choose the Form Tab (XXCUS_PAY_EMPLOYEE_MASTER) Main form which we want to make View Only

And Parameter Tab write the query (QUERY_ONLY=YES)

 

Step4:- Now, We need to go the Responsibility Menu under which we want to Attach this new function.

 

Wright the Prompt : Texmaco Element Master View Only and Choose  the Function (XXCUS_PAY_EMPLOYEE_MASTER_V)

And Description (Texmaco Element Master View Only)

 




Step5:- As below , Now our Employee Master form is showing read only.

 



 


No comments:

Post a Comment

How to Load a .csv file into Oracle Custom Forms via Push Button - EBS R12. How to upload file using Oracle Form

Here we create a form and add the button (File Location) and when the button is pressed, you will select a file such as ''Danish_Att...