My Oracle Support Banner

Visual Builder: How To Do Aggregation On A Computed Field That Is A Calculated Column In The Child Level (Doc ID 2408157.1)

Last updated on APRIL 18, 2019

Applies to:

Visual Builder - Version N/A to N/A
Information in this document applies to any platform.

Goal

This knowledge article reflects updated product names. Visual Builder was formerly known as Visual Builder Cloud Service (VBCS). Please see KM for the full list of recently renamed PaaS services.

Need to aggregate the total amount in a shopping cart BO, which has cart Item as its child BO. The Cart Item has a computed field cart Item Amt which is Qty * Unit Price.
The requirement is to aggregate this calculated column in the parent BO. However, the Visual Builder does not show the computed field in the drop down for aggregation selection.

How to achieve this ?

Sample Shopping Cart Scenario


 

 

 

Solution

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
Goal
Solution


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