When using the OEM Reporting System you are limited to access the repository only (MGMT_VIEW). So, the solution is to grant select on schema.table_name to MGMT_VIEW.
You need give a read permission to MGMT_VIEW.
grant select on sysman.TABLE_NAME to MGMT_VIEW;
This will help you remove the error while reporting the data from OEM Information publisher.
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]
Tunning the SQL query
OR
Administration -> Runtime Configuration -> Properties -> SQL Query Timeout.
Change it from 600 to 1200.
Go to BI Publisher -> Administration->JDBC Connection
New->Data Model -> Upper Left ‘+’ icon -> SQL Query -> Data -> View -> Table View -> Save as Sample Data -> Top Right Save Data Model
Select Blank( Portrait ) -> Text Item ( for Header ) -> Drag “Data Table” -> Save ( Top Right ) -> Done
New -> Report Job ->Select a report to schedule …..
Make DBA Life Easy 