Home » Developer & Programmer » Reports & Discoverer » strange error (disc 10.1.2)
strange error [message #333875] Mon, 14 July 2008 13:17 Go to next message
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All
I created a custom folder and for this i wrote a query.My question the query that you create in the EUL must be reflected in the plus as well, but for some reason they are giving different number of records, any idead why its happening?

Re: strange error [message #334135 is a reply to message #333875] Tue, 15 July 2008 09:00 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
the query that you create in the EUL must be reflected in the plus as well

Sorry, what do you mean by this? "Plus" is that Discoverer Plus (contrary to Viewer) or is it SQL*Plus?

But, I guess it comes down to the fact that you have one query (select statement) and in various tools it gives different results, is that right?

If so, please check if you're running EXACT the same statement (no additional joins, where conditions, etc.) on the same database under the same user using the same session settings (NLS for example).

If that's all okay, then check if there are any views involved. Or Virtual Private Database. Or you're working on Apps/EBS with multi-org enabled. And probably there are some more potential reasons for this.

[Updated on: Tue, 15 July 2008 09:00]

Report message to a moderator

Previous Topic: Grouping reports by categories
Next Topic: OLE OBJECT to report various PDF documents
Goto Forum:

Current Time: Sat Aug 19 21:23:14 CDT 2017

Total time taken to generate the page: 0.31933 seconds