"java.sql.BatchUpdateException: ORA-20000: The value must be numeric for a percentage ORA-06512" - Error Creating a New Parameter Sets

(Doc ID 2038002.1)

Last updated on OCTOBER 06, 2015

Applies to:

Oracle Transportation Management - Version 6.3.5 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.


Cannot copy an existing parameter set ID if one of its parameter values is configured as decimal.

An error occurred while copying the "Parameter Set" because of the fact that the system does not accept numerical values with comma as decimal separators.



Planning parameter set copy fails if planning parameter value is not in the form of percent. It works only if it is between 1 and 100, as well as integer. This is due to checks put in place in the trigger TG_PLANNING_PARAMETER_PCT_CK.

1. Shipment Management > Power Data > General > Parameter Sets

2. Copy DEFAULT parameter set with values is configured as decimal.

On finishing the new Parameter Set error occurs and the result is not saved.


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