EBS : Oracle Forms Compilation Scripts in Oracle Apps (r12)

How to compile forms in Oracle Apps

Forms Compilation scripts

frmcmp_batch module=/oraTECHHARDS/oracle/PERSONAL/fs1/EBSapps/appl/au/12.0.0/forms/US/XX_AR_INV_FORM.fmb module_type=form output_file=/oraTECHHARDS/oracle/PERSONAL/fs1/EBSapps/appl/ap/12.0.0/forms/US/XX_AR_INV_FORM.fmx userid=apps/apps batch=no compile_all=special 

Steps:-

1) Deploy the .fmb in AU_TOP 

2) Compile the forms using above scripts to generate .fmx in the Custom_TOP (like XX, AP, AR).

=========================================================================

#Oracle Forms #Oracle Apps #EBS #Forms Compilation

EBS : WHEN-TAB-PAGE-CHANGED change code in oracle forms in Oracle Apps (r12)

Oracle Forms Code for TAB WHEN-TAB-PAGE-CHANGED

DECLARE

   v_tp_nm   VARCHAR2 (30);

   v_tp_id   tab_page;

   v_tp_lb   VARCHAR2 (30);

BEGIN

   v_tp_nm := GET_CANVAS_PROPERTY ('TECHHARDS_TABS', topmost_tab_page);---TECHHARDS_TABS is your tab canvas

   v_tp_id := FIND_TAB_PAGE (v_tp_nm);   --this is tab page which you just had clicked to activate

   v_tp_lb := GET_TAB_PAGE_PROPERTY (v_tp_id, label);

                        --you get the lable for that particular tab page here

--here is to check the page name and associate your auto-query options--

   IF v_tp_lb LIKE 'TechHards WB%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_KAB');

      EXECUTE_QUERY (no_validate);

   ELSIF v_tp_lb LIKE 'TechHards WB Pro%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_PAB');

      EXECUTE_QUERY (no_validate);

   ELSIF v_tp_lb LIKE 'TechHards WB Free%'

   THEN

      GO_BLOCK ('XX_TECHHARDS_DAB');

      EXECUTE_QUERY (no_validate);

   ELSE

      NULL;

   END IF;

END;

=========================================================================

#Oracle Forms #Oracle Apps #EBS #Forms Trigger #WHEN-TAB-PAGE-CHANGED