Oracle sessions not visible when developing custom reports
                                                 Last update (2008-08-26 14:39:41)
                                                                                                                   Date added (2008-02-18 17:06:56)

Summary
You have to set some stuff to see the oracle session when developing concurrent requests at Oracle Applications.
1. Create a lexical parameter P_CONC_REQUEST_ID with the datatype Number.
2. In the ”Before Report Trigger” put  SRW.USER_EXIT('FND SRWINIT');
    for example:
function BeforeReport return boolean is
begin
  SRW.USER_EXIT('FND SRWINIT'); 
  return (TRUE);
end;
3. In the ”After Report Trigger” put SRW.USER_EXIT('FND SRWEXIT');
    for example:
function AfterReport return boolean is
begin
   SRW.USER_EXIT('FND SRWEXIT');
  return (TRUE);
end;
Related links
Running, pending requests
Reviews
Filters
Search