Asset Subject Areas
The Asset subject areas are based on data from the Oracle Utilities Work and Asset Cloud Service, such as activities, asset costs, and labor hours. The image below is an example of how data could look in the Labor Hours subject area.
On this page:
Asset - Activities
This subject area exposes all data directly related to activities. The metrics and attributes of this model can be used for various types of business analysis.
Answer questions like these:
- How many corrective work activities are in my backlog?
- How many preventive work activities are in my backlog?
- What is my breakdown by work priority of corrective and preventive work?
- What is my planned activity backlog by work type or status?
- What is my non-planned activity backlog by work type or status?
- What is the distribution and performance of compliance-related activities?
Asset - Activity Cost
This subject area can be used to analyze Failure Repair Costs, Maintenance Costs, Renewal Cost and Total Costs by Activity, Asset, Asset Location, Location Hierarchy, and Work Order.
Answer questions like these:
- What is the failure count by activity?
- What is the failure repair cost?
- What is the total maintenance cost?
- What is the total renewal cost?
- What is the total cost of all work activities?
- How is the performance of different organizations or departments in terms of Maintenance Cost, Renewal Cost, and Total Cost?
- What is the estimated and actual cost for different maintenance types, and how does it break down by resource class, cost category, or cost center?
- What is the corrective maintenance cost compared to the maintenance cost and its trend?
- What is the Estimate versus Actual Activity Cost trend?
Asset - Asset Availability Based on Downtime Service History
This subject area uses Downtime Service History to determine the number of hours or days an asset has been down due to failure. However, it only uses Downtime Service Histories associated to Work Activities with an unplanned downtime reason. This model can be used to analyze failures by the attributes of Activity, Asset, Asset Location, Crew, Failure Service History, Location Hierarchy, and Work Order.
Answer questions like these:
- What is the failure rate of assets based on downtime service history?
- What are the lifetime failures for an asset based on downtime service history?
- What is the count of asset failures for the last 12, 24, and 60 months based on downtime service history?
- What is the lifetime mean time between failure for assets based on downtime service history?
- What is the asset mean time between failure for the last 12, 24, and 60 months based on downtime service history?
- What is the mean time to repair by hours or days for assets based on downtime service history?
- What is the total failure downtime based on downtime service history?
- What is the total uptime by hours or days for assets based on downtime service history?
Asset - Asset Availability Based on Work Order
This subject area is based on the duration of asset-related work activity that has an associated Failure Service History. Note that if a work request is related to a failure work activity, then the creation date of the work request (rather than the work order) is used to calculate the duration of the downtime. This model can be used to analyze failures by the attributes of Activity, Asset, Asset Location, Crew, Failure Service History, Location Hierarchy, and Work Order.
Answer questions like these:
- What are the lifetime failures for an asset based on work order failure history?
- What is the count of asset failures for the last 12, 24, and 60 months based on work order failure history?
- What is the lifetime mean time between failure for assets based on work order failure history?
- What is the asset mean time between failure for the last 12, 24 and 60 months based on work order failure history?
- What is the mean time to repair by hours or days for assets based on work order failure history?
- What is the total failure downtime based on work order failure history?
- What is the total uptime by hours or days for assets based on work order failure history?
Asset - Asset Cost
This subject area can be used to analyze metrics and key performance indicators related to asset cost.
Answer questions like these:
- What is the asset life-to-date cost?
- What is the annual asset maintenance cost for the last three years?
- What is the average failure repair cost?
- What is the average outage repair cost?
- What is the total failure repair cost, maintenance cost, or renewal cost for assets?
Asset - Financial Transaction GL Detail
This subject area exposes all data directly related to financial transaction details. The metrics and attributes of this model can be used for various types of business analysis.
Answer questions like these:
- What is my budget amount by cost center?
- What are my costs by expense code?
- What are my costs by cost center?
Asset - Forecasted Activity Hours
This subject area can be used to determine the forecasted hours for activities along with related dimensions.
Answer questions like these:
- What is the forecasted number of labor hours on all open work activities?
- What is the forecasted number of labor hours for planned maintenance work activities?
- What is the forecasted number of labor hours for planned construction work activities?
- What is the number of planned versus unscheduled labor hours for maintenance work activities?
Asset - Forecasted Asset Cost
This subject area can be used to analyze the information about forecasted preventive maintenance and forecasted failure costs.
Answer questions like these:
- What is the forecasted preventive maintenance cost for the first year and next 2, 5, and 10 years?
- What is the forecasted preventive maintenance cost for the remaining life of an asset?
- What is the forecasted failure cost for the next 5 and 10 years?
- What is the forecasted failure cost for the remaining life of an asset?
Asset - Forecasted Asset / Resource Hours Fact
This subject area can be used to determine the forecasted preventive maintenance labor hours for each asset along with related dimensions.
Answer questions like these:
- What is the number of forecasted preventive maintenance labor hours needed for an asset in the next 1, 2, 5, or 10 years?
- What are the hours needed, by different resource type, for preventive maintenance work in the next 1, 2, 5, and 10 years?
Asset - Labor Hours
This subject area includes information related to labor hours against different charge types like activity, cost center, employee unavailability, or project in timesheet. You can get details about regular and overtime labor hours charged for different maintenance types.
Answer questions like these:
- What is the total labor cost, total labor hours, total regular labor hours, or total overtime labor hours distributed across departments or organizations?
- What is the breakdown of labor hours by regular versus overtime?
- What is the breakdown of labor hours by preventive maintenance versus corrective maintenance?
- What are the top ten Asset Type, Activity Type, Resource Type consuming maximum labor hours?
- What is the trend of total labor hours and overtime hours?
Asset - Service History
This subject area can be used to analyze service history by Activity, Asset, Failure Cause, Failure Component, Failure Mode, Failure Repair, Asset Location, User, and more.
Answer questions like these:
- What is my count of service history by category?
- What is my count of service history by type?
- What is my failure count by failure cause, failure mode, failure component, and failure repair?
Asset - Stock Item Details
This subject area enable organizations to monitor and analyze their asset inventory by providing visibility on the key attributes of a stock item.
Answer questions like these:
- How are stock items distributed across storerooms and their availability?
- What is the dollar value of the inventory?
- How many capital spares are available?
- How are vendors distributed across geography and insights related to supplied stock items?
- What is the overall A-B-C categorization across storerooms?
- How much is the value of inventory over max?
Asset - Stock Transactions
This subject area provides insights on stock transactions, such as the location and status of stock items.
Answer questions like these:
- How many stock items are in transfer, in reserve, or on demand?
- What stock items are understocked, high on demand, or currently have open orders?
- Which top stock items have the highest utilization?
Asset - Timesheet Detail
This subject area exposes all data directly related to timesheet details. The metrics and attributes of this model can be used for various types of business analysis.
Answer questions like these:
- What is my labor hour breakdown by overtime verses regular time?
- What is my labor cost breakdown by overtime versus regular time?
- What is my labor hour breakdown by activity type for corrective and regular time?
- What are the top 10 crews with the most labor hours?
- What is the labor hour breakdown by employee for regular and overtime?
Asset - Work Orders
This subject area exposes all data directly related to work orders. The metrics and attributes of this model can be used for various types of business analysis.
Answer questions like these:
- What is the total count of all work orders?
- What is the count breakdown by regular and preventive work orders?
- What is the count of completed work orders, open work orders, or canceled work orders?
- What is the count of work orders by status for regular versus preventive work orders?
- What is the count of overdue work orders?
- What is the trend of maintenance work order creation versus completion?
- What is the backlog distribution across Asset Criticality and Work Priority?
- What is the overall work order backlog and how much planned work is unscheduled?
- What is the count of total work orders by asset location?