How to Print XML Publisher report SQL and the values of the parameters

How to Print XML Publisher report SQL and the values of the parameters?

When we enabled the DebugFlag (P_DEBUG_FLAG) the log file will provides the following:

Ø  Begin and End time of the report

Ø  Time taken to execute report SQL and generate XML

Ø  Prints the report SQL and the values of the parameters.

How do I set the DebugFlag (P_DEBUG_FLAG)?

Set P_DEBUG_FLAG when P_DEBUG_FLAG is not already set for the report.

Navigate to System Administrator > Concurrent > Program > Define.

Ø  Search for the report (e.g., Account Analysis Report), "XLNBRPT" is the short name in the Concurrent Program window.

Ø  Click on Parameters button.

Ø  Move to the last parameter.

Ø  Add a new parameter called DebugFlag with the following:

ü  Sequence - 910 (If it exists, give a different number)

ü  Parameter- P_DEBUG_FLAG

ü  Description - DebugFlag

ü  Enabled - Check

ü  Value Set - XLA_SRS_NO_VALIDATION

ü  Default Type - Constant

ü  Default Value - Y

ü  Required - Uncheck

ü  Display - Check Prompt

ü  P_DEBUG_FLAG

ü  Token - DebugFlag (Case sensitive. Give this exact value)

Submit the report with P_DEBUG_FLAG as Y and the log file should include the report SQL.