Application Engine - Reuse Flag

PeopleSoft Application Engine programs use bind variables in the SQL statements, but these variables are just PeopleSoft specific. When the statement is passed to the database it sends the statement with literal values. The only way to tell the application engine program to send the bind variables is by specifying the Re-Used flag for that statement that needs to use the bind variable.

If any customizations are performed, it is recommended that the Reuse Flag be set to “Yes” for all program steps.
Before

AE Trace

After

AE Trace




You can get detailed AE Trace as shown above by appending the tace flags in the process definition > options page.


-TRACE 384 - will give you the detail timing of the SQL.

 

0 comments: