My Oracle Support Banner

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

Last updated on JUNE 11, 2018

Applies to:

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


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 VBCS does not show the computed field in the drop down for aggregation selection.

How to achieve this ?

Sample Shopping Cart Scenario





To view full details, 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 a vibrant support community of peers and Oracle experts.