XML Data Template Table

Hi All,

XMLP data templates are stored in XDO_TEMPLATES_B table.

SELECT * FROM xdo_templates_b where template_code like 'XX%';

How To Insert Request Id into custom table?

you can use fnd_global.conc_request_id in the trigger.

Query to find Opened Forms details

Hi All,

This query will returns the details of last logged in forms details.....

 select ffv.user_form_name, ff.FUNCTION_ID, ff.FUNCTION_name
    ,to_char(flr.end_time,'dd-mon-yyyy hh24:mi:ss')  end_time
    , to_char(flr.start_time,'dd-mon-yyyy hh24:mi:ss')  start_time,
      (flr.end_time - flr.start_time)*24*60 duration
from apps.FND_LOGIN_RESP_FORMS flr,
apps.fnd_form_functions_vl ff,fnd_form_vl ffv
 where login_id in (select login_id
from apps.FND_LOGINS where user_id = 1311)
and flr.form_id = ff.form_id
and trunc(flr.start_time)=trunc(sysdate)
and  ((flr.end_time - flr.start_time)*24*60) > 1/20 -- 3 seconds
and ffv.form_id=ff.form_id
order by flr.start_time desc

Please note that It will display details when a form open and closed only. If you want to display opened form details also then comment below condition in that query.

and ((flr.end_time - flr.start_time)*24*60) > 1/20 -- 3 seconds