Overview of Accelerator Spreadsheets
Oracle provides accelerator spreadsheets that help you to quickly prepare your data for setting up Oracle Fusion Cloud Sustainability.
Accelerator spreadsheets are templates with prepopulated data that you can use for setting up common activity types, attribute values, and emission factors from the United States Environmental Protection Agency (US EPA) and the United Kingdom (UK) government. Oracle recommends that you prepare your data in these templates. You can use the templates as is or modify, add, and delete entries to meet the requirements of your business.
Sustainability Ledger Sample Values
Contains a sample sustainability ledger setup with ledger name and legal entities.
Value Sets
Contains prepopulated value sets having reference data (for example, vehicle types, fuel types, and spend types) aligned with the US EPA and UK government emission factor mappings.
Activity Types
Contains several common activity types and the possible measure and emission types associated with each activity type.
Global Warming Potentials (GWPs)
Contains prepopulated GWPs for several emission types.
Emission Factor Mappings
Contains prepopulated emission factor mappings from the US EPA and UK government.
Invoice Classification Rules
Contains sample invoice classification rules to guide your own rules setup.
Activities
Oracle provides one spreadsheet each for most common activity types such as mobile combustion, purchased energy, stationary combustion, and so on. These spreadsheets contain sample data that help you understand what you can capture on an activity.
- Value Set Published: You can use this spreadsheet as an alternative to manually creating value sets in Oracle Sustainability. It can be especially useful when you need to upload multiple values for a given value set in one go. Note that, using this published sheet, you can add values to one value set at a time.
- Invoice Classification Rules - Published: You can use this spreadsheet as an alternative to manually creating one invoice classification rule at a time in Oracle Sustainability. However, if you plan to create or modify rules in bulk, then you must only use this published spreadsheet. Caution: Oracle recommends that you neither create your own Visual Builder Add-in for Excel spreadsheet for invoice classification rules nor use the REST API directly to create rules, as that can result in unintended data corruption.
You can download these published sheets from Oracle Cloud Customer Connect. Then, copy your prepared data from the accelerator spreadsheets to the corresponding VB Add-in for Excel spreadsheets, and then upload the data to Oracle Sustainability.