1. How do I get started with Sustainability?
  2. Generate Emission Factor Mappings Spreadsheet

Generate Emission Factor Mappings Spreadsheet

You must now generate Oracle Visual Builder (VB) Add-in for Excel spreadsheets for every activity type that you had previously defined while performing the procedure described in Configure the Emission Factor Map Descriptive Flexfields.

Before you start

Download and install Oracle Visual Builder Add-in for Excel from here: https://www.oracle.com/downloads/cloud/visual-builder-addin-downloads.html.
  1. Open a blank Microsoft Excel workbook with Oracle Visual Builder Add-in for Excel installed.
  2. Create a catalog for emission factor mappings as follows:
    1. On the Oracle Visual Builder tab, click Manage Catalogs.
    2. In the Manage Business Object Catalogs dialog box, click Add, and then select Import Business Object Catalog From Service Metadata.
    3. In the Business Object Catalog Editor, enter the following URL in the Web address field:

      https://HOST_NAME/fscmRestApi/resources/11.13.18.05/emissionFactorMappings/describe

      In the URL, replace HOST_NAME with the host name of your Fusion instance.

    4. Click Next.
    5. On the Sign In page, enter the sign in credentials for the user who has been assigned a role that includes the Manage Emission Factor (SUS_MANAGE_EMISSION_FACTORS_PRIV) privilege.

      A message confirming successful creation of the catalog is displayed.

    6. Review the catalog details and then click Finish.
    7. On the Manage Business Object Catalogs dialog box, click Done.
  3. Create a new layout for emission factor mappings as follows:
    1. On the Oracle Visual Builder tab, click Designer.
    2. In the New Layout Setup dialog box, ensure that the emissionFactorMappings catalog is selected and click Next.
    3. Select the Emission Factor Mappings business object and click Next.
    4. Select the Table Layout option and click Next.
    5. Select the Emission Factor Map DFF checkbox and click Next.
    6. Confirm the details of the new layout and click Finish.

    The spreadsheet is populated with all columns from the REST API.

  4. In the Layout Designer for your table, choose the columns that must appear in the spreadsheet as follows:
    1. On the Columns tab, click Manage Columns (+) .
    2. In the Table Column Manager dialog box, in the Business Object pane, deselect all fields that end with ID. Ensure that all entries under the Emission Factor Map DFF business object are selected.
    3. In the Selected Fields pane, look for and double-click the Activity Type* (Emission Factor Map DFF) field.

      The Business Object Fields Editor - __FLEX_Context dialog box is displayed.

    4. On the Polymorphic Information tab, select Limit discriminator values and the activity type for which you are creating emission factor mappings. Select the activity type (for example Stationary Combustion) that you set up in Configure the Emission Factor Map Descriptive Flexfields.
    5. Click Done.
    6. For the ease of copying over data from the accelerator spreadsheet subsequently, you might want the columns in the VB Add-in sheet to be consistent with the ones in the Emission Factor Mappings accelerator spreadsheet. To do so, on the Selected Fields pane, reorder the columns as required. Note that the Activity Type* (Emission Factor Map DFF) field will create a column for activity type and columns for its attributes.
    7. Click Done.
    8. Rename the spreadsheet tab to reflect the name of the activity type.
    9. Save the spreadsheet.
  5. Configure the Query Parameter to download emission factor mappings for the activity type as follows:
    1. In the Layout Designer, click the Query tab.
    2. Click Add Search Parameter (+).

      The Search Parameter Editor is displayed.

    3. In the Parameter Name field, enter q, in the Parameter Value field, enter EmissionFactorMapDFF.__FLEX_Context = 'ACTIVITY_TYPE'. Here, replace ACTIVITY_TYPE with activity type name for which you are creating the emission factor mapping. For example, Stationary Combustion.
    4. Click OK.
  6. Save the spreadsheet.
  7. If you want to publish the template, then:
    1. On the Oracle Visual Builder tab, click Publish.
    2. In the Publish Workbook dialog box, browse to the location where you want to publish the template and also enter a name for the same. For example, Stationary Combustion Emission Factor Mappings.xlsx.
    3. Ensure that only the Clear all authentication properties checkbox is selected, and then click Publish.
  8. If you want to generate VB Add-in sheets for additional activity types, then replace the Query Parameter and Polymorphic Information for the activity type and save a separate spreadsheet as follows:
    1. In the Layout Designer, on the Query tab, double-click the previously added search query and expression.
    2. In the Search Parameter Editor, in the Parameter Value field, replace the previous activity type name with the current activity type name. For example, if you're creating emission factor mappings for waste generated in operations activity type, then the value in the Parameter Value field is: EmissionFactorMapDFF.__FLEX_Context = 'Waste Generated in Operations'
    3. Ensure that the Allow expressions in Parameter Value checkbox is selected and click OK.
    4. On the Columns tab, double-click Activity Type*. The Business Object Fields Editor - __FLEX_Context dialog box is displayed.
    5. On the Polymorphic Information tab, select the additional activity type and deselect any others. For example, select Waste Generated in Operations and deselect Stationary Combustion.
    6. Click Done.
    7. Rename the spreadsheet tab to reflect the name of the activity type.
    8. Save the spreadsheet by naming it to reflect the new activity name. For example, Waste Generated in Operations Emission Factor Mappings.xlsx.
    9. (Optional) Publish this template as described in Step 7.

Related Topics