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

By Enabling DebugFlag 
When DebugFlag (P_DEBUG_FLAG) is enabled, the log file 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)?
Complete the following steps to set P_DEBUG_FLAG. Do this only if P_DEBUG_FLAG is not already set for the report.

1. Navigate to System Administrator > Concurrent > Program > Define.

• Search for the report (for e.g., Account Analysis Report), "XLAAARPT" is the short name in the CP window.
• Click on Parameters button.
• Move to the last parameter.
• Add a new parameter called DebugFlag with the following:

• Seq - 910 (If it exists, give a different number)
• Parameter- P_DEBUG_FLAG
• Description - DebugFlag
• Enabled - Check
• ValueSet - 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)

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