Number Formula Fields Aren't Updated In Real Time, Just When You Click Save And Enter Again (Doc ID 2053415.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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