We had recently upgraded our Siebel system from 7.5.3 to 8.1.1 and post the upgrade, the following error gave us a real tough time.
Error Description:- Join 'Organization Reporting Relationship Table Join Alias' in business component 'Recipients' has the multi-valued field 'Organization Id' as the source field. (SBL-DAT-00607)
Issue Resolution:-
Error Description:- Join 'Organization Reporting Relationship Table Join Alias' in business component 'Recipients' has the multi-valued field 'Organization Id' as the source field. (SBL-DAT-00607)
Issue Resolution:-I had searched the whole repository for the phrase 'Organization Reporting Relationship Table Join Alias' , but the results were zero. Then I decided to check the configuration of the Recipients BC, step by step.
In the 'Field' level, 'Organization Id' was created as a MV field with a link pointing to 'ABC Orgnaization'.
In the 'BusComp View Mode' of the Recipients BC, the Visibility was definied using the Organization Id field, but it was in the 'Visibility Field' column. I had to modify this view mode, by adding the 'Visibility MVL' to 'ABC Organization' and 'Visibility MVF' to 'Organization Id'.
After an incremental compile, it started working !!!
In the 'Field' level, 'Organization Id' was created as a MV field with a link pointing to 'ABC Orgnaization'.
In the 'BusComp View Mode' of the Recipients BC, the Visibility was definied using the Organization Id field, but it was in the 'Visibility Field' column. I had to modify this view mode, by adding the 'Visibility MVL' to 'ABC Organization' and 'Visibility MVF' to 'Organization Id'.
After an incremental compile, it started working !!!
3 comments:
Useful
Not working for me giving same message "Join '(SLA 2) S_PARTY' in business component 'Service Request' has the multi-valued field 'Country' as the source field. (SBL-DAT-00607)"
Thank you!
Post a Comment