Includes nearly 60 views covering service requests, instances, tasks, and repairs, including repair and task related financial information, and details about service contracts.
Views for: Oracle TeleService, Oracle Install Base, Oracle Field Service, Oracle Depot Repair, and Oracle Service Contracts (Limited Availability)
Views (partial list)
Distinct views that return data on Service Requests created either using TeleService or Depot Repair.
Repair Order Invoices
Returns data on repair actual charges and sales order lines along with the associated invoices.
Debrief Charge Lines
Returns data on debrief charge lines, debriefs, sales orders and invoice details for a service request.
Instance Repair Orders
Returns data on repair orders associated with item instances.
Answers (partial list)
- What is the turnaround time for a service request?
- Which service requests are associated with an item instance?
- What is the total number of hours that a field service representative worked in a period?
- What are the Oracle Payables invoice details for a repair order?
- Which service contracts are going to expire in the next 30 days?