Oracle Apps – How to make a Form as READ ONLY

Follow the following steps inorder to make a form as Query only/Read Only.

1. Login into the System Administrator/Application Developer responsibility.
2. Navigate to ‘Security -> Responsibility -> Define’
3. Query for the responsibility for which you want to make the form as ‘Query Only’ and copy the ‘Menu’ name.
4. Navigate to ‘Application -> Menu’ and query with the menu name which we got in step 3 in ‘User Menu Name’
5. Now look out for the form (Prompt) you want to make it as query only. Copy the value in the ‘Function’ field w.r.t the form that needs to be made as ‘Query Only’.
6. Navigate to ‘Application -> Funtion’ and query with the function name we got in Step 5 in ‘User Function Name’ field.
7. Identify the correct Function for your form and then naviagate to the ‘Form’ tab.
8. Enter the value: QUERY_ONLY=YES in the parameters section in the Form tab, if you already have another value existing in the parameter form then you need to seperate them with a space..


13 thoughts on “Oracle Apps – How to make a Form as READ ONLY

  1. This is not the correct solution for “How to make a Form as READ ONLY”. This solution only controls “Querying” in the file. If QUERY_ONLY = YES then, you can’t create any new record within that form. You can only query the existing records. and if QUERY_ONLY = No then you can both query the old records and also create new records. The issue here is, how to restrict any user to only ‘read-only’ operation corresponding to any form. I think this can be done through form personalization, but, I’m not sure about the conditions.

    Thanks, Atul
    CTS, India


  2. Hi Shivmohan,

    Can you suggest how to disable the Bill to Check box which is coming in Add Customer function at Sales Order Form.



Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s