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 OCTOBER 01, 2024
Applies to:
Oracle Tax Reporting Cloud Service - Version N/A to N/A [Release 11.1]Information in this document applies to any platform.
Symptoms
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.
Cause
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
Symptoms |
Cause |
Solution |
References |