How to integrate weekly data from Oracle ERP Cloud?
Summary:
We have daily, weekly and monthly reconciliations where we compare Oracle ERP Cloud GL data with external systems using Reconciliation Compliance. For daily and monthly reconciliations we are using standard application 'Oracle ERP Cloud (GL Balances)' in ARCS. However, we have difficulties in retrieving weekly data from Oracle ERP GL, since accounting periods in ERP are created as calendar months and Average Daily Balances option does not include week as well. In ARCS periods are created as each calendar day and weekly period is marked as each Sunday, e.g. ARCS period 27.10.2024 should represent ERP GL balances from 21.10.2024 till