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.

Goal

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


 

 

 

Solution

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