My Oracle Support Banner

A Product Constraint Rule Automatically Predefaults An Attribute Value To Today's Date (Doc ID 2507110.1)

Last updated on NOVEMBER 04, 2020

Applies to:

Siebel CRM - Version 16.13 [IP2016] and later
Information in this document applies to any platform.


On adding a Product Constraint on attribute, the attribute gets set to Today day by default. 

The issue can be reproduced at will with the following steps:

1) Create an Attribute Definition <A123>:
* Data Type = Date
* Domain Type = FreeForm

2) Create a new Product Class <A123>, and add the Attribute Definition <A123> to the class.

3) Create a new Product Definition <A123>, and add the Product Class <A123> to the product.

4) Validate the product. Observe that the attribute value is empty and it is possible to fill in any date, e.g. "01.01.2019".

5) Add a new Constraint Rule:
* Constraint Name: Constraint attribute value
* Rule: The attribute A123 > 01.01.2019

Validate the product again. Observe that the default value of the attribute has been set to today.



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.