Search This Blog

SBL-DAT-00290: No match was found for value '%1'.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.1 [18306] FIN
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Microsoft Windows 2000 Server SP 4

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

Symptoms

SBL-DAT-00290

Hi,

I want to default the Contact when any activity is created in the Call Report Action Items view. I referred to the Service Request #: 38-1026546791, Unable to pre-default the primary contact of a new activity with the one of the parent opportunity. Accordingly I changed the User Property of the Action Buscomp as follows:

Name: Contact MVG PreDefault Expression
Value:
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id', 'FINCORP Call Report.Primary Contact Id'

I am using the Primary Contact Id field in the FINCORP Call Report business component.

When I create a new record in the Call Report Action Item view when the Call Report has a Contact, the activity created defaults to the Contact and is fine. But if the Call Report does not have any Contact and I create and activity in the Call Report Action Item view I get an error, saying,

SBL-DAT-00290: No match was found for value '<?>'.

I am attaching the log file named, MVGError.log for your reference.

Note, I am using Siebel SIA 7.7.1.

Please let me know how to resolve this issue.

Thanks

Solution

Message 1

For the benefit of other readers:

The issue described by the customer is reproducible using a standard Siebel environment 7.7.1 SIA and the sample database. Here are the steps:

Using Tools:
====
1. Add the following BC user property in BC 'FINCORP Call Report Action':

Name: Contact MVG PreDefault Expression
Value: Parent: 'FINCORP Call Report.Primary Contact Id'

NOTE: 'Primary Contact Id' is the primary ID field of the following MVL in BC 'FINCORP Call Report':

Name: Contacts
Destination Business Component: FINCORP Call Report Contact
Destination Link: FINCORP Call Report/FINCORP Call Report Contact
Primary ID Field: Primary Contact Id

2. Recompile the BC

Using Siebel Financial Services application:
====
1. Go to Site Map > Call Reports > Action Items
2. Select a call report with at least 1 contact associated ("Contacts" MVF)
3. Create a new action item
> The primary contact of the call report is added to the "Last Name" MVF of the action item as expected

4. Select a call report that has no contact
5. Create a new action item
> You will get this error:
----
No match was found for value '<?>'.(SBL-DAT-00290)
----

Change Request # 12-OC00CI has been logged to address this product defect.

To workaround this issue the suggestion is the following:

(a) Add the following calculated field in BC 'FINCORP Call Report':

[...]

Message 2

[...]

Name: Contact Id Calc
Calculated Value: IIf([Primary Contact Id]='No Match Row Id', "", [Primary Contact Id])
Link Specification: TRUE (Checked)

(b) Change the Value of the user property 'Contact MVG PreDefault Expression' in BC 'FINCORP Call Report Action' to:

Parent: 'FINCORP Call Report.Contact Id Calc'

Additional information:
====
In the customer environment the view involved was customized. The child applet was based on BC 'Action' and not 'FINCORP Call Report Action'. The standard BC 'Action' has the following user property:

Name: Contact MVG PreDefault Expression
Value: Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id'

The suggestion to resolve their issue was therefore the following:

(a) Same steps as above

(b) Change the Value of the 'Contact MVG PreDefault Expression' user property in BC 'Action' to:

Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id', 'FINCORP Call Report.Contact Id Calc'

Silvere Torre
Siebel Technical Support


Applies to:

Siebel Tools - Version: 7.5.2.214 SIA [16066] to 8.1.1 SIA [21111] - Release: V7 to V8
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 8.1.7.3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: HP-UX 11i

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

Symptoms

SBL-DAT-00290

We have a problem with pre-defaulting contacts from the opportunity to the Activity applet in the Opportunity Detail - Activities View, when we create new activities under an Opportunity.

When we create an opportunity we associate one (or more) contacts to the opportunity. When the opportunity is created, we want to create activities related to this opportunity (in Opportunity Detail - Activities View). We also want to pre-default the contacts from the Opportunity to the created Activity.

Added the below user property to Action BC:

Name: Contact MVG PreDefault Expression
Value: Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id', 'Opportunity.FIN Contact Id'

The problem is, we have found occurrences that the contact name was not populating for the activity record. This behavior is inconsistent.

However, in these instances when we create the activity, the contact field looks NULL. However, when we click on the pick list icon, we notice that the contact is there. We close the pick applet and the contact shows up.

Cause

The issue is reproducible using a standard Siebel environment 7.5 SIA and the sample database. Here are the steps:

Using Tools:
====
In standard BC 'Action' the user property 'Contact MVG PreDefault Expression' has the following value:
----
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id'
----

> Change the value to the following an recompile the BC:
----
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id', 'Opportunity.Key Contact Id'
----

Using Siebel Financial Services application:
====
1. Go to Opportunities > Activities.
2. Select an opportunity with at least 1 contact associated ("Last Name" MVF).
3. Create a new activity:
> The "Last Name" and "First Name" fields of the activity are not defaulted

4. Open the "Contacts" MVG applet from the "Last Name" field of the activity:
> The appropriate contact record appears
> The "Last Name" and "First Name" fields of the activity are populated

If other activity records are created after that then the pre-defaulting occurs immediately as expected.

Solution

It was first suggested to change the 'Predefault Value' property of field 'Primary Contact Id' in BC 'Action'. The standard value is:
----
Parent: 'Contact.Id', 'Service Request.Contact Id'
----
It was to changed to:
----
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Opportunity.Key Contact Id'
----

This suggestion solves effectively the initial issue but causes another one. Indeed if the opportunity has no contact associated the following error occurs when creating an activity:
----
No match was found for value '<?>'.(SBL-DAT-00290)
----

To workaround this issue the suggestion is the following:

(a) In BC 'Opportunity':

- Add the following calculated field:

Name: Calc Key Contact Id
Calculated Value: IIf([Key Contact Id]='No Match Row Id', "", [Key Contact Id])
Link Specification: TRUE (Checked)

(b) In BC 'Action:

- Change the Value of the user property 'Contact MVG PreDefault Expression' to:
----
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Service Agreement.Contact Person Id', 'INS Claims Elements.FSA Contact Id', 'Opportunity.Calc Key Contact Id'
----

- Change the pre-default value of field 'Primary Contact Id' to:
----
Parent: 'Contact.Id', 'Service Request.Contact Id', 'Opportunity.Calc Key Contact Id'
----


Applies to:

Siebel Tools - Version: 7.5.3 [16157] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server

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

Symptoms

SBL-DAT-00290, SBL-DAT-00292

Hi,

We have an issue in Activity Form Applet --> Owner Field -->Pick Applet. Details given below:

Pick Applet : Activity Assigned To Pick Applet
Applet BC   : Employee

Employee BC has Popup visibility Set as "Organization" ( Which is Vanilla)

On Pick Applet we have added Applet User Property "Override Visibility: Siebel Sales Enterprise" with Value "All".

When User with Basic Responsibility (Basic responsibility is where Views with visibility Type "Sales Rep" are grouped)
logs in to system and when he Creates a new Activity , the Owner field is predefaulted with current user name,
and he invokes the "Owner Field" pick applet ( to change the owner value), due to our Applet User Property all Employee

values across Organization are displayed.

Now when user selects an Employee record which is outside the current logged in Users Organization, application throws an

error like :"No match was found for value <<row_id>> selected"
Note :

Based on our research, when we added "Employee List View" to the Basic responsibility, user is able to select Employee from outside his organization also.


1. Change done : User property to owner Pick Applet.
2. Log in with a user with Basic Responsibility.

Thanks,

Cause

Change request 12-K0SSHT

Solution

Message 1

For the benefit of other Readers :

The issue the customer was facing was

1) Login to Siebel Tools and set the "Override Visibility : Siebel Sales Enterprise " and value of "All" for "Activity Assigned to Pick Applet".

2) Compile the srf and relogin into "Siebel Sales" application as a user with basic "Sales Representative" Responsibility with no access to "All" views, the user creates a new "Activity" and clicks on the "Employee" control to select an employee from another organization, error pops up like "No match was found for value <<row_id>> selected".

Currently, the only workaround to this issue is to add the "Employee List View" from the view access list for the "Basic Responsibility" to avoid getting any errors.

In order to address this issue , a change request 12-K0SSHT has been logged.

Keywords : Activity Assigned To Pick Applet , Override Visibility , Organization , Basic Responsibility , Sales Representative

Siebel Technical Support


No comments:

Post a Comment