Need BI Reports runtime error details

Jagadeeswara

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Fujitsu

Description (Required):In case of bulk report failures we need a way to capture the report errors details from db table instead of opening and viewing log for each and every report.

Use Case and Business Need (Required):Need a report to view the BI report errors

Enhancement Request / Service Request: Enhancement Request

Jagadeeswara

We are expecting any report runtime errors to be inserted into any table.

Examples:

1. Single row subquery returns more than one row.

2. [nQSError: 17012] Bulk fetch failed. [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation at OCI call OCIStmtFetch.

This is required to see the report error details in a custom report as a part of monitoring.

Please find attached data model catalog for generating the error status runtime reports. But we are expecting the error reason from the DB tables. 

Thanks,

Jagadeeswara

HCM_BI_JOB_HISTORY_V2_DM.xdm.zip