Currency Conversion Is Not Happening for Static Driver Allocation Rules
(Doc ID 3078121.1)
Last updated on MARCH 26, 2025
Applies to:
Oracle Financial Services Profitability Management Cloud Service - Version NA and laterInformation in this document applies to any platform.
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service (PBSMCS)
Oracle Financial Services Profitability Management Cloud Service (PMCS)
Symptoms
Using PMCS and have created few allocation rules for testing. Have provided the currency as INR at the source and selected the functional currency at the target. By default, the functional currency is set to USD.
Have also populated data in FSI_EXCHANGE_RATE_HIST table with INR and USD. However, after running the allocation rule, in the rule output the currency conversion is not happening.
The issue can be reproduced at will with the following steps:
1. Create test allocation
2. Provide the currency as INR at the source and selected the functional currency at the target.
3. Populated data in FSI_EXCHANGE_RATE_HIST table with INR and USD
4. Run the allocation rule and currency conversion does not happen.
Changes
Code bug. The inner join query for the exchange rate was missing in the source sub-query due to a logical issue in identifying whether the source was a column or an expression. This has now been fixed, allowing the PFT exchange rate query to appear in the source sub-query as intended.
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 |
| Changes |
| Cause |
| Solution |
| References |