Error SBL-EAI-04451 as Product Configurator Stores Date Attributes Incorrectly if the System or Locale Settings use the "DD.MM.YYYY" Date Format (Doc ID 2082696.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Communications - Version 15.3 [IP2015] and later
Information in this document applies to any platform.

Symptoms

Incorrect behavior for Product attributes of DATE type. If the system or Locale settings uses the "DD.MM.YYYY" date format, the attribute is not saved correctly. The DD and MM values are switched each time the product is configured.

The issue can be reproduced as follow:

The application runs in ENU and locale date format is "DD.MM.YYYY".

Using the following Product structure:

New Attribute Definition: T_DATE (Date, FreeForm)
New Class definition T_CL
New Product definition T_PROD
Associate the class T_CL to the Product T_PROD

Scenario # 1:
1. Create an Order
2. add the T_PROD to the Order
3. Customize T_PROD and set the date as 01.12.2015
4. Save the record in order to close the Configurator
5. The date in the Line Items Attributes is NOT displayed correctly (12/01/2015)
6. customize T_PROD again and modify the date which is currently displayed as 12/01/2015 to 12.02.2015
7. The date in the Line Items Attributes is again NOT displayed correctly. It is switched to 02/12/2015

Scenario # 2:
1. Create an Order
2. add the T_PROD to the Order
3. Customize T_PROD
4. Set the attribute date as "27.01.2000" and Click Done
5. Check the attribute in Quote Item XA applet and its value appears as "01/27/2000"
6. Click on Customize again and below error is prompted:

Product - "T_PROD_1" Extended Attribute Modified: Extended Attribute - "T_Date"; Old Value = "01/27/2000"; New Value = ""

 

Scenario # 3:

1) Change the machines date format to English (UK) dd/mm/yyyy
2) Create an Attribute with Date as data type
3) create a product and include the attbute
4) Create a linked Item to get the Contact Date of Birth from Order Line Items
5) Create a constraint to set the Attribute with the date value
6) On selecting the Product in Line items, throws error "09/16/2015 is not a valid value for Value. (SBL-CFG-00162)""(SBL-EAI-04451). "

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