How to View Canadian Assets in Both USD and CAD When Using a Single Ledger and Separate Asset Books?

Hello community,

We have a requirement to maintain a single primary ledger (USD) for both our US and Canadian operations in Oracle. We are also maintaining separate asset books for each country, both of which are associated with the USD primary ledger. This means all Canadian assets are created in USD.

However, for reporting purposes, we also need to represent Canadian asset balances in CAD. To achieve this, we have set up a reporting ledger in CAD and are attempting to use the “Translate asset balances to reporting currency” process. Unfortunately, the CAD reporting ledger does not appear in the List of Values (LOV) when running this process.