Saturday 7 December 2013

How do we find the Current Form Function name in Oracle EBS 11i/R12

Form Name :






Form Name = CSTFITCT





Function Name :



Function Name = CST_CSTFITCT

Query to identify the form name base on function name

 SELECT   ff.FORM_NAME,
         ff.USER_FORM_NAME,
         ff.DESCRIPTION form_description,
         fff.FUNCTION_NAME,
         fff.USER_FUNCTION_NAME
  FROM   fnd_form_vl ff, FND_FORM_FUNCTIONS_VL fff
 WHERE   ff.FORM_ID = fff.FORM_ID AND ff.form_name = 'FROM_NAME' 

Global Variable FND_CUSTOM_FUNCTION_NAME stores the Current Function Name of the forms session.

1 comment:

  1. in a form, after I query a form which populates the data on the form. When I change in any of the field, and presee on refresh button, I am prompted with below standard message

    "Do you want to overwrite save your changes?" which has 3 options
             -------------------------------------------------- ---------------------
    "Yes" to save the record, the lock of changed record releases.
    "No" the screen goes back to the previous change, locked records goes into error without releasing the lock
    "Cancel" the goes back to the orginla screen without changing and, unlock the changed records

    I want to capture the return code of these 3 buttons . Is it possible

    ReplyDelete