In this Document
APPLIES TO:
Primavera Unifier - Version 10.0 and later
Primavera Unifier Cloud Service - Version 10.0 and later
Information in this document applies to any platform.
SYMPTOMS
When attempting to run a Custom Report built utilizing a Data View under the Company Level reporting tab, the following error occurs:
The system could not process your request.
Logging in again my help in some cases
Contact your System Administrator if you are still having problems.
CAUSE
Incorrect database syntax not supported by Oracle Database 12c
The Custom Report is failing to execute due to the Data View "data_view_name" which has failed to create. The Data View is using the SQL function "wm_concat" which is not documented or supported by Oracle. Oracle Database 12c is being used after migration and "wm_concat" is now failing.
SOLUTION
Replace the "wm_concat" function with "LISTAGG", which is an analytic function introduced in Oracle Database 11g Release 2 by performing the following steps:
- Change the impacted Data View to Draft status
- Modify the impacted SQL function
- Save the Data View and Publish it
- Click on the 'Data' button and verify that data is being returned as expected.
References:
https://oracle-base.com/articles/misc/string-aggregation-techniques#wm_concat
http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030
REFERENCES
http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030
