SBL-DAT-00521: The value '%1' for field '%2' is required to be '%3'. Please enter a value that is '%4'.

Applies to:

Error Message Area:Data Manager - DAT
Version:Siebel 7.7

Purpose

This document is intended to provide cause and corrective action information about Siebel Error Message SBL-DAT-00521: The value '%1' for field '%2' is required to be '%3'. Please enter a value that is '%4'.

Scope

This document is informational and intended for any user.

SBL-DAT-00521: The value '%1' for field '%2' is required to be '%3'. Please enter a value that is '%4'.

Explanation

You have specified a field values that does not meet the validation defined for that field.

Corrective Action

Examine the value and the validation property of the field to understand the cause of the failure. In Siebel Tools, choose Business Component in the Object Explorer (OE). In the Object List Explorer (OBLE) select the appropriate business component. Choose Field in the OE. Find the appropriate field in the OBLE and examine the syntax in the Validation property. For more information, refer to Siebel Bookshelf version 7.5.3 > Siebel Developer’s Reference > Operators, Expressions, and Conditions > Calculated Field Values and Field Validation.

Applies to:

Siebel Loyalty Member Services Representative - Version: 7.8.2.5 SIA [19227] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Symptoms

Deleting a member that is associated with a server key which has its Number of Members field set to 0, will cause the following error:

The value '-1' for field 'Number of Members' is required to be '>=0'.

Please enter a value that is ' >= 0'.(SBL-DAT-00521)

Note that the member is deleted despite the message.

Additionally, the server key field is only going to have a zero value if the members were not created through the GUI. Please refer to Number of Members in Server Key Map not Updated when Members Loaded using EIM (Doc ID 509759.1)

Cause

Product Defect Change Request 12-1JX007X : Deleting a loyalty member associated with a server key raises error SBL-DAT-00521

Solution

To avoid the error message from being displayed, remove the value ">=0" from the Validation attribute on the "Number of Members" field of the "LOY Server Key Map" Business Component.

Applies to:

Siebel Tools - Version: 7.5.3 SIA [16157] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] Pub Sect
Database: Microsoft SQL Server 2000 SP 1
Application Server OS: Microsoft Windows 2000 Advanced Server SP 1
Database Server OS: Microsoft Windows 2000 Advanced Server SP 1

This document was previously published as Siebel SR 38-1162533511.

Symptoms

SBL-DAT-00521
Two issues:

1. Setting the Required Field:
In Opportunity Business Component, created two custom fields based on the extended columns in S_OPTY table.
Field1: LOV Type
Field2: Added Field User Prop - Name: Required ;Value: [Field1] = 'Accepted'

The following error is received when setting the value for Field1 = 'Accepted' and stepping off the record without entering any value in Field2:

'' is a required field. Please enter a value for the field. (SBL-DAT-00498)

2. Field Validation:
In Opportunity Business Component, created a custom field based on the extended column in S_OPTY table. After setting the validation : <= Today(), the following error message is received when setting the date > Today for this field:

The value " for field'<?>' is required to be '<?>'. Please enter a value that is '<?>'.(SBL-DAT-00521).

Both of these messages missing the important information like field name and are useless to the user.

Cause

Customer found the following :

1) A validation of <= Today() for a field on the opportunity Business Component gives the following error :

The value " for field'<?>' is required to be '<?>'. Please enter a value that is '<?>'.(SBL-DAT-00521).

2) The error message is displayed if a Business Component field is made required conditionally based on the other field. This is set at the Field User properties level as follows :

In the Opportunity preferred language code set the user property

Name : Required
Value : [Start Date] IS NOT NULL

And the error message is given as " is required field ..

Solution

The above behavior was reproducible in the standard Siebel application . A Change Request # 12-J99673 has been logged to address the above behavior.

The issue was tested in 7.5.3.4 SIA [16180] and for some reason issue was not reproduced anymore. It seems that this is already fixed in 7.5.3.4 SIA. It seems to be only reproducible in 7.5.3 SIA [16157]

The above CR has status Closed and substatus Not Applicable.

Keywords : Opportunity , Validation, ?, error message

Applies to:

Siebel Loyalty Customer Portal - Version: 8.1.1 [21112] - Release: V8
Information in this document applies to any platform.

Symptoms

Comments
--------
Error message The value '' for field '' is required to be '' (SBL-DAT-00521) is incomplete in Objectives if the current year is used.

Steps to repro:
- Create an objective with period equal to 2009 on the view Objectives > Retail Objective List.
- Create an activity on the view Objectives > Retail Objective List > Activities
- Change the period of the objective to 2010.
- On the view Objectives > Retail Objective List > Target Accounts, select an account and click on the button Commit.
- Once committed select the button Apply in the parent applet.

The value '' for field '' is required to be '' (SBL-DAT-00521) error occurs. The values are missing.

Cause

Comments
--------
The cause for this issue was determined to be a defect.


Comments
--------
Justified due to repro in-house

Solution

Comments
--------
CR#12-1WF6PQV has been raised for this issue. The FP targeted is for 8.1.1.3 and this is due for release in June 2010.

References

BUG:12-1WF6PQV - ERROR MESSAGE ON FIELD VALIDATION IS NOT DISPLAYED CORRECTLY.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] Auto
Database: Oracle 9.2.0.2
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-1189137811.

Symptoms

SBL-UIF-00299, SBL-DAT-00521

Hi,

We are using Siebel 7.5.3.2 eDealer Application in Standard Interactive Mode(Please note that this is a deviation and our Siebel TAM is aware of it).

On the Activities screen (GMNA DLM Activities Screen - eDealer, based on Action BC) there is a list applet at the top and a form applet at the bottom. Select a record in the list applet whose status is 'Active' and click the 'New' button. Following error message is displayed :

'Wrong field values or value types detected in field Planned Completion. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299)'

The message is also displayed when a record whose status is 'Active' is selected in the list applet and the Query button clicked in the form applet

Find enclosed the screenshot with the error message. Please note that the display format for the field 'Planned Completion' is 'Date TimeNoSec'

Also please find enclosed the Action BC sif and GMNA DLM Activity Form Applet (eDealer). This applet has been cloned from 'GM Activity Form Applet' which in turn has been cloned from vainlla applet 'Activity Form Applet'



Thanks

Solution

Message 1

DESCRIPTION:

When scrolling through records in SI mode application an error is shown.

SYMPTOMS:

'Wrong field values or value types detected in field Planned Completion. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299)'
(SBL-DAT-00521) The value '12/23/1998 14:24:00' for field 'Planned Completion' is required to be '>= [Planned]'.

Three unexpected issues are happening:
1.    Field validation should not fire when scrolling through records.
2.    Validation should not raise an error in this case because the validation rule is not broken
3.    The error message must show the correct time format like defined in the locale administration.

SOLUTION:

This error occurs only in SI mode applications and is caused by the Display Format setting of the Planned Completion field.
The error occurs when display format = Date TimeNoSec
The error does not occur when the display format is empty.


Change request 12-KMW612 has been logged: Field validation fires when scrolling throug records in SI mode


Siebel Technical Support