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

Last updated on MARCH 07, 2017

Applies to:

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

Goal

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.

 

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