Manage Emission Factor Mappings

Welcome to our demo on managing emission factor mappings. In this demo, we will learn to configure emission factor mappings to calculate emissions for sustainability activities. The greenhouse gas protocol specifies preferences regarding which emission factors to apply to an activity.

It's a challenge for organizations to maintain and manage preferred emission factors year on year. The configurability of the Oracle Sustainability lets you decide which emission factors are most appropriate for your activities. It also allows you to rank more specific and accurate emission factors above less specific ones.

If you want to use Oracle Sustainability to find matched factors and calculate emissions automatically, you need to set up emission factors using emission factor mappings. To enter Emission Factor Mappings, you must use a VB add-in spreadsheet. In this demo, we will see a step-by-step process to prepare and upload emission factor mappings using VB add-in spreadsheet.

You will need to generate a VB add-in spreadsheet for each activity type you are using because each activity type has a different set of activity type attributes. Oracle provides you with pre-populated emission factor mappings from the United States Environmental Protection Agency, or EPA, and the United Kingdom, UK, government. You can use the templates as provided or add emission factors that you need.

As a prerequisite, you should have the VB add-in installed. Open a blank Excel spreadsheet. You will see the Oracle Visual Builder ribbon tab in your sheet. Let's first create the catalog for emission factor mappings. I'm clicking the Oracle Visual Builder ribbon tab and then clicking Manage Catalogs.

In the Manage Business Object Catalogs dialog, I am clicking Add and choosing the second option, Import Business Object Catalog from Service Metadata. In the Business Object Catalog Editor dialog, I have entered the test post web address in a specified format, https://hostname/fscmrestapi/resources/11.13.18.05/emissionfactormapping/describe.

I'm clicking Next and providing the username and password for the administrator who has the Sustainability Application Administrator role. After the process is complete, I'm clicking the Finish button, and the emission factor mapping catalog is successfully created. I am clicking the Done button to close the dialog.

Now, let's create a new layout for emission factor mappings. Again, in the Oracle Visual Builder ribbon tab, I am clicking Designer. In the New Layout Setup dialog, I'm selecting Emission Factor Mappings catalog that was added in the previous step and clicking Next. Now, I select Emission Factor Mappings and I again click Next. I'm selecting Table Layout and clicking Next. I'm also ensuring that Emission Factor Map DFF is selected, as it is a required step, and clicking Next.

After confirming the details of the new layout, I am clicking the Finish button to close the dialog. Now, the spreadsheet is populated with all the columns from the REST API. The layout designer on the right panel allows us to choose which columns we want in the spreadsheet. In this demo, I will hide all internal columns, like IDs. To do that, I'm clicking on the Columns tab, I'm clicking + and deselecting the fields that end in ID.

I'm also checking the entries under Emission Factor Map DFF are selected. For this demo, we will be loading emission factor mappings for the activity type Stationary Combustion. Now, I want to set a filter on the Activity Type attribute, which is based on Emission Factor Map descriptive flexfield. To do that, under Selected Fields, I am opening Activity Type attribute, which is based on Emission Factor Map descriptive flexfield.

On the Business Object Field Editor dialog, I am navigating to Polymorphic Information tab. There, I'm selecting Limit Discriminator Values and I'm navigating to find the applicable activity type. For this demo, I'll choose stationary combustion. And clicking Done. I am also going to reorder the columns to be consistent with the Emission Factor Mapping Accelerator Spreadsheet template.

Note, in the sheet with reordered columns, the _Flex_Context attribute has populated a column for activity type and columns for its attributes. In this demo, stationary combustion is the activity type, and fuel type is the activity type attribute. Now, we'll configure the query parameter to download emission factor mappings for the activity type.

To do that, in the layout designer, I am clicking the Query tab. I'm clicking + on Search parameters. In the Search Parameter Editor, I am going to enter the following values. In the parameter name, I will enter q. And the parameter value I will enter as EmissionFactorMapDFF.__FLEX_Context='Stationary Combustion'.

I am clicking OK to close the dialog. If you have additional activity types, for each activity type, replace the query parameter and activity type polymorphic information and save a separate spreadsheet. You can save the spreadsheet and publish the template by clicking the Publish option in the Oracle Visual Builder ribbon tab. In the Publish Workbook dialog, click the Publish button only with the option Clear all authentication properties enabled.

I also have the Emission Factor Mapping Accelerator Spreadsheet template opened. This accelerator sheet is provided by Oracle with the sample data from EPA and UK. I'm copying some data for this demo from the Stationary Combustion EPA tab in the Emission Factor Mapping Accelerator Spreadsheet template to the configured VB add-in spreadsheet.

I'm also providing values in the ranking column and have adjusted the UOMs to the values set up in this instance. I am leaving the columns' change status and key as is, since the application will populate these during the subsequent steps. Now, I'm clicking the Upload Changes in the ribbon.

The status is Create Succeeded for each populated record in the spreadsheet tab. If you are using emission factors from multiple sources for an activity type which are maintained in separate tabs in the Accelerator Spreadsheet template, you can copy them into the same VB add-in spreadsheet. If you want to see all emission factor mappings that you have uploaded for an activity type, you can click the Download Data Menu item in the ribbon. This completes the demo. Thank you.