SAP Knowledge Base Article - Public

2623219 - Receiving java.sql.SQLException: ORA-00942: table or view does not exist when runnning default report on PRD


Customer exported a default report from LMS but is not able to preview it results on PRD;

Reproducing the Issue

  1. Open Plateau Report Design;
  2. Import default report from LMS by clicking Open Report Zip;
  3. Open Data set and try to click at Preview Results.
  4. Click view details when receiving the error message and search for "ORA-00942: table or view does not exist"


Submit an incident to Customer Support informing the Database URL you are using and the Default report name you have exported from LMS and is trying to preview results.


LMS, SAP, PRD, PLATEAU REPORT DESIGNER, ERROR RUNNING REPORT, PREVIEW RESULTS, table or view does not exist, ORA-00942 , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem


SAP SuccessFactors Learning all versions