Enhance Maintenance Management OTBI Subject Areas for Supplier Warranty, Equipment Qualification, and Maintenance Program

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 areas and dimension folders:

• Subject Area: Maintenance Management - Work Requirement Real Time
  • Update by Dimension Folder
    • The Work Requirement Details folder includes these attributes:
      • Asset Historical Service Date
      • Asset Historical Service Interval
      • Assets Included Option
      • Day Based
      • Forecast Window in Days
      • Number of Days
      • Work Order Window in Days
      • Work Order Priority
      • Work Order Firm
      • Work Order Status
      • Work Order Create Option
      • Work Requirement Next Due By
      • Work Requirement Reference
      • Affected Assets
        • Asset Historical Service Date
        • Asset Historical Service Interval
        • Asset Start Date
        • Work Order Create Option
      • Work Definition Due Details
        • Work Definition Due at Interval
        • Work Definition Repeats at Interval
        • Disabled
    • The Maintenance Program folder includes these attributes:
      • Forecast Window in Days
      • Global Assets Option
      • Generate Work Order Request in Process
      • Last Generate Forecast Request ID
      • Last Generate Work Order Request ID
      • Maintenance Program Reference
      • Maintenance Program Subtype
      • Maintenance Program Type
      • Work Order Window in Days
      • Work Order Start Time
      • Work Order Timezone
    • Meter:
      • Base Interval
      • Meter Next Due By
      • Disabled

• Subject Area: Maintenance Management - Forecast Real Time
  • Update by Dimension Folder
    • The Work Requirement Details folder includes these attributes:
      • Asset Historical Service Date
      • Asset Historical Service Interval
      • Assets Included Option
      • Day Based
      • Forecast Window in Days
      • Number of Days
      • Work Order Window in Days
      • Work Order Priority
      • Work Order Firm
      • Work Order Status
      • Work Order Create Option
      • Work Requirement Next Due By
      • Work Requirement Reference
      • Affected Assets
        • Asset Historical Service Date
        • Asset Historical Service Interval
        • Asset Start Date
        • Work Order Create Option
      • Work Definition Due Details
        • Work Definition Due at Interval
        • Work Definition Repeats at Interval
        • Disabled
    • The Maintenance Program folder includes these attributes:
      • Forecast Window in Days
      • Global Assets Option
      • Generate Work Order Request in Process
      • Last Generate Forecast Request ID
      • Last Generate Work Order Request ID
      • Maintenance Program Reference
      • Maintenance Program Subtype
      • Maintenance Program Type
      • Work Order Window in Days
      • Work Order Start Time
      • Work Order Timezone

• Subject Area: Supplier Warranty - Asset Real Time
  • Update by Dimension Folder
    • The Claim folder includes these attributes:
      • Claim ID
      • Claim Number
      • Claim Type
      • Manually Created
      • Object Type
      • Object ID
      • Warranty Provider ID
      • Claim Date
      • Claim Status
      • Submit By Date
      • Claim Amount
      • Claim Amount Currency Code
      • Claim Notes
      • Reimbursement Reference
      • Assigned To Person ID
      • Reason For Repair Code
      • Provider Labor Rate
      • Match To TXN
      • Material Amount Total
      • Equipment Amount Total
      • Labor Amount Total
      • Standard Labor Amount
      • Other Amount
      • Claim Adjustment Amount
      • Currency Conversion Type
      • Currency Conversion Rate
      • Reimbursement Amount
      • Reimbursement Type
      • Resolution Date
      • Active End Date
      • Currency Code
      • Corp Currency Code
      • Curcy Conv Rate Type
    • The Person Details folder includes these attributes:
      • Business Unit
      • Department
      • First Name
      • Last Name
      • Middle Name
      • Name
      • Party ID
      • Person Number
      • Person Type
      • Primary Email
      • Primary Phone
      • Registry ID
    • The Entitlements folder includes these attributes:
      • Entitlement ID
      • Claim ID
      • Entitlement Number
      • Entitlement Date
      • Entitlement Type
      • Organization ID
      • Contract ID
      • Asset ID
      • Entitlement Description
      • Manually Created
      • Warranty Entitled
      • Cost Transaction ID
      • Work Order ID
      • WO Operation ID
      • WO Operation Resource ID
      • WO Operation Material ID
      • Transaction Code
      • Work Accomplished Code
      • Reason for Repair Code
      • Reimbursement Qty
      • Reimbursement Qty UOM Code
      • Reimbursement Unit Cost
      • Reimbursement Total Cost
      • Reimbursement Currency Code
      • Entitlement Notes
      • External Reference Number
      • Currency Code
      • Corp Currency Code
      • Curcy Conv Rate Type
    • Claim Detail: Standard set of attributes
    • Entitlement Detail:  Standard set of attributes
    • Time - Claim Date:  Standard set of attributes
    • Time - Entitlement Date:  Standard set of attributes

• Subject Area: Maintenance Management - Asset Equipment Qualification
  • Update by Dimension Folder: A new Maintenance Management subject area is added to support asset equipment qualification:
    • Time - Qualified Date
    • Product
    • Inventory Organization
    • Work Order
    • Work Definition
    • Work Order Operations
    • Work Order Operation Resource
    • Resource Instance
    • Asset Details
    • Maintenance Program
    • Qualification Inspection Event Dispositions
    • Qualification Sample Results
    • Qualification Characteristics
    • Qualification Inspection Specifications
    • Qualification Samples
    • Qualification Inspection Events
    • Qualification Inspection Plan
    • Maintenance Equipment Requirement Inspection Plans
    • Maintenance Equipment Qualification Requirements
    • Maintenance Equipment Qualification Requirements Profile
    • Asset Qualification
    • Asset Qualification Details

Using OTBI, you can make better decisions based on real-time transactional information. In this update, you can 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).

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

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

These privileges were available prior to this update.