Data migration - balances of accounts in foreign currency
Hello,
Our customer will use Oracle E-business Suite R12.1.3 with modules AP, AR, FA and GL, and they are going to migrate the data in production system in April-18, currently they are using an older version of oracle e-business suite (version which cannot be upgraded to R12) and they generate daily/monthly balance sheets, also they use 12 foreign currencies and execute monthly revalution for these currencies.
They are going to migrate the balance sheet of 31.03.2018 to use as a starting point of the new system, and start recording daily transactions in 01.04.2018.
Our concern is regarding data migration of historical balances in foreign currency and how is going to work the revaluation proccess/account, we have thought of two scenarios: