OBP Data In Dashboard Is Not Appearing
(Doc ID 2965941.1)
Last updated on AUGUST 07, 2023
Applies to:
Oracle Banking Payments - Version 14.7.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
R2 OBP14.7.0.1.0 :Data in Dashboard is not appearing
We have enabled dashboard for a user, we are able to view dashboard as soon as login but data within dashboard is missing.
As per as initial investigation we found that there is Oracle missing expression error while executing summary query.
SELECT COUNT(*) FROM ( SELECT NETWORK_CODE AS NETWORK_CODE,UNAUTHORIZED AS UNAUTHORIZED FROM PMVW_UNAUTH_DASHBOARD SUMMARYDSN WHERE DASHBOARD_USER='TESTUSER07' AND HOST_CODE='MBAE') WHERE = AND ROWNUM <= 26.
After where keyword condition is not proper.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OBPM
2. view the dashboard
3. Dashboard data are missing.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |