My Oracle Support Banner

Ora-06512 Error While Trying To Save Planning Parameters (Doc ID 1366326.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.2 to 6.2.4 - Release: 6.2 to 6.2
Information in this document applies to any platform.


On OTM version 6.2.2 installed on Windows the following arises:

Please note this is for clients using European settings for ',' and '.'

When trying to edit the planning parameter set and clicking finish, an ORA-06512 error about numeric being incorrect is displayed.

The numeric fields are correct but it seems that OTM is having issue with the decimal separator which is a coma "," instead of a dot "." on that instance.

The windows server regional settings are set to Spanish format (Numbers => 123.456.789,00).

In the database the decimal separator is a dot. Everything seems to work fine in the database. 

The user can update / create planning parameters directly in the database.

Also in the log it's showing a dot for those number fields e.g. PROCUREMENT SOLVER PERCENT OPTIMAL = 0.00
However in the UI, it's showing 0,00
If  the user changes it to 0.00 in the UI then there is no error on that parameter.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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