Create a new transient attribute in master VO to hold Sum value. Choose below properties
For expression value (yourColumnName is from child VO)
For refresh expression value
Create a new transient attribute in master VO to hold Sum value. Choose below properties
For refresh expression value
FLASHBACK TABLE <table_name> TO BEFORE DROP;
Find more at link below
https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm