Unable to Display Count of Grand Child Records in a Child VBC Applet (Doc ID 536175.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3.6 [16186] and later
z*OBSOLETE: Microsoft Windows 2000
Checked For Relevance on 03-Feb-2015
Checked for relevance on 7/13/16

Symptoms

Following configuration has been done
1. Parent BC based on Siebel assets table
2. Child BC based on external table (VBC) - special offers for the parent asset
3. Grandchild BC based on Siebel response table - responses to the parent offer

Business requirement is to have a calculated field in the Offer VBC showing how many responses each offer has (count of grandchild records in the child VBC).

Tried to achieve by creating a MVL, a MVF and a calculated field with a calculated value count(mvfield) in the VBC The problem is we get neither errors, nor values in this new field.

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