Thursday, October 22, 2015

how to make a form query only in oracle apps or oracle applications

Hi Everyone,                              This is one of the common requirement.They are many ways of doing this like form personalization ,Cutom.pll and others ..the easiest way to do it is by passing the parameter QUERY_ONLY="YES"  while creation Form Function.

But it doesn't gurantee all the forms will behave as expected because the form should be coded to make it work for this..not all standard forms have this..In HRMS Forms case there is another concept called task flow by which we can make the form read only.Steps:1.Check the form which need ot be made as query only.2.Go to the menu to which it is attached and the get the user function name of the form3.query the function from application developer(resp)-->application-->function

How to make a Oracle form 'Query Only'

There are many ways in which we can make a form Query only. We are going to discuss two
1) Using parameter QUERY_ONLY=YES
2) using Form Personalization
Method 1: Using parameter QUERY_ONLY=YES
Lets take an example of Purchase order enter form

Step 1) Using Sysadmin Responsibility find out the Menu attached to Purchasing Super User responsibility for which you want to make Purchase Order form as read only.

Step 2) Now Navigate to Application>Menu and query for this form and find out the form function associate with enter purchase order form. In our case it is "Purchase Orders"

Step 3) Create a new form function name having logically similar name as that of original function and in the form tab make QUERY_ONLY=YES

Step 4) Attach this new function in the place of old function to the same menu

Save and let Compile Security Request complete

Test ResultNavigate to Purchasing Super User> Purchase Order

See now this form is read only

Method 2 : Using Form Personalization

Step 1) Navigate to PO form>Help>Diagnostic>custom Code>Personalize

Step 2) Now here you can disable Update, Delete and Insert

Test Case : Check PO form now

No comments:

Post a Comment