Clear a GL Accounting Scenario in an ERP Essbase Cube
When using additional Accounting Scenarios in your ERP GL Essbase cube to hold non-Actuals data (e.g. Budget or Forecast data from PBCS), it is occasionally necessary to clear out an entire Accounting Scenario in ERP, for example: · The data is incorrect and must be cleared out · The data pushed from PBCS was mapped to the wrong version · The data needs to be overwritten completely e.g. a “Latest Forecast” scenario which is updated monthly When pushing Budget or Forecast data from Planning (PBCS) to a defined Accounting Scenario in ERP, the data will only be overwritten for combinations which have non-zero data in the push. This means that if data has been cleared to #missing in the PBCS source data, then existing values in ERP will not be overwritten. See my previous blog for more on pushing from Planning to ERP: https://lydia-maksoud-epm.blogspot.com/2019/07/write-back-budgets-from-pbcs-to-fusion.html Unfortunately, in Oracle Cloud ERP