Steps for compiling a form on UNIX

Steps for compiling a form on UNIX

1. Login into UNIX server

2. Set the environment for the respective instance. 
a.             Command for setting environment
b.            For ABC instance -> . /evnabc/erpapp/appl/APPSORA.env

3. PLL files are stored in the ‘Resource’ folder under AU TOP.

        a.    PLLs are in this folder -> /evnabc/erpapp/appl/au/12.0.0/resource
        b.    Forms are in folder -> /evnabc/erpapp/appl/au/12.0.0/forms/US

4. Command to compile the form -> frmcmp_batch module=<path with form name.fmb> userid=username/password output_file=<path with form name.fmx> Module_Type=FORM compile_all=Yes

        a. User name would be either APPS or the respective top name

If a form needs to be compiled on the local system then the short cut key is Ctrl+Shift+K and for generating fmx is Ctrl+T in Form Builder (10g).

Query to check business event fire status

Below query can be used to check Business events trigger status in oracle from database:

SELECT COUNT(1),

       a.msg_state, 

       a.user_data.event_name, 

       a.user_data.send_date

FROM applsys.aq$wf_deferred a

WHERE a.user_data.event_name LIKE 'oracle.apps.ont.oi.xml_int.status' --Business event name

AND a.user_data.send_date > SYSDATE - 1

GROUP BY a.msg_state, a.user_data.event_name, a.user_data.send_date

ORDER BY 1, 2 ;

Result:
Event Key passed: 1686010