Is there any way to add daily rates in ""Costing- Receipt Accounting Real Time" Subject area

Indrajeet

I am trying to add the daily rates in "Costing - Receipt Accounting Real Time" subject area to calculate the ledger amount(in USD) converted to the specific currency(EUR) in report. Can you please help me to achieve this?

Nathan CCC

Hi,

You refer to the conversion rates

setup from My Enterprise work area Setup and Maintenance task "Manage Daily Rates"

in application table

GL_DAILY_RATES

https://docs.oracle.com/en/cloud/saas/financials/24d/oedmf/gldailyrates-24409.html

So that we can do our own currency conversions

check the data lineages yourself

https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html

but I do NOT think this is exposed in the presentation layer in any of subject areas.

Some of the measures in the facts in some subject areas have a calculation in them in the meta data repository database using a presentation variable to toggle between different different currencies.

Users can set this in My Profile My Account Preferences "Currency"

which in the logical SQL is this assignment

SET VARIABLE PREFERRED_CURRENCY='Document Currency';…

For more information

read the user guide section Set Up Currency

Oracle Fusion Cloud Applications
Creating and Administering Analytics and Reports
G12411-01 24D

https://docs.oracle.com/en/cloud/saas/applications-common/24d/faacc/currency-and-exchange-rate-settings-for-analytics.html

Indrajeet

Thanks Nathan! I think I need to develop BI report in this case.