My Oracle Support Banner

How To Change The Formula For Calculating Revenue In Both Lead And Opportunity Based On Product Selected. (Doc ID 2063496.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

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


How to change the formula of revenue amount? We have created some custom fields of number data type based.
We would like the revenue to be calculated based on the product group selected.
The formula for revenue field is a simple mathematical formula but we are not able to determine how to change the current way of calculating the revenue amount in both the leads and the opportunity.

Currently the revenue on any product group in leads and opportunity is calculated as Estimated Price*Quantity.
Have created some numeric custom fields because the revenue formula needs to change based on client requirements.
For example,  if IR (a custom field)=6% and Product Group is P1, then revenue should be
Estimated Price*IR, If Product Group is P2, then Revenue should be Estimate Price*IR*3, etc.

Need the standard revenue field to be calculated according to the new formula using few more values as per our clients requirements.
Need to figure out what is the correct API name of the revenue field as opportunity, opportunity revenue line, sales lead and sales product have  do have the "Revenue" fields,
but which is the source we are unable to determine whose formula we can change.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.