OEM BI Publisher : SQL query time exceeds the limit (600 sec). Stopped processing

Waiting Time: 0.7 seconds
Data Fetch Time: 9.8 minutes
Total Execution Time: 9.9 minutes
Job Priority: Normal

Waiting Time: 0.7 seconds
Data Fetch Time: 9.8 minutes
Total Execution Time: 9.9 minutes
Job Priority: Normal
SQL query time exceeds the limit (600 sec). Stopped processing.
[INSTANCE_ID=bip.BIP3]

WORKAROUND

Tunning the SQL query

OR

Administration -> Runtime Configuration -> Properties -> SQL Query Timeout.

Change it from 600 to 1200.