Siebel Web Client - Field Value Set Using SetFieldValue Method Is Truncated - The Decimal Part Is Missing (Doc ID 1900662.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.
Checked for Relevance on 01-Apr-2016

Symptoms

In our Siebel application we have eScript code thats set a specific field using SetFieldValue method:
- - -
var sSeasonFactor:String;
var nIndexValue:Number;

nIndexValue = ((ToNumber(sSeasonFactor)*ToNumber(Inputs.GetProperty("YearPlan")))/12);
SetFieldValue("Index Value2",(nIndexValue+0.00000000000001).toFixed(5));
- - -

We are facing an issue that we miss decimal precision when this code code is executed on the server, namely using Siebel web client. Using Siebel dedicated client it works fine.
For some reason Siebel saves the field value into DB as an integer without decimals.

This issue is observed with one server machine only. With other servers it works fine. Our Siebel application is in RUS language but the issue is observed whatever the value of the Language Code and Locale parameters set at OM or Siebel server level.

Cause

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