Tuesday, January 2, 2018

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

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:

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...