Last updated on OCTOBER 13, 2015
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
The customer uses formula custom fields on Opportunity to sum, avg other custom number fields from Opportunity Revenue. The formula fields don't update when the custom number fields change but only after Save and edit again the opportunity.
Steps used by customer:
-he created four custom fields of type Number through the application composer in the sales section Objects/Standard objects/Opportunity Revenue/Fields: Desviacion, Margen, Prevision and Facturacion
-he created in Objects/Standard objects/Opportunity/Fields four Number formula fields that are calculated through the fields before created: DeviationOp (summatory of Desviacion fields), MarginOp (average of Desviacion fields), BudgetOp (summatory of Desviacion fields) and BillingOp (summatory of Desviacion fields)
-the formulas are
- Margen: ChildRevenue.avg('Margen_c')
- Desviacion: ChildRevenue.sum('Desviacion_c')
- Presupuesto: ChildRevenue.sum('Prevision_c')
- Facturacion: ChildRevenue.sum('Facturacion_c')
The customer issue si that the formula fields don't update when the custom number fields change, but only after Save and edit again the opportunity.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms