Home » Developer & Programmer » Reports & Discoverer » Data is not Fetching from Oracle Reports (6i)
Data is not Fetching from Oracle Reports [message #413504] Thu, 16 July 2009 02:44 Go to next message
siva_salapati
Messages: 7
Registered: August 2006
Junior Member
Hi All,

I am facing one issue for last few days.

I have developed on RDF and it is running fine in all the phases.

When ever any change happened in the DATA Model Main query, and if we run the new RDF then the report is not fetching the records and it is showing BLANK for all the records.

I just added the BIND variable condition to the DATA MODEL query, and it happens this way.

I also executed the main RDF before making the changes, then it is running fine with the records.

Pls. help me out in this issue. i hereby attached the outputs before and after the changes made.

Thanks so much in advance,
Siva.S
  • Attachment: 1_FNDWRR.pdf
    (Size: 48.46KB, Downloaded 223 times)
Re: Data is not Fetching from Oracle Reports [message #413518 is a reply to message #413504] Thu, 16 July 2009 04:17 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
just check your data query, is it fetching the data ???

There must be some user parameter or report trigger which is resulting in no records.

just check thoroughly.
Re: Data is not Fetching from Oracle Reports [message #413520 is a reply to message #413518] Thu, 16 July 2009 04:22 Go to previous messageGo to next message
siva_salapati
Messages: 7
Registered: August 2006
Junior Member
Hi,
I pulled the query and executed in PL/SQL developer.
It is fetching the records.

And also as i said, if i use my OLD rdf with out change any thing in the query then also it is returning the records.

Pls. find out the attached output after i made the changes in RDF.

i just added one condition say 1=1.


Thanks so much for your response.

Siva S
  • Attachment: FNDWRR.pdf
    (Size: 38.61KB, Downloaded 258 times)
Re: Data is not Fetching from Oracle Reports [message #413526 is a reply to message #413520] Thu, 16 July 2009 04:45 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
what version are you working in???
If you are in 6i, just connect your data model again and then try.

if still problem persists then do one thing, take a back up of your report and then do some hit and trial.
comment the code which you have altered or added , and then run the report. The moment where you get the data, just check/change the condition and your report will surely work.
Re: Data is not Fetching from Oracle Reports [message #413540 is a reply to message #413526] Thu, 16 July 2009 05:33 Go to previous messageGo to next message
siva_salapati
Messages: 7
Registered: August 2006
Junior Member
Hi,

I am using 6i version.

As you suggested, i commented the changes made in the query builder of data model and ran the RDF.

Still the same issue. I am not getting the data.

Even if i used the SPACE also the RDF wont working. If i ran the RDF that is in PROD with out making any changes then it is fetching data fine with out any issues.

Means, if we touch the Query then it is not working.

Thanks so much for your help.

SIva S
Re: Data is not Fetching from Oracle Reports [message #413560 is a reply to message #413540] Thu, 16 July 2009 07:37 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to compile all (Ctrl + Shift + K) before running the report?
Re: Data is not Fetching from Oracle Reports [message #413561 is a reply to message #413560] Thu, 16 July 2009 07:42 Go to previous messageGo to next message
siva_salapati
Messages: 7
Registered: August 2006
Junior Member
YES. I did.
Re: Data is not Fetching from Oracle Reports [message #417574 is a reply to message #413561] Mon, 10 August 2009 05:47 Go to previous message
nagu_bhat
Messages: 10
Registered: May 2009
Junior Member
Hi

Post your query

Regards
Nagaraj
Previous Topic: How to write Ref-Cursor Query in Oracle Reports
Next Topic: Reports 10G Spreadsheet output
Goto Forum:
  


Current Time: Wed Dec 07 22:43:16 CST 2016

Total time taken to generate the page: 0.08932 seconds