My Oracle Support Banner

How To Calculate Opportunity Amount At Header Level and Currency When Having Revenue Lines With Different Currencies (Doc ID 1591186.1)

Last updated on NOVEMBER 06, 2019

Applies to:

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


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?


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.