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, 2024

Applies to:

Visual Builder Studio - Version 19.4.3 and later
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 <document 2493395.1> 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

References

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

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

Applies to:

Goal

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!