Error "Not a number:For input string:' ####%' " Project Template Adhoc Report in Instantis EnterpriseTrack

(Doc ID 2302221.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Instantis EnterpriseTrack - Version 16.1.0.0 to 17.2 [Release 16.1 to 17.2]
Instantis EnterpriseTrack Cloud Service - Version 16.1.0.0 to 17.2 [Release 16.1 to 17.2]
Information in this document applies to any platform.

Symptoms

When attempting to Run the Project Template Adhoc report as Admin (specific Login ID it_admin18), the following error occurs.

ERROR


Internal Error...
Ad-hoc report error: Failed while executing Ad-hoc Report: Not a number:For input string:"####%"  (NOTE: Actual Numbers are replaced with the symbol, the field should have some numbers in it.)

VDB Informaiton:
Not a number: For input string: "####%" in expression [
(value != "") ? formatdecimal(value, number_format) : ""] in function /report/adhocreports/ar_utils/formatFloatForReport in expression [


STEPS to Verify issue

1. Administrative user imports project update including custom field data for float field with a "%" character in the field (No error in validation of project update)
2. User with permission to run reports navigates to Adhoc reports and launches "Project Template" Adhoc report
3. Report fails with internal error

Changes

 Data Upload of "Project Update" recently completed without error.

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