SAP Knowledge Base Article - Public

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

Symptom

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"

Resolution

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.

Keywords

LMS, SAP, PRD, PLATEAU REPORT DESIGNER, ERROR RUNNING REPORT, PREVIEW RESULTS, table or view does not exist, ORA-00942 , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , Plateau Report Designer , Problem

Product

SAP SuccessFactors Learning all versions