My Oracle Support Banner

"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 AUGUST 12, 2022

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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.