Troubleshooting

Review these suggested solutions for issues with Oracle Fusion Cloud Sustainability.

Issue: The aggregation count on the dashboard or search page for sustainability activities don't match the actual activity count.

Try this: Run the "ESS job to create index definition and perform initial ingest to OSCS" scheduled process with the Index Name to Reingest parameter set to fa-prc-sus-activities. This will sync the aggregation count and activity count.

Issue: Activities generated from Payables invoices have the wrong activity type or activity type attributes.

Try this: This issue can occur if there was no rule in place for the source invoice distribution or an incorrect rule got applied.

As a first step, create a new rule or update existing rules to ensure that future activities from such invoice distributions have the correct activity type and activity type attributes.

Then, to reclassify activities with issues, you can perform one of the following options:

• If the activity type is correct but one of the activity type attributes (such as Spend Type) is incorrect or isn't populated, then you can update the activity and correct the activity type attributes. This method works if you have only a few activities to correct.
• If the activity type is incorrect or if you have a large volume of activities that need to be corrected, then:
  1. Delete the activities that need to be corrected. You can delete activities in any of the following ways:
     • From the Sustainability Activities page in Oracle Sustainability.
     • By using the Oracle Visual Builder Add-in for Excel spreadsheet for the Activity.
     • By using File-Based Data Import (FBDI).
  2. Run the "Generate Sustainability Activities from Payables Invoices" scheduled process again with parameters that would include the source invoice distributions. A new set of activities will be created with the correct activity type and activity type attributes as the updated set of rules are evaluated.
  You can't permanently delete an activity that's generated from Payables invoice, because a new activity will get created in its place in a subsequent run of the scheduled process. If you think the activity isn't needed, then you can perform one of the following actions:

  • Create an exclusion rule that would apply to the source invoice, and delete the activity. When the scheduled process runs again, this invoice distribution will not be processed into an activity.
  • Post the activity to the ledger and cancel it immediately.
  • Update the measures to zero and save the activity. This will cause the emission calculation to be zero. Then, post the activity to the ledger.

Issue: Activity validation issues.

Try this: Fix any validation issues by using the resolution given in the following table. Note that you can't post activities with validation issues to the ledger.

The following table summarizes all the validation messages implemented in Oracle Sustainability. The table also lists the corresponding validation details and resolution.

Validations Implemented in Oracle Sustainability

Validate Message	Validation Details	Applicable to Calculation Modes	Resolution
Activity type end dated	The activity type on the activity record was end-dated in the activity type setup.	All calculation modes	Try any of the following: Extend the end date of the activity type. Update the Activity Date so that it is between the start and end dates of the activity type. If you no longer wish to use the activity type, then create a new activity as the Activity Type field for a record is not an editable field. Then, delete the original activity.
GWP end dated	The activity record has been created with emissions and the GWP associated with the emission type has been end-dated in the GWP set up. The Activity Date on the activity record should be between the start and end dates of the GWP.	All calculation modes	Try any one of the following: Extend the end date of the GWP. Update the activity date so that it is between the start and end dates of the GWP. Update the GWP setup and ensure that the emission types in question have a valid GWP.
Emission factor end dated	The activity record has been created with emissions and the emission factor mapping associated with the emission type has been end-dated in the emission factor setup. The activity date on the activity record should be between the start and end dates of the emission factor mapping.	Using matched factors	Try any one of the following: Extend the end date of the emission factor mapping. Update the activity date so that it is between the start and end dates of the emission factor mapping. Update the emission factor mappings and ensure that the emission types in question have a valid mapping.
Duplicate emissions	There are duplicate emissions for the same emission type in the activity. This error can occur in the following conditions: If the calculation mode is Using matched factors, then more than one emission factor mapping of the same rank matched for the same emission type and duplicate emissions were calculated. For other calculation modes, more than one emission line has been entered for the same emission type.	All calculation modes	If the calculation mode is Using matched factors, then change the rankings of the matched emission factor mappings so that only one highest ranked factor is matched to the activity for the emission type. For other calculation modes, ensure that there's only one emission line entered for an emission type.
Missing emissions	No emissions are entered or calculated for the activity even though the activity type on the record has association to one or more emission types. For example, the Mobile Combustion activity type is associated with emission types Carbon dioxide and Methane, but there are no emission records present in the activity record. This error can happen in the following conditions: If the calculation mode is Using matched factors, then there aren't any emission factor mappings matching the attributes on the activity. For other calculation modes, the activity type on the activity is associated with at least one emission type and no emission line has been entered.	All calculation modes	If the calculation mode is Using matched factors, then: Check that there are matching emission factors based on the activity type, activity type attributes, legal entity, country, or these fields are NULL on the emission factor for a wildcard match. The activity date must be between the emission factor mapping start and end dates. Check that the measure you've entered on the activity matches the measure on the emission factor mapping. Check that the measure UOM matches, or can be converted to the denominator UOM of the emission factor The Oracle Sustainability calculator always picks the highest ranked matching factors on the activity. For other calculation modes, ensure that there is at least one emission line entered.
Missing measures	No measures are entered for the activity even though the activity type on the record is associated with one or more measure types. For example, the Mobile Combustion activity type is associated with a measure type “Quantity.”	Using matched factors Manual entry of factors	Ensure that the activity includes at least one measure that is associated with the activity type.
Emission quantity missing	Emission records are present in an activity, but no emission quantity was calculated. This can happen when there's no UOM conversion set up to convert between the measure UOM and the emission factor denominator’s UOM.	Manual entry of factors	Ensure that there's conversion factor between the measure UOM or Currency, and the emission factor denominator’s UOM or Currency.
Missing CO2e UOM conversion	CO2e emissions couldn't be calculated as the emission quantity UOM couldn't be converted to the reporting CO2e UOM due to a missing unit of measure conversion. For example, CO2e emissions couldn't be calculated for the Carbon Dioxide emission type because the emission quantity UOM (gram), couldn't be converted to the reporting CO2e UOM (kilogram) as gram to kilogram conversion is not set up.	All calculation modes	Ensure that there's a UOM conversion factor to convert from the emission quantity UOM to the CO2e Reporting UOM.
Missing reporting UOM	The reporting CO2e UOM hasn't been set up in profile options.	All calculation modes	Populate the profile option.
Period is closed	Either the activity doesn't have a period or has one that's closed.	All calculation modes	Update the period on the activity to an open period on the ledger.