2140646 - Error: 'Failed to retrieve data from the database. Details: ORA-00942' when attempting to create a report off an Oracle 12c Stored Procedure in Crystal Reports

• Error: "Failed to retrieve data from the database. Details: ORA-00942: table or view does not exist [Database Vendor Code:942]"
• When attempting to report off some Oracle 12c Stored Procedure, it fails.
• Can successfully report off the same Stored Procedure on Oracle 11g.
• When attempting to report off Oracle 12c Stored Procedure defined in a package, using the Oracle Native connection in Crystal Reports, it fails with the error:
       
    "Failed to retrieve data from the database. Details: ORA-00942: table or view does not exist [Database Vendor Code:942]"
    
    
    
    
  Followed by the error:
   
    "Failed to retrieve data from the database. Details: Fail to execute SQL statement. OCI Call: OCIStmtExecute [Database Vendor Code: 942]"
    
      
    
   
     
• Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.  
    

• SAP Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
            
• Oracle 12c

Crystal Report 2008, Crystal Report 2011, Crystal Report 2013, Oracle 12c, Stored Procedure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem