Tuesday, 9 February 2016

How to create Query only form in oracle apps

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
QUERY_ONLY="YES"



FROM TAB
 

Step 4: Now create new menu & responsibility and attach the function.


1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete