Tuesday, December 22, 2009

Upgrade BUG - Default Date in prompt gives error

After upgrading from 10.1.3.3.1 to 10.1.3.4.1 we got a bug in BI where if a report is defaulted to date using any variables in prompt, the report will error out with error:


View Display Error

A date value was expected (received "2009-12-20 00:00:00.000").
Error Details
Error Codes: QABPH2PO

Oracle did acknowledge this as a bug (BUG 8599681 - DATE FORMAT ISSUE ON THE DASHBOARD PROMPT) and we had them create a patch for this, however even the patch had a bug. After patch installation the dashbaord will work if reposiroty variable is used in prompts to default a date prompt. However if we use session variable to default a prompt, the report throws same error.

No comments:

Post a Comment