Redwood: View the Audit Trail of Measure Updates Using a New User Experience

Using the Redwood user experience, you can view the record of all changes made to a measure to verify the source, update type, and time of each entry. The Audit trail drawer for a pivot table cell displays the previous value, context in which the change was made, and the plan name where the modification occurred. You can review the changes specific to the plans and data combinations that you’ve permission to access.

You can view the audit trail on an editable cell by selecting it in the table and doing the following:

• Right-click the cell, and select View Audit Trail.
• In the Actions menu, click View Audit Trail.

Option for Viewing Audit Trail in Context Menu for Editable Cell

Option for Viewing Audit Trail in Actions Menu

The Audit trail is opened in a drawer, and you can view the history of changes to the measure value of the cell. Remember that the audit trail displays the value that was updated directly in the selected cell in the table or the value that was updated in another table with a higher or lower data aggregation. This drawer provides a quick and easy way to track audit changes.

Audit Trail Drawer

NOTE: The Update Context field shows the context of the cell where the update was made along with any table and member filters. The page-level search and applied filters aren’t captured in the audit trail.

Here's the demo of these capabilities:

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

If you want to use the Redwood: View the Audit Trail of Measure Updates Using a New User Experience feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

• Whenever you want to view the audit trail for a different cell, you can select the required cell and then select the View Audit Trail menu option. There’s no need to close the drawer each time because it will be refreshed with the current cell’s audit trail.
• The page-level search and applied filters aren’t captured in the audit trail.

Key Resources

• This feature includes the introduction of a public REST API named getAuditData to retrieve the audit trail. Refer to the guide named REST API for Oracle Supply Chain Management Cloud for details on this REST API.
• Related What’s New features for reference:
  • Redwood: Use Pivot Tables to Analyze Plans Using a New User Experience

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

• Maintain Planning Tables (MSC_MAINTAIN_PLANNING_TABLES_PRIV)

This privilege was available prior to this update.