How to find all Form Personalization in Apps


SELECT FORM_ID, FORM_NAME,APPLICATION_NAME, FFV.USER_FORM_NAME, FFV.DESCRIPTION
FROM FND_FORM_VL FFV
    ,FND_APPLICATION_TL FAT
WHERE FFV.APPLICATION_ID=FAT.APPLICATION_ID
AND FORM_NAME IN
                (SELECT FORM_NAME --,FUNCTION_NAME, DESCRIPTION, TRIGGER_EVENT,  TRIGGER_OBJECT,CONDITION
                FROM FND_FORM_CUSTOM_RULES
                WHERE ENABLED='Y'
                GROUP BY FORM_NAME)

How to Oracle Apps Forms compile in R12.1.3 to R12.2.10

Oracle EBS Forms compile command

Open Putty :

su - apps

frmcmp_batch module=$AU_TOP/forms/US/XX_TEST.fmb module_type=form output_file=$XXCUST_TOP/forms/US/XX_TEST.fmx userid=apps/welcome batch=no compile_all=special

OR

frmcmp_batch userid=apps/welcome module=$AU_TOP/forms/US/XX_JGTEST.fmb module_type=form output_file=$INV_TOP/forms/US/XX_JGTEST.fmx batch=no compile_all=special