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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.