Financial - JDE1 (MOSC)

MOSC Banner

R007032 report taking too much time

edited Aug 4, 2016 5:00AM in Financial - JDE1 (MOSC) 5 commentsAnswered

Dear Oracle ,

We run R007032 report quarterly for total data. It is taking tooo much time. Some times it is ending without conclusion.

The same report I have prepared an Oracle Query (given below) in SQL Developer. It is giving result in less than 2 minutes.

{

select a.* from

(

select glicut, glicu, sum(glaa/100) as glaa from f0911 where gllt = 'AA'

group by glicut, glicu

)a

where a.glaa <> 0

}

Kindly provide us solution.

thank you,

regards,

david raja

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center