My Oracle Support Banner

In Tax Reporting Cloud Service (TRCS), Exchange Rates Populate As Zeroes When Loading Rates Via Data Management (DM) (Doc ID 2707151.1)

Last updated on JULY 07, 2021

Applies to:

Oracle Tax Reporting Cloud Service - Version N/A to N/A [Release 11.1]
Information in this document applies to any platform.


When loading Exchange Rates to TRCS using DM, they load as 0 instead of the specified values.  The .dat file generated by DM shows that the data has been imported against the wrong currency (Entity Currency rather than the selected Input Currency).

Example of sample data

Driver Member,Point-of-View,Data Load Cube Name,Value
"SrcEndingRate","FCCS_Global Assumptions,From_AED,FCCS_Periodic,Actual,FY19,P8,Entity Currency",Rates,2
"SrcEndingRate","FCCS_Global Assumptions,From_AFN,FCCS_Periodic,Actual,FY19,P8,Entity Currency",Rates,0.390825511419
"SrcEndingRate","FCCS_Global Assumptions,From_BWP,FCCS_Periodic,Actual,FY19,P8,Entity Currency",Rates,2.7121060782

Data File Support to be generated as

Driver Member,Point-of-View,Data Load Cube Name,Value
"SrcEndingRate","FCCS_Global Assumptions,From_AED,FCCS_Periodic,Actual,FY19,P8,AED",Rates,2
"SrcEndingRate","FCCS_Global Assumptions,From_AFN,FCCS_Periodic,Actual,FY19,P8,AED",Rates,0.390825511419
"SrcEndingRate","FCCS_Global Assumptions,From_BWP,FCCS_Periodic,Actual,FY19,P8,AED",Rates,2.7121060782

Steps to download the dat file

1. In TRCS, go to the navigator and open the Data Exchange card.
2. Click on the Actions menu under Data Integration.
3. Select File Browser and then go to the Outbox folder.
4. Select the "DAT file Generated by DM" file which corresponds to the data loaded from DM into TRCS, and download it.


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.