My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.