SBL-DAT-00590 Error While Trying to Pick A Value For A Picklist Field (Doc ID 1335003.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.4 SIA [21225] and later
Information in this document applies to any platform.
Checked for Relevance on 15-Mar-2013
Checked for Relevance on 03-Nov-2015

Symptoms

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"")"

ERROR
-----------------------
[1] An error occurred calculating the default value for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00412)
[2] Could not evaluate expression 'Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")"' for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00394)
[3] An error occurred while attempting to look up the LOV value of 'New Added' of type 'CAMPAIGN_STATUS_OUTCOME'.(SBL-DAT-00590)
[4] There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)


STEPS
-----------------------
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.

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