SBL-DAT-00590 Error While Trying to Pick A Value For A Picklist Field
(Doc ID 1335003.1)
Last updated on AUGUST 07, 2023
Applies to:Siebel Tools - Version 18.104.22.168 SIA  and later
Information in this document applies to any platform.
When attempting to create a new record in Campaign Applet in Asset > Campaign screen for the first time,
the following error occurs. These errors will happen for the first time only per session. For second time, "new" button it's ok and no error.
The problem in Campaign BC is with 'Call Status' field, which has predefault value= Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")"
 An error occurred calculating the default value for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00412)
 Could not evaluate expression 'Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")"' for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00394)
 An error occurred while attempting to look up the LOV value of 'New Added' of type 'CAMPAIGN_STATUS_OUTCOME'.(SBL-DAT-00590)
 There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)
The issue can be reproduced at will with the following steps:
1. Navigate to Asset > Campaign screen.
2. Click "new button" in Campaign Applet
3. The above mentioned errors occurs.
4. Again click on click "new button" in Campaign Applet. A new record will be created correctly.
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