Populate and Upload Emission Factor Mappings

You must populate the Oracle Visual Builder Add-in for Excel spreadsheets that you created earlier for emission factor mappings and then upload the values to Oracle Fusion Cloud Sustainability.

Open the published VB Add-in spreadsheet for your activity type.
Copy data from the relevant tab in the Emission Factor Mappings accelerator spreadsheet that you prepared as follows:
1. Open the Emission Factor Mappings accelerator spreadsheet and navigate to the sheet containing data for the activity type that you want to track.
2. Copy the data from this sheet into the corresponding VB Add-in spreadsheet that you created and optionally published for your activity type.
  Note: Oracle recommends that you carefully evaluate the potential usage of the entries in this spreadsheet and copy only those entries that you intend to use. Doing so will help to keep the data to a minimum and make it more efficient to support any future enhancements.
3. For any data validation errors, verify that the values for currencies, UOMs, and other attributes are configured in your environment.
4. If you are using emission factors from multiple sources for an activity type and maintaining them in separate tabs of the accelerator spreadsheet, then copy data from these tabs into the same VB Add-in spreadsheet.
5. Date in the Start Date column for an emission factor mapping in the VB Add-in spreadsheet defaults to the system date. With this default date, any activity whose start date is in the past will not be able to use the emission factor. Therefore, it’s important to enter start dates that are earlier than the dates of the expected activities.
6. Enter values in the Ranking column as it's a required field. Oracle recommends that you assign the same ranking to all emission factors from the same source and rank the sources relative to one another. This will help you organize your emission factors and rankings. Oracle also recommends assigning rankings using numbers that leave room for inserting values in the future. For example, use a ranking sequence such as 100, 200, 300, and so on instead of a sequence like 1, 2, 3, and so on.
7. Don’t populate the Change, Status, and Key columns. The application will automatically populate values in these columns.
8. For the mobile combustion activity type, if you're using emission factors from United States Environmental Protection Agency (US EPA), then leave the Percent Laden column blank.
From the Oracle Visual Builder tab, click Upload Changes. The Upload dialog box showing the upload progress is displayed.
Verify that the Status column contains "Create Succeeded" for each populated record in the spreadsheet tab.

Tip:

If you want to see all the emission factor mappings that have been uploaded, then from the Oracle Visual Builder tab, click Download Data. The spreadsheet will be populated with the required data.
When configuring emission factor mappings for mobile combustion, ensure that your activities match the emission factor mappings for all required emission types. For example, the United States Environmental Protection Agency source document lists mobile combustion fuel types such as Gasoline (2 stroke) and Gasoline Off-Road Trucks for N2O and CH4 for some non-road vehicles. If you've activities with these vehicle types and energy source Gasoline, then you should change the mappings for N2O and CH4 to specify Gasoline.
When uploading emission factor mapping revisions, if the calculator finds two or more emission factors for an activity and emission type that have the same ranking, then it will use all of them and calculate multiple emission records. To avoid this scenario, be sure to end-date any earlier versions before the new revision’s start date.