Home » Developer & Programmer » Reports & Discoverer » Oracle ap invoice aging report custom one (Oracle erp 12.1.3)
Oracle ap invoice aging report custom one [message #681197] Wed, 24 June 2020 14:21 Go to next message
Messages: 1
Registered: June 2020
Junior Member
Hi Team,

From.past few days i have been struggling with a custom invoice ap aging 12 buckets report which has as of date parameter and which ran fine till 31st march 2020 in our production successfully. The report was developed in 2016 and since then its a monthly run and no issues encountered. There are no changes to it lately and it suddenly stucking and running for hours and hours since 30th apr 2020. The report is rdf but layout is xml for 12 buckets. This is seriously troubling us and did all we can do. Still no clue.
Any help would be greatly appreciated.
Re: Oracle ap invoice aging report custom one [message #681207 is a reply to message #681197] Thu, 25 June 2020 14:46 Go to previous message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If report wasn't modified, did something happen to data? For example, did someone drop indexes? When did you last gather statistics on tables involved? If you take report's query out and paste it to SQL*Plus (or SQL Developer or TOAD or whichever tool you use) and check explain plan, what does it say?
Previous Topic: Hide user name , password and database name
Next Topic: adding & before parameter name in data model
Goto Forum:

Current Time: Mon May 27 23:59:07 CDT 2024