How to enable trace with bind variables for Concurrent Requests
                                                 Last update (2011-04-28 14:36:47)
                                                                                                                   Date added (2011-04-28 14:26:53)

Summary
You can enable trace with bind variables for the specific user that is running a concurrent request, for example the "Journal Import".

Enable tracing with bind variables for the concurrent request it is possible to see what value it takes the bind variable (:period_name) before it is inserted in the GL_JE_LINES!

How to
First we have to disable trace for the concurrent program (if it is set)
1. Login as SYSADMIN user
2. Go to -> System Administrator -> Concurrent : Program -> Define and Press F11
3. Enter the Concurrent Program Name (Eg. Journal Import) -> Press Ctrl + F11
4. DISABLE the check box "Enable Trace" above "Copy To" button. Click on Save and close the window.
Second we have to enable trace with bind variables for the specific user
1. Login as SYSADMIN user
2. Go to -> System Administrator -> Profile ->System
3. Search for the profile giving the values: 
   User = your_username,
   Profile = Initialization SQL Statement – Custom
4. after you find the profile, under user field enter the following:
   begin fnd_ctl.fnd_sess_ctl(",",'TRUE','TRUE','LOG','ALTER SESSION SET EVENTS="10046 TRACE NAME CONTEXT FOREVER, LEVEL 12" TRACEFILE_IDENTIFIER="[period_name]"');end;
5. Save the profile and run the request Journal import as user:your_username
Tip: How to enable trace for Concurrent Requests
Reviews
Filters
Search