How to build a COA extract for all 12 segments to be used for Finance Data Warehouse
Summary:
We have a requirement to build a COA extract for all 12 segments to be used for Finance Data Warehouse. The objective is to synchronize COA on Oracle into Databricks for all dashboards across various Financials & Procurement Modules. Therefore, we are exploring the most scalable approach for to build the extract ensuring we can keep synronizing the increasing number of COA codes in the future.
The team is currently sending ERP data from Oracle Fusion into Databricks, which serves as the primary finance data warehouse, with Power BI being used for all reporting needs. Since Oracle Analytics is not in use