Use The New Attributes of OTBI for Improved Analysis and Reporting

Oracle Transactional Business Intelligence (OTBI) offers real-time self-service reporting, directly from Oracle Fusion Cloud Maintenance. Here's the list of updates to the OTBI subject area folders:

Subject Area: Maintenance Management - Work Requirement Real Time

  • The Work Requirement Real Time folder now includes these attributes:

    • Asset Route Hierarchy ID

    • Asset Route Hierarchy Code

    • Asset Route Hierarchy Name

    • Asset Route Hierarchy Description

    • Asset Route Hierarchy End Date

    • Asset Route Route Completion

    • Asset Route Route Skip Allowed

Subject Area: Maintenance Management - Forecast Real Time

  • The Forecast Line folder now includes this attribute:
    • Meter Interval
  • The Work Requirement Details folder now includes these attributes:
    • Asset Route Hierarchy ID
    • Asset Route Hierarchy Code

    • Asset Route Hierarchy Name

    • Asset Route Hierarchy Description

    • Asset Route Hierarchy End Date

    • Asset Route Route Completion

    • Asset Route Route Skip Allowed

Subject Area: Maintenance Management - Work Order Performance Real Time

  • The Work Order folder now includes these attributes:

    • Maintenance Forecast Id

    • Complete to Inventory

    • Include in Planning

    • Out of Sequence Operations

    • Transform to Item Id

    • Transform to Item Number

    • Allow Multiple Assets

    • Asset Route Hierarchy ID

    • Asset Route Hierarchy Code

    • Asset Route Hierarchy Name

    • Asset Route Hierarchy Description

    • Asset Route Hierarchy End Date

    • Asset Route Route Completion

    • Asset Route Route Skip Allowed

  • The new Asset Route Details folder includes these attributes:

    • Asset Id

    • Asset Number

    • Asset Description

    • Asset Route

    • Serial Number

    • Lot Number

    • Current Location Context

    • Current Location Context Name

    • Location Derived

    • Route Complete

    • Route Skipped

  • The Asset folder now includes these attributes:

    • Asset Id

    • Serial Number
    • Asset Route
    • Warranty Repair

    • Match Transaction Code

    • Primary Reason for Repair Code

    • Primary Reason for Repair

    • Last Operation Sequence Completed

    • Maintenance Complete

OTBI helps you make better decisions based on real-time transactional information. Use the enhanced subject areas to generate reports and queries depending on your needs. 

Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports. For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).

Leverage new subject area(s) by adding to existing reports or using in new reports. For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest  > Books > Administration).

Access Requirements

Users with configured job roles that have the following privileges can access the feature:  

  • Manage Customer Assets (CSI_MANAGE_CUSTOMER_ASSETS_PRIV)
  • Manage Maintainable Assets (MNT_MANAGE_MAINTAINABLE_ASSETS_PRIV)

These privileges are already available in the application.