Solved

manager

Posted on 2016-09-14
4
58 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Deny Oracle DBAs from Connecting  "/ as sysdba" 5 51
SQL Retrieve Values 4 55
PL/SQL Display based on value 4 17
use lov values 2 24
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

914 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now