SBL-DAT-00376: There is no field for denormalized column '%1' from table definition '%2' defined in business component '%3'.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.2.1 [18353] Life Sci
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: HP-UX 11i

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

Symptoms

SBL-DAT-00376

Hi Support Web,

I have a requirement where a Manager can enter Time Off Territory for his sales Rep via 'My Teams Time off Territory' View. I have unchecked the read-only property for the Position field in BC so that the manager can select the Sales Rep's position in the My Teams View. This record is not visible in the Sales Rep's 'My Time off territory View'. It appears in the Managers My Teams and My Time off Territory View but not in the Rep's My View.

How can we enable this functionality? I have changed the View Visibility Applet Type but of no use.

A quick response is greatly appreciated.

Thanks,

Solution

Message 1

For the benefit of other readers :

Customer was facing the following issue which was also reproducible in sample database.

a) login into Siebel Tools and query for "Pharma Time Off Territory" BC.

    Activate the following fields :
    Employee First Name (MM), Employee Job Title (MM) , Employee Last Name (MM) , Employee Login Name (MM) .

b ) Expose the controls corresponding to those fields in "My Teams Time oFf Territory " view -> "Pharma Activity TOT List Applet".

c) In the List Applet "Pharma Activity TOT List Applet", add an MVG applet "Employee Mvg Applet" on the List Column 'Owned By'. Expose this List Column on the list Applet . Save and compile the changes .

d) Relogin into Siebel application and navigate to "Pharma Activity TOT List Applet "    , click on the "Owned By" field to invoke the MVG Applet and click on the "New" button to add a new record in the associate applet , you get an error
" There is no field for denormalized column APPT_REPT_END_DT from table definition 'S_ACT_EMP' defined in business component 'Pharma TimeOff Territory'.

Change request 12-XQRR9R was logged to address the issue of denormalized column errors . Normally when a Change request is logged , it is reviewed , prioritized and a fix is implemented in one of the future releases.

Message 2

The workaround which was provided was that the customer was asked to manually add all the denormalized columns in the Business Component "Pharma TimeOff Territory". Customer did the changes and was able to successfully associate Employees in the associate applet.

Thank you,
Siebel Technical Support

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Server SP 2
Database Server OS: HP-UX 11.0

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

Symptoms

SBL-DAT-00376

Our Load campaign has started to fail. We have not changed anything and teh load has been working ok.

[0] Method 'AssocCurrentRow' of business component 'Organization' (integration component 'Contact Organization') for record with search specification '[Name]="IAMS B2I UK"' returned the following error:"There is no field for denormalized column 'MEMBER_FLG' from table definition 'S_CONTACT_BU' defined in business component 'Marketing Contact'.(SBL-DAT-00376)"(SBL-EAI-04375) (0x6c3c)
--[1] Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Update Camp Con'.(SBL-BPR-00162) (0x80d8)
--Object manager error: ([1] Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Update Camp Con'.(SBL-BPR-00162) (0x80d8))
--Error (null) invoking method "(null)" for Business Service "(null)"
--Error invoking service 'Campaign Execution', method 'EAI List Import' at step 'EAI List Import'.(SBL-BPR-00162)

Solution

Message 1

For the benefit of other readers:-

The customer had been loading campaigns successfully. However they were now failing with the errors described.

The error indicated that the process was trying to update the S_CONTACT_BU table. This table holds the relationship between contacts and organization. The error was that the field MEMBER_FLG was not mapped in the Integration object “Marketing Contact”. This was correct as this mapping did not exist.

However all the contacts were coming from the S_CONTACT table so there was no need for the process to be trying to create new relationship records between contact and organization.

The customer investigated the was Contacts were being created in the application and it was determined that they were being created in the 'Default Organisation' which was incorrect. Once this was resolved the Campaign Load worked as expected.

Please note that if the contacts had been coming from an external source and contact/organization records were required, then the mapping of the MEMBER_FLG field would have to be addressed.

Siebel Technical Support

Keywords: campaign populate, integration object, marketing contact

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: Microsoft Windows 2000 Advanced Server SP 3

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

Symptoms

SBL-DAT-00376

Hi, we are trying to assign a new member to the Opportunity Sales Team (from the "Opportunity Form Applet - Child", Sales Rep field).
In that moment the application raise up a MVG Applet, and if we press the New button it pop up a shuttle applet ("Sales Team Mvg Applet")

When we select one member and press the Add Button it gives an error:
"No aparece el campo para la columna desnormalizada '<?>' de la definicion de tabla '<?>' definida en el business component '<?>'(SBL-DAT-00376)"    
the translation would be:
"There is no field for denormalized column '<?>' from table definition '<?>' defined in business component '<?>'."

Do you have any idea of what is causing this error?

Thaks in advanced,

Diego Croce.

Solution

Message 1

Diego,

Thank you for using Siebel Support Web.

I have tested creating a new record in "Opportunity Form Applet - Child", Sales Rep field on our out of the box machine. I was able to do so without any problems. I could not reproduce the behavior. Hence, I guess you have customized "Opportunity Form Applet - Child" applet or the underlying BC. Please confirm and also please provide us the details of the configuration.

This error occurs because the columns in the table that is de-normalized and fields mapped to each of these columns do not exist in the custom BC. Please go to the cfg file and change the attribute "EnableShuttle" from TRUE to FALSE. This then will replace the question marks in the error message with the appropriate column, table name and business component name. Then you can add the missing columns.

Please test this and update your service request with the results.

Thanks