donderdag 11 oktober 2012

EPMA patch 11.1.2.1.600 BUG! / parameter incorrect.


After the installation of a few new patches release by oracle :
  • 14224664 (EPMA)
  • 14119724 (BI+)
  • 14354419 (HFM)
  • 14142678 (HSS)

We came across some strange behavior within EPMA. We made a duplication of an excising application in the ‘application library’. All went okay and we did not see any errors.
But when we wanted to open the original application we got the following error:



We did check the Job console log for this job and found something ‘nice… yep A real Oracle bug. Within the  job log we can see the they did not made a copy of the database objects but a rename ?!?! guess it was a Monday morning when they had a test on this patch J.

Anyhow I made an SR at Oracle an development is now working on it.
Keep you posted. BUG number 14748197

donderdag 4 oktober 2012

Error executing query: java.lang.ArithmeticException: / by zerojava.lang.ArithmeticException

During some changes in security we came across some strange errors when attempting to load a Report.

Users could access the report but get an error when opening these reports.


Error executing query: java.lang.ArithmeticException: / by zerojava.lang.ArithmeticException 

Explanation:
The POV that the user set in FR Studio applies to all users automatically.  It  could be a security issue because some users do not have the correct security setting to access the POV. 


Solution:
Login to Workspace > Explore > File > Preferences > Financial Reporting > User Point of View > Preview. Make sure the "On" option is selected.