Error "Not a number:For input string:' ####%' " Project Template Adhoc Report in Instantis EnterpriseTrack
Last updated on SEPTEMBER 01, 2017
Applies to:Instantis EnterpriseTrack - Version 18.104.22.168 to 17.2 [Release 16.1 to 17.2]
Instantis EnterpriseTrack Cloud Service - Version 22.214.171.124 to 17.2 [Release 16.1 to 17.2]
Information in this document applies to any platform.
When attempting to Run the Project Template Adhoc report as Admin (specific Login ID it_admin18), the following error occurs.
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.)
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
Data Upload of "Project Update" recently completed without error.
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