SBL-DAT-00590 Error While Trying to Pick A Value For A Picklist Field
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 18.104.22.168 SIA  and later
Information in this document applies to any platform.
Checked for Relevance on 15-Mar-2013
Checked for Relevance on 03-Nov-2015
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms