How You View Asset History

View all transactions performed on an asset in Oracle Maintenance as well as all integrated applications. You can use the Asset History tab on the Edit Asset page to view all the transactions.

On the Asset History tab, you can use the filter panel to search transactions by a period, data range, source application, and so on. The search results table shows these details:

Attribute

Description

Reference

Unique identifier of the asset transaction. You can also view the details of the transaction using the reference hyperlink that navigates to the View Details page. However not all the transaction details are supported.

Click the reference to navigate to the appropriate transaction details page. To access these details, a user must have the appropriate roles and privileges for viewing this reference.

For example, to view a transaction for an RMA receipt, here's what you need:

  • Name: View Sales Order

  • Code: ZCS_VIEW_SALES_ORDE_PRIV

  • Description: Allows viewing of sales order

Date

Date on which the transaction took place.

Source

Source product where the transaction was initiated. The sources are:

  • Asset Tracking

  • Common Work Execution

  • Distributed Order Orchestration

  • Inventory Management

  • Maintenance Management

  • Receiving

Type

Type of the transaction. There are over a 100 transaction types.

Group

The group to which the transaction logically belongs. For a better search and viewing experience, each transaction is grouped and can be used as a filter to search. A single transaction can be a part of multiple groups based on asset attributes that get updated. The groups that the transactions are grouped into are:

  • Asset Changes:

    • Asset Attribute Changes: Includes transactions resulting from changes to any asset attribute other than location attributes.

    • Asset Location Changes: Includes transactions resulting from changes to the asset's location attributes.

    • Asset Relationships: Includes transactions resulting from changes to asset components. This includes asset hierarchy updates and parts change.

  • Inventory and Sales:

    • Inventory: Includes all transactions with the product code as INVENTORY.

    • Sales Order: Includes all transactions with the product code as OM.

  • Work Orders and Inspections:

    • Work Orders: Includes all Maintenance and Manufacturing work orders created for the asset.

    • Inspections: Includes all work orders with inspections recorded for them.

User

Name of the user who performed the transaction.

Details

Icon that opens the slide panel with transaction details. Drill down to the Details panel to see the changes on the asset due to a transaction. The Details panel shows the list of attributes that are updated by the transaction with the old and new values of those attributes. For example, if the asset was issued out of subinventory some attributes like Location Type, Location Organization, Location, Subinventory on the asset change. These attributes are listed in the Details panel with the values before and after the transaction.

How You Audit Asset History

You can’t create and update the attributes for the Asset object with the common Audit History functionality. However, similar functionality is recorded by the Asset history table CSE_ASSETS_HIST. This table includes most of the standard attributes, and additional (Application Composer) and extensible (Definable Flexfield) attributes. Attributes that are excluded from audit history are typically not expected to be updated over an Asset’s lifetime or do not have to be audited.

Additionally, audit history of key Asset attributes are included in the Maintenance Management - Asset History Real Time subject area in OTBI. You can create an Analysis to view the old and new values of these key fields.