We are on OBIEE version 1.1.7 having upgraded from version 1.1.5 and are getting the following behaviour
Reports coming from an Oracle database subject area will not return after being an object is changed. The reports return data unchanged.
Our support person can run and change the report in our UAT environment without an issue, but if it done in Production then report hangs
The only way to get the reports to run in Production is to copy the UAT explain plan into Production.
Any advice would be appreciated.