How to get correct request ID in post-processing action
We have a post-processing action written in PL/SQL that begins with:
v_request_id := fnd_global.conc_request_id;
pc_debug(v_procname,'(+)' || p_step || ',' || v_request_id, fnd_log_procedure);
The debug information appears in the log file as:
(DBG)p_post_process (+)1,179079376
However, this is not the correct request ID. This is an earlier (lower) request ID.
The same log indicates the correct request ID as 179079391 in the post processing section.
+------------- 2) PLSQL -------------+
Executing PL/SQL. (REQUEST ID=179079391) (STEP ID=1)
PL/SQL completed with return code of: 0
PL/SQL completed with the following message:
0