Solved

manager

Posted on 2016-09-14
4
64 Views
Last Modified: 2016-10-31
We are using a 3.0 version of Reportsmith to access data in our ERP system. Our ERP is upgrading and going from Oracle 11 database to oracle 12. We are upgrading our Oracle Client on the pc from Oracle 11 to Oracle 12 as well. problem we have now encountered is that Oracle 12 client and Reportsmith 3.0 do not play well together. has anyone run into this issue and found a way around some of the problems...like RTrim and trying to concatenate 3 fields together (like first, middle, last name) into 1 field? R/S also doesn't like derived fields now that we are using oracle client 12. any help is greatly appreciated.
0
Comment
Question by:Julia T
  • 2
4 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 250 total points
ID: 41799728
I've never used or seen Reportsmith, but one approach you could consider that may help would be to create views in the Oracle12 database that do any trimming or concatenating or other formatting that you need, then any reports you need in Reportsmith can simply select the columns as the views present them.

Another advantage of this approach is:  if any of your reports need to join data from two or more tables (most reports from most ERP systems need to do this) the performance advantage of doing these joins in database views instead of in a reporting engine can be *VERY* significant.  This varies of course among reporting tools, ERP systems, and the particulars of your reports.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 41801130
use oracle  11 client again.
you can leave the database on oracle 12.

when upgrading, the oracle database is upgraded first and tested with the original clients
upgrading oracle clients is a separate step

some vendors actually check the version of the oracle client
and some go even further in issueing compatibilty warnings

reportsmith will not be using oracle 12 features, unless you upgrade that too to a version which does
using oracle 11 client on an oracle 12 database is fine in this case
0
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
ID: 41804848
you don't have to take my word for it ...
take oracle's :http://docs.oracle.com/database/121/UPGRD/app.htm#UPGRD12541

they state: the oracle database has to be an equal or higher version than the oracle client version

this setup matches that description:
oracle database = 12
oracle client = 11

it usually starts to get a problem when the client is 3 major releases different from the database release
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Export table into csv file in oracle 10 104
SQL Developer 6 49
Breakpoint doesn't stop in my variable 3 28
Input a SQl, output tables amd columns used in the SQL 19 35
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question