Closed Reconciliations are Reopening in ARCS
In ARCS, we are facing an issue where the closed reconciliations are reopening. Even if there is no balance change closed reconciliations are reopening for that month. We started with data integrations first to see if there is any change in the loaded balance and we couldn’t find any changes in the data. Our integrations are setup to run every hour throughout the week
Using snapshot mode to load balances into the system.
Since we couldn’t find any balance changes in the data loads, we started looking into the previous schedules and noticed the previous loads were failed on weekends. This happened only during the Oracle patch window time (PROD). We contacted oracle and Oracle confirmed that in February they applied a patch that rounds the data automatically to two decimal points.