Error: "A Numeric Value Was Expected Error Codes: EHWH2A7E" on Every Filter or Drill Over Numeric Values After Upgrade to OBIEE 10.1.3.4.1 (Doc ID 870113.1)

Last updated on JANUARY 06, 2014

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Answers, Interactive Dashboard - Version 10.1.3.4.1 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Information in this document applies to any platform.
This knowledge document is a replacement for 881690.1, which has been deleted.
This knowledge document is a replacement for 964520.1, which has been deleted.
This knowledge document is a replacement for 1286837.1, which has been deleted.

*** Checked for relevancy 1-6-14 ***


Symptoms

After upgrading to OBIEE 10.1.3.4.1, dashboards with numeric prompts, and Answers requests with filters over numeric values, are failing with error message:

View Display Error
A numeric value was expected (received "3").
Error Details
Error Codes: EHWH2A7E



Drill-down on calendar column shows a similar error message:

View Display Error
Error generating view. Error getting cursor in GenerateHead
Error Details
Error Codes: OAMP2OPY:EHWH2A7E
A numeric value was expected (received "4").



Exporting or downloading request results to Excel, HTML or PDF, gives the same error.
Note that the number in the double quotes in either error message does not have to be 3 or 4, any number might be displayed.

Changes

Upgrade to OBIEE 10.1.3.4.1.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms