Wednesday, 30 January 2013

How to Create Global Temporary Tables


CREATE GLOBAL TEMPORARY TABLE temp_table (
  column1  NUMBER,
  column2  NUMBER
) ON COMMIT DELETE ROWS;

Wednesday, 23 January 2013

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)

Wednesday, 2 January 2013

How to Oracle Apps Forms compile in R12

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