2238875 - Connecting to Oracle from Crystal Reports

• Error when connecting to Oracle.
• Issue reporting off Oracle in Crystal Reports.
• Problems connecting to Oracle from Crystal Reports.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
     
• SAP Crystal Reports for Enterprise 4.1
• SAP Crystal Reports for Enterprise 4.2
• SAP Crystal Reports for Enterprise 4.3
     
• Oracle 11g
• Oracle 12c
• Oracle 18c
• Oracle 19c

• Below is a list of common issues connecting to Oracle from:
• Crystal Reports, and
• Crystal Reports for Enterprise
       
                 
• For Crystal Reports
              
• Generic Connectivity and Configuration:
      
• 2384904 - Does Crystal Reports supports Oracle 12c , 18c and 19c?        
• 1752459 - Oracle Server connection missing in Crystal Reports   
• 1337708 - Crystal Reports support of 64 bit Operating Systems   
• 1217820 - Registry settings to configure ODBC database drivers and SQL Syntax joins   
• 1432328 - Schema tables do not appear in the Database Expert when connecting to Oracle 11g through ODBC driver  
• 1850017 - Error: 'ORA-12505' when creating a JDBC connection based on Oracle database    
• 1698249 - Error: 'Failed to open the connection' when refreshing a report based off a universe using Oracle JDBC   
• 1688743 - Error: 'Failed to load database information', when scheduling or viewing reports based off Oracle   
• 1197846 - Error: 'Database Connector Error:'HY000:[Oracle][ODBC][Ora]ORA-01456: May not perform insert/delete/update'  
           
    
• Oracle Stored Procedures:
       
• 1181947 - Oracle Stored Procedures Requirements for Crystal Reports  
• 1822696 - Poor performance when reporting off an Oracle Stored Procedure in Crystal Reports  
• 2169139 - Oracle OLE DB Provider support for Stored Procedures in Crystal Reports (ORA -06550)  
• 1569938 - No data or incomplete data set, when reporting off an Oracle View, Stored Procedure, or Command Object  
• 1574554 - Error: 'Invalid argument type' when refreshing a report based off an Oracle Stored Procedure
• 1569990 - Error: 'Failed to Retrieve Data from Database ORA-06550' when adding an Oracle Stored Procedure   
• 2140646 - Error: 'Failed to retrieve data from the database. ORA-00942' when connecting to an Oracle 12c Stored Procedure 
• 1544128 - Error: 'Failed to retrieve data from database. ORA-06550 PLS-00103: Encountered ... " while reporting off a Universe based off an Oracle Stored Procedure     
     
              
• Incorrect behavior:
      
• 1680608 - Crystal Reports against Oracle database takes a long time to refresh         
• 2005553 - Crystal Reports does not display Oracle Unicode data correctly     
• 1206647 - Does Crystal Reports support Oracle TIMESTAMP data type fields?     
• 1205489 - Mixed or incorrect data in Crystal reports that use Oracle Long fields   
• 1843192 - Report based on an Oracle View returns wrong data   
• 1839148 - Crystal Reports based on Oracle takes a long time to execute     
• 1415792 - Crystal Reports return incorrect result when reporting against Oracle    
• 1906004 - Error: 'Oracle tnsnames entry not found', when viewing a report based on Universe in SAP BI LaunchPad  
• 1626943 - Error: 'ORA-00942 Table or View does not exist' on a report based on Business Views based on Oracle
      
    
• Known Defects: 
     
• 1339862  - Reports slow to render with multiple subreports and Native Oracle driver   
• 1702608 - Wildcard character not working for Oracle database in Crystal Reports    
• 1202730  - Oracle database connectivity issues when installing Crystal Reports 2008 on a 64-bit Windows platform
           
            
• How to:
    
• 2017430 - How to add Oracle hint in Crystal Reports?  
• 1204190 - Size limitation of an Oracle CLOB field in Crystal Reports
• 1517132 - Timestamp is included in the input parameter inspite of the parameter being Date type in Crystal Report based on Oracle stored Procedure.
      
              
• For Crystal Reports for Enterprise
        
• 2147860 - Search in Crystal Reports for Enterprise LOV prompt is case-sensitive for reports connected to Oracle
• 2166471 - Error: 'The data source 'Oracle 12' is not suported' when attempting to connect to an Oracle 12c  
• 2169341 - Error: 'Java Class not found in classpath : oracle.jdbc.OracleDriver' when creating a universe connection using an Oracle JDBC driver  

KBA , crystal reports , connectivity , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020