Comparing Two Oracle Forms

1> Convert the fmb in txt and compare using any file comparing tool.
File -> Administration -> Object List Report  (It will create a txt file in the same directory)
Then Compare using any text comparing tool.
       OR
2> Another solution is to convert FMB(binary file) to FMT(Text file).
Open your forms, then choose menu File:Administration:Convert:Binary_to_text
This optin generate a Source Code in text format, do it with your files, then compare the files with a command like "diff" on linux, that list all differences line by line if exists

diff file://abhay/clients/forms/*.fmb file://abhay/clients/forms/*.fmb | more

Information to get the current session SQL statement execution details

Very often we need to know which SQL statement is running within a running concurrent program.Below SQL script can give you details of the same.

select vsq.sql_text
from  fnd_concurrent_requests fcr
       , V$PROCESS vp
       , V$SESSION vs
       , V$SQL vsq   
where fcr.request_id = :request_id
and  fcr.oracle_process_id=vp.spid
and  vs.sql_address = vsq.address    
and  vs.paddr=vp.ADDR ;

> You can also query the V$SQL table with Concurrent Program short name and can get all the SQLs   running.

Select vsq.sql_text
   from V$SQL vsq
 where  module = :Conc_prog_Short_name ;

> If you are using TOAD, you can also check the running Concurrent Program details in Schema browser.