NV: Drill down always uses the base currency of the Requesting Business Unit.
(Doc ID 608080.1)
Last updated on FEBRUARY 01, 2023
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 7.5 and laterInformation in this document applies to any platform.
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 220643
Symptoms
The customer uses multi-book functionality. They've got a ledger group set up with both the ACTUALS ledger and the REPORTS ledger. The REPORTS ledgers is defined with a currency code of USD. On their nVision report they are using the REPORTS ledger. In the Report Request they are using a business unit which has a base currency of CAD. When they run the report it works properly - it uses the currency code of USD for the amount retrieval. However, when they attempt to drill down to Journals the drill down SQL uses the currency code of CAD. This causes the drill down to return nothing.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 |