How do I view audit history in Sales for Redwood?
You can view the audit history of records like opportunities and accounts in Oracle Sales for Redwood.
To set up this functionality, using Oracle Visual Builder Studio, you need to enable the Audit subview in the Redwood details page for the object whose history you want to view.
- First, open the object's detail-page-template.html file from the Apps UI tab.
- Find the object-details entry.
- In the Page Designer tab, click the Code subtab.
- In the Code subtab, add a new template similar to
this:
<template id="auditSubviewTemplate"> <oj-vb-fragment name="oracle_cx_fragmentsUI:cx-audit" bridge="[[ vbBridge ]]"> <oj-vb-fragment-param name="resource" value='[[ {"name": "<objectname>", "primaryKey": "<objectPrimaryKey>", "primaryKeyValue": $page.variables.id, "alias": "Audit" } ]]'> </oj-vb-fragment-param> </oj-vb-fragment> </template>Where
<objectName>should be the name of the object, and<objectPrimaryKey>is the primary key of the object. Using the Account object as an example, the values would beaccountsandPartyId, respectively. - Next, click the JSON tab to go to the
detail-page.jsonof the object.- In , find the subview you want the Audit subview to show up in
(for example,
subview1).- Find and add the
following:
"displayProperties": [ "Audit", ... ] - Find and add the
following:
"sectionTemplateMap": { "Audit": "auditSubviewTemplate", ... }
- Find and add the
following:
- In , find the subview you want the Audit subview to show up in
(for example,
- In addSubLayoutsaddTemplates, add the
following:
"auditSubviewTemplate": { "title": "Audit Subview Template", "extensible": "byReference", "@dt": { "type": "section", "layout": "SubviewContainerLayout" } },
After you enable it, the audit history report is available to all users who have
permissions to view the record – they simply need to enter Show audit
in the Action Bar to show the audit history.