Step 1 : Find the function name of the form to create Query only form in EBS
Step 2 :Query the function name in System Admin --> Application --> Function
Function Name : FND_FNDSCAUS
Step 3 : To create new Read only function on the User form.... Copy the sanded function and modify custom name like "XX_FND_FNDSCRSP_VIEW" and go to FORM TAB parameter part give
Step 4: Now create new menu & responsibility and attach the function.
Step 2 :Query the function name in System Admin --> Application --> Function
Function Name : FND_FNDSCAUS
Step 3 : To create new Read only function on the User form.... Copy the sanded function and modify custom name like "XX_FND_FNDSCRSP_VIEW" and go to FORM TAB parameter part give
| QUERY_ONLY="YES" |
| FROM TAB |
Step 4: Now create new menu & responsibility and attach the function.
This comment has been removed by the author.
ReplyDeleteExcellent and informative article on implementing query-only forms in Oracle Applications. The step-by-step explanation makes it easier for Oracle EBS professionals to understand how to create read-only access while maintaining proper security and data integrity. The approach of customizing the function and applying the QUERY_ONLY parameter is a practical solution for controlling user access without affecting existing functionality. Thanks for sharing such a useful technical guide.
ReplyDeleteWheelchair Taxi Booking Perth
family transfer service
Control Room Communication