1. How do I get started with Sustainability?
  2. Populate and Upload Emission Factor Mappings

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.

  1. Open the published VB Add-in spreadsheet for your activity type.
  2. 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:

      • Copy only those entries that you intend to use to keep the data to a minimum.

      • Upload any emission factor mappings from the accelerator spreadsheet for the most recent calendar year. End-date any older mappings to a date before the new mappings' start date.

    3. For any data validation errors, verify that the values for currencies, UOMs, and other attributes are configured in your environment.
    4. If you're 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. 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. Assign 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.
  3. From the Oracle Visual Builder tab, click Upload Changes. The Upload dialog box showing the upload progress is displayed.
  4. Verify that the Status column contains "Create Succeeded" for each populated record in the spreadsheet tab.

  5. (Optional) To see all the emission factor mappings that have been uploaded, from the Oracle Visual Builder tab, click Download Data. The spreadsheet will be populated with the required data.

Tip:

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.