Viewing Audit Details

The Audit Information page displays audit activity and details for the data categories that you select.

To view task audit details:

  1. On the Home page, click Tools.
  2. Click Audit.
  3. Optional: Click the Task Manager Audit tab to view history records for Task Manager related objects. See Viewing Task Manager, Supplemental Data, and Enterprise Journals Audit Details.
  4. Optional: Click the Supplemental Data Audit tab to view history records for Supplemental Data related objects. See Viewing Task Manager, Supplemental Data, and Enterprise Journals Audit Details.
  5. Optional: Click the Enterprise Journal Audit tab to view history records for Enterprise Journal related objects. See Viewing Task Manager, Supplemental Data, and Enterprise Journals Audit Details.
  6. Optional: To view audit activity for the Delete action in the audit screen, the Security Audit Type must be configured.
  7. By default, the Audit Information page displays all tasks. To filter tasks, click Filter, and select filter criteria:
    • Task Group - select one or more, or All. Default is All.

      • If you select Metadata Administration, the system displays a list of subgroups where you can select sub-tasks for metadata:

        • All

        • Custom Dimension

        • Member

        • Year

        • Alias

        • Period

        • View

        • Currency

        • Consolidation

        • Scenario

        • Entity

        • ICP

        • Account

      • If you select Data Form, the system displays a list of subgroups where you can select sub-tasks for forms:

        • All

        • Form

        • Form Folder

      • If you select Data, the Intersection box is displayed, where you can enter the member intersection. You can enter the full or partial member intersection and the system can perform a wildcard search based on the criteria that you specify.

        The Intersection field must follow the member order as below:

        "ScenarioName","AccountName","EntityName","PeriodName","ViewName","CurrencyName","YearsName","IntercompanyName","MovementName","Data SourceName","ConsolidationName","Custom1Name","Custom2Name","Custom3Name","Custom4Name"

        If the application is enabled for Multi-GAAP, the member order is as below:

        "ScenarioName","AccountName","EntityName","PeriodName","ViewName","CurrencyName","YearsName","IntercompanyName","MovementName","Data SourceName","ConsolidationName","Multi-GAAPName","Custom1Name","Custom2Name","Custom3Name"

      • Special Consideration for Save Ownership Data and Recompute Ownership Data:

        As part of Intersection Filter box, use "ScenarioName","YearName","PeriodName" and Action to be selected as Execute.

      • If you selected Approvals, any changes to the approval unit will be displayed. The Approval action is automatically performed during the Approval Unit Hierarchy (AUH) synchronization process, which occurs during system maintenance or a Migration backup. Following are the operations performed during AIJH synchronization:

        If any new entity has been added to the entity hierarchy and if auto locking is needed for that entity, the new entity will be automatically locked for all the POVs where its immediate parent is locked. Auto locking also happens when a user enables an already existing entity in the AUH.

        If any entity is deleted, or when a user deselects the entity when editing an AUH, then the approval unit will be excluded as part of the AUH synchronization process.

        When a new entity is added to the leaf member, the new entity be automatically started if its parent (leaf member) is already started.

    • Action - select one or more, or All.

    • User - enter a user ID. You can enter full or partial user ID information and the system can perform a wildcard search based on the criteria that you specify.

    • Start time - click the calendar to select a start date.

    • End time - click the calendar to select an end date.

    Tip:

    You can select Clear to clear your selections and return to the default values.

  8. When you are done selecting filter criteria, click Apply.

    The grid displays the top 1,000 records from the audit table that match the filter criteria. You can scroll to view all the records.

  9. Optional:
    • To export the audit information to a Microsoft Excel spreadsheet, click Export, and follow the download instructions. When you select the Export option, the system exports all the records that match the filter criteria to a CSV file.
    • To delete the audit information, click Delete. When you select the Delete option, the system deletes all the records that match the filter criteria. You must have the Audit - Manage role to delete audit records.

    Best Practice Tip: Schedule regular archiving and purging of the audit log data, for example, at the end of every quarter. This prevents the audit log data in the system from growing over time. Maintain archived audit log files according to internal document retention policy.

    For more information on scheduling regular archiving of audit data, see Working with EPM Automate.

    Note:

    • To export audit details, you can use the EPM Automate exportAppAudit command or the REST API Export Audit job.
    • Automatic Audit purge will happen to all the environments, except for the legacy environments with creation date prior to July 17, 2020. In future release this exception will also be removed, so it’s recommended for you to take Audit Backup at regular intervals.

    Note:

    If you are using the pdf version of the document: To avoid line breaks and footer information that will render these scripts unusable, copy them from the HTML version of this topic. See "Copying Sample Scripts" in Working with EPM Automate.