How To Calculate Opportunity Amount At Header Level and Currency When Having Revenue Lines With Different Currencies

(Doc ID 1591186.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Goal

Is it possible to manage a formula field at Opportunity Header level which give sum of revenue line amount in currency of Header (in case of different currencies of revenue line)



Need is to create a currency field "EGO" at   Opportunity level which is the sum of  currency fields at opportunity revenue lines.
This field must be currency because user need  to have the ability to consolidate this EGO Field for multiple countries.

Need  to use a formula field for" EGO" but formula is only of 3 types: date, text or number. Not currency
Is there an existing way to do answer this need  ?
Is there another way or workaround to do that without formula field?

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