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 JULY 24, 2019

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.

Symptoms

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.

 
STEPS
-----------------------
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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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