Sales Rep BusComp View Mode in BC Service Request - Error Field 'ROW_STATUS' does not exist in definition for business component 'Service Request - Sales Rep - VisMvgSqlBCDef'. (Doc ID 510937.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.8.2 SIA [19213] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] PTG Com/Med
Database: Oracle 9.2.0.6
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Sun Solaris 9

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

Checked for relevance on 30-Oct-2014.
Checked for relevance on 1-Nov-2016.


Symptoms

In order to implement Sales Rep visibility based on Multi Position on Activities and Service Requests, the following steps were performed:

After performing the above steps, while creating a new record, an error occured:

Field 'ROW_STATUS' does not exist in definition for business component 'Service Request - Sales Rep - VisMvgSqlBCDef'. Please ask your systems administrator to check your application configuration.(SBL-DAT-00398)

This error was fixed by creating a new ROW_STATUS column on the intersection table and creating "Activity Row Status" field in BC Position pointing to that column.

On Service Request BC, the existing Sales Rep view Mode was changed to use the new MVL and MVF. With Service Request BC, the same problem still occurs. Creating a "Row Status" field in Position BC and tried with "Service Request Row Status" and it still errors out with the same message.

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