1) Check value of profile option :AR: Enable Debug Message Output, it should be set to Yes
2) Run the following select statement to determine where the log will write to :
select value from v$parameter where upper(name) = 'UTL_FILE_DIR'
this returns something like :
VALUE
--------------------------------------------------------------------------------
/usr/tmp, /usr/tmp, /u01/oracle/mc3yd213/db/tech_st/11.1.0/appsutil/outbound/mc3yd213_bej301441, /usr/tmp
The above is just an example, the values for your database may be different,take note of the values as you will need to supply it later.
3) In the application, once you are in the form that you want to debug,click on :
Help - Examine
fill in window that pops up :
block = PARAMETER
field = AR_DEBUG_FLAG
value = FS <utl_file_dir> <de