Load GL balances hourly during period close - closing reconciliations in paralell
Summary:
For period close balance reconciliations we have the requirement to load GL balances every hour through direct integration with Oracle ERP GL.
This applies to reconciliation compliance and balance comparisson on mainly Group Account level but also other levels.
We want to be able to close reconciliations on day 1 of period close while continously loading GL balances to make sure users are working on the latest data. And, if no changes to the balances pertaining to the closed reconciliation(s), they should remain closed. And vice versa, if there are changes in balances pertaining to closed reconciliations.
What is the best approach to fulfill this requirement?