Process Sustainability Activities

Use the Process Sustainability Activities scheduled process to perform either mass validation of sustainability activities or mass posting of sustainability activities to a sustainability ledger.

When you run the process in the Validate mode, Oracle Sustainability first recalculates emissions for draft activities, and then validates each activity. You must review and address validation errors if any, and then run the process again to re-validate activities until it is clear of validation errors. When you run the process in the Post to Ledger mode, Oracle Sustainability validates each activity and changes the status of the activity to Posted if the activity is validated without errors. No recalculation of emissions happens in this mode.

When to Use

Use this process when you want to perform mass validation of sustainability activities or post sustainability activities to a sustainability ledger in bulk.

Privileges Required

Process Sustainability Activity (SUS_PROCESS_ACTIVITIES_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Schedule the job, or run it on an ad hoc basis, as needed
Frequency	Daily, weekly, or depending on your data volume, and how often you mass process activities
Time of Day	Anytime of the day
Duration	Variable, based on the volume of data to be processed.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Sustainability Ledger	Required	Specify the sustainability ledger for which activities are to be processed. Unless the Legal Entity parameter is also specified, Oracle Sustainability will process all activities for all the legal entities associated with the selected sustainability ledger.	Sustainability ledger name	None	N/A
Legal Entity	Optional	Specify the legal entity to limit the activity selection to the one specified. Otherwise, Oracle Sustainability will process activities created for all legal entities associated with the specified sustainability ledger.	Legal entity name	None	N/A
From Activity Date	Optional	Specify the date from when activities must be selected for processing. When Start Date is not specified, Oracle Sustainability will process all activities from the first period start date of the selected sustainability ledger.	Date	None	N/A
To Activity Date	Optional	Specify the date until when activities must be selected for processing. When the End Date is not specified, Oracle Sustainability will process all activities until the current date.	Date	None	N/A
Process Mode	Required	Specify one of the processes to be performed, Validate or Post to Ledger.	Validate or Post to Ledger	None	N/A
Period	Optional	Specify the sustainability period for which activities must be processed.	Date	None	N/A

Troubleshooting Information

• You can view the status of the process on the scheduled processes work area.

• Check the output file for summary information regarding:

  • The process that was performed, Validate or Post to Ledger.
  • The number of records that passed validation and the number of records that failed validation when the process mode was Validate,.
  • The number of records that posted successfully and the number records that couldn't be posted when the process mode was Post to Ledger,.
  • A summary of validation messages and the count of activities under each of those validation messages.
• You can query for activities with alerts in the Sustainability Activities page. You can use filters such as Sustainability Ledger, Legal Entity, Needs Attention, and Activity Date that are available on the page.
• From the Sustainability Activities page, you can drill into the records with alerts and review the validation messages.
• When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, or Release Process as provided by the scheduled processes work area.
• If the job fails, then check the output file and log file for an error message.
  • If the process has ended in error because of incomplete setup, then complete all setup tasks and try again.
  • If the process failed because of a system error, then resubmit the process with the same set of parameters.