Oracle Depot Repair Extensions for Oracle Endeca

This chapter covers the following topics:

Overview
Oracle Depot Repair Extensions for Oracle Endeca User Interface
Repair Orders Dashboard Page
Supplier Warranty Claims Dashboard Page
Overview
Set up Oracle Depot Repair Extensions for Oracle Endeca Integration
Running the Full Load Graph
Setting Up the Scheduler for Incremental Refresh
Roles in Oracle Depot Repair Extensions for Oracle Endeca
Grants in Oracle Depot Repair Extensions for Oracle Endeca
Permission Sets in Oracle Depot Repair Extensions for Oracle Endeca
Views and Joins to Load Oracle Depot Repair Extensions for Oracle Endeca Job Search
Menus and Functions in Oracle Depot Repair Extensions for Oracle Endeca

Overview

You can use Oracle Depot Repair Extensions for Oracle Endeca to search and filter the most critical service data in a single location and drill down to get more detailed information enabling you to take action using that information. As a service manager or a service technician, you can access the Repair Orders Dashboard. If you are a claims manager or a claims administrator, then you can access the Supplier Warranty Claims Dashboard. You use these dashboards to review and analyze data using key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables.

You can search using Oracle Depot Repair dashboard pages and Endeca Information Discovery (EID) design tools. These pages are hosted in an EID environment, and called from new container pages in EBS.

Oracle Depot Repair Extensions for Oracle Endeca User Interface and Integration

Oracle Depot Repair Extensions for Oracle Endeca User Interface

Oracle Depot Repair Extensions consists of two dashboards. Service managers and service technicians can access the Repair Orders Dashboard, and claims managers and claims administrators can access the Supplier Warranty Claims Dashboard.

Repair Orders Dashboard Page

Service managers and service technicians use the Repair Orders Dashboard page to view open and resolved orders to deal with current high-impact issues that need immediate resolution and to gather business intelligence and analysis of historical data. The Repair Orders Dashboard page consists of two tabs - Open and Resolved.

Open Tab

The Open tab in the Repair Orders page displays information about open orders and displays information and data graphically and in tabular format. The page consists of the following regions and components:

the picture is described in the document text

The Open tab page contains filtering components that you can use to search, navigate and filter the data displayed in other components:


Region
Metrics Bar	Open Repair Orders Escalated Aging On Hold Late Unassigned
Key Reports	Due Date Number of Repair Orders by Due Date Status Number of Repair Orders by Status Owner Number of Repair Orders by Owner Item Number of Repair Orders by Item
Repair Orders	Column Set: Repair Order Repair Number Repair Item Launch Technician Portal Launch Workbench Repair Type Flow Status Quantity Creation Date Resolve by Date Promise Date Date Closed Item Description Serial Number Owner Repair Org Inventory Org Repair Priority Problem Description Escalated Warranty Status Instance Number External Reference Instance Usage Install Location Contact Number Lot Number Item Revision Aging Rework Created By Flow Status External Quantity Received Quantity Shipped Quantity in WIP Late Service Code Service Code Description Diagnostic Code Description Root Cause Root Cause Description Time in Status Formatted Turn Time Resolution Time Time in Status Column Set: Service Request Repair Number Repair Item Launch Technician Portal Service Request Customer Account Name Summary Bill To Ship To Owner Contact Contact Phone Contact Email Type Severity Urgency Status Item Item Description Creation Date Created By Channel Account Number Customer Type Ship To City Ship To Country Customer Number Date Closed Column Set: Logistics Repair Number Repair Item Launch Technician Portal RMA Number RMA Item Receive Into Warehouse Receive Into Subinventory Return from Location Return Reason Date Received Sales Order Ship Item Ship From Org Ship To Location Planned Arrival Date Date Shipped RMA Creation Date Column Set: Internal Orders Repair Number Repair Item Launch Technician Portal Internal Sales Order Internal Order Item Ship From Org Receive Into Org
Record Details	Displays details of the selected Repair Number.
Item Name Tag Cloud	This tag cloud displays the distribution of all items in the result set.
Notifications	This displays notifications in a tabular format.

Resolved Tab

The Resolved tab in the Repair Orders page displays information about resolved orders and displays information and data graphically and in tabular format. The page consists of the following regions and components:

the picture is described in the document text

The Resolved tab page contains filtering components that you can use to search, navigate and filter the data displayed in other components:


Region	Components
Repair Order Metrics	Total Resolved Orders Meet Rate Rework Rate Turn Time (Minutes) Hold Time (Minutes) Orders Closed/Day Orders Opened/Day
Key Reports	Late Orders Late Repair Orders - Number of Late Repair Orders By Owner Late Repair Orders - Number of Late Repair Orders By Repair Item Rework Rework Orders - Number of Rework Orders by Owner Rework Orders - Number of Rework Orders by Item Turn Time Turn Time - Average Turn Time (Minutes) by Owner Turn Time - Average Turn Time (Minutes) by Repair Item. Hold Time Hold Time - Average Hold Time by Owner Hold Time - Average Hold Time by Repair Item Time in Status Time in Status - Average Time in Status (Minutes) by Status
Repair Orders	Column Set: Repair Order Repair Number Repair Item Launch Technician Portal Launch Workbench Repair Type Status Quantity Creation Date Resolve by Date Promise Date Date Closed Item Description Serial Number Owner Repair Org Inventory Org Repair Priority Problem Description Escalated Warranty Status Instance Number External Reference Instance Usage Install Location Contact Number Lot Number Item Revision Aging Rework Created By Flow Status External Quantity Received Quantity Shipped Quantity in WIP Late Service Code Service Code Description Diagnostic Code Diagnostic Code Description Root Cause Root Cause Description Time in Status Formatted Turn Time Resolution Time Time in Status Column Set: Service Request Repair Number Repair Item Launch Technician Portal Service Request Customer Account Name Summary Bill To Ship To Owner Contact Contact Phone Contact Email Type Severity Urgency SR Status Item Item Description Creation Date Created By Channel Account Number Customer Type Ship To City Ship To Country Customer Number Date Closed Column Set: Logistics Repair Number Repair Item Launch Technician Portal RMA Number RMA Item Receive Into Warehouse Receive Into Subinventory Return from Location Return Reason Date Received Sales Order Ship Item Ship From Org Ship To Location Planned Arrival Date Date Shipped RMA Creation Date Column Set: Estimate Repair Number Repair Item Launch Technician Portal Approval Status Estimate Status Column Set: Repair Actuals Repair Number Repair Item Launch Technician Portal Bill To Location Bill To Party Bill To Account Bill To Account Name Column Set: Jobs Repair Number Repair Item Launch Technician Portal Jobs Item Job Status Accounting Class Creation Date Operation Code Department Material Details Requisition Requisition Type Requisition Status Column Set: RO Tasks Repair Number Repair Item Launch Technician Portal Name Task Status Priority Type Owner Type Owner Assignee Type Assignee Planned Start Date Actual Start Date Actual End Date Scheduled Start Date Scheduled End Date Column Set: SR Tasks Repair Number Repair Item Launch Technician Portal Name Type Priority Task Status Owner Type Owner Assignee Type Assignee Planned Start Date Actual Start Date Actual End Date Scheduled Start Date Scheduled End Date Column Set: Internal Orders Repair Number Repair Item Launch Technician Portal Internal Sales Order Internal Order Item Ship From Org Receive Into Org
Record Details	Displays details of the selected Repair Number.
Notifications	This displays notifications in a tabular format.

Supplier Warranty Claims Dashboard Page

Claims managers and claims administrators can access the Supplier Warranty Claims Dashboard page to view open and resolved orders to gather business intelligence and analysis of historical data. The Supplier Warranty Claims Dashboard page consists of two tabs - In Process and Closed.

In Process Tab

The In Process tab in the Supplier Warranty Claims Dashboard page displays information about in process claims and displays information and data graphically and in tabular format.

the picture is described in the document text

The page consists of the following regions and components:


Region
Claims In Process Metrics	Claims in Process Amt of Claims in Process Aging Claims Amt of Aging Claims Disputed Claims Currency Code
Key Reports	Aging Number of Aging Claims Amount of Aging Claims Suppliers Number of Claims By Supplier Total Claim Amount By Supplier Status Number of Claims By Claim Status Total Claim Amount By Claim Status Parts Number of Claim Lines Total Claim Line Amount
Supplier Warranty Claims	Column Set: Claim Claim Number Claim Name View Claim Status Total Claim Amount Currency Code Claim Date Creation Date Month Year Quarter Claim Notes Column Set: Supplier Claim Number Claim Name View Claim Supplier Name Account Number Contact Name Area Code Phone Number Email Bill To Address Ship To Address
Supplier Warranty Claim Details	Displays the details of the selected Claim Number
Supplier Tag Cloud	This tag cloud displays the distribution of all suppliers with claims in the result set.
Notifications	This displays notifications in a tabular format.

Closed Tab

The Closed tab in the Supplier Warranty Claims Dashboard page displays information about closed claims and displays information and data graphically and in tabular format.

the picture is described in the document text

The page consists of the following regions and components:


Region	Component
Closed Claims Metrics	# of Settled Claims Amt of Settled Claims # of Rejected Claims Amt of Rejected Claims Amt Short Paid Average Days to Settle Settlement Rate Currency Code
Key Reports	Suppliers Number of Claims By Supplier Total Claim Amount By Supplier Parts Number of Claim Lines Total Claim Line Amount Turn Time Average Turn Time By Supplier Short Payments Number of Short Payments By Supplier Total Amount of Short Payments By Supplier Rejections Number of Rejected Claims By Supplier Total Amount of Rejected Claims By Supplier
Supplier Warranty Claims	Column Set: Claim Claim Number Claim Name View Claim Status Total Claim Amount Currency Code Claim Date Creation Date Month Year Quarter Claim Notes Column Set: Reimbursement Claim Number Claim Name View Claim Reimbursement Type Reimbursement Amount Currency Code Reimbursement Date Reimbursement Notes Reference Document Column Set: Supplier Claim Number Claim Name View Claim Supplier Name Account Number Contact Name Area Code Phone Number Email Bill To Address Ship To Address
Supplier Warranty Claim Details	Displays the details of the selected Claim Number
Supplier Tag Cloud	This tag cloud displays the distribution of all suppliers with claims in the result set.
Notifications	This displays notifications in a tabular format.

Oracle Depot Repair Extensions for Oracle Endeca Product Configuration

Overview

Complete the Oracle Depot Repair product configuration after the installation and common configurations are completed as described in the Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1).

Set up Oracle Depot Repair Extensions for Oracle Endeca Integration

Add the Depot: Endeca Access Role to any predefined Oracle Depot Repair responsibility or to any custom Depot Repair responsibility. Update the Grant CSD_ENDECA_ACCESS_GRANT and the Permission Set CSD_ENDECA_ACCESS_PS.

See: Oracle E-Business Suite System Administrator's Guide - Security for more information on how to assign roles.

See: Grants in Oracle Depot Repair Extensions for Oracle Endeca

See: Permission Sets in Oracle Depot Repair Extensions for Oracle Endeca

See: Oracle E-Business Suite System Administrator's Guide - Security for more information on how to assign roles.

See: Appendix C: Adding Roles to Responsibilities and Setting Security Context in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1)
Run the Full Graph to complete the initial data load for Oracle Depot Repair Extensions.

See: Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 (Doc ID: 1683053.1)
Run the Full Load Graph.

See: Running the Full Load Graph
Set up the Scheduler.

See: Setting Up the Scheduler to Load Incremental Graphs

Running the Full Load Graph

Once you have run the full load graph in accordance with the Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1), attribute configuration is loaded for all seeded attributes. Additionally, you need to run the following full data loads as follows:

To run a full Endeca Refresh on the Integrator Server

Login to Integrator server using your Clover login.
Click the Scheduling tab.
Select the New Schedule link.
Enter a Description for the scheduler, for example, Depot Repair Full Load Load Scheduler.
Select Periodic as the Type.
Select by interval as the Periodicity.
Enter a start date and time in the Not active before date/time field.
Enter an end date and time in the Not active after date/time field.
Enter a value in the Interval (minutes) field.
Ensure you select the Fire misfired event as soon as possible check box.
Select Execute graph from the Task Type list.
Select csd from the Sandbox list.
Select graph/FullLoadConfig.grf from the Graph list.
Click Create to set the scheduler.

Setting Up the Scheduler for Incremental Refresh

Once the Full graph is run in accordance with the Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1), initial data load for Depot Repair is complete. For incremental refresh, you must determine how often the Endeca data should be refreshed from EBS depending upon your organizational requirements. Oracle recommends that you keep this near real time. As the data is updated in the EBS, you need to ensure it is updated in the endeca MDEX server. You set up the Scheduler to load incremental graphs depending on the volume of information requiring update.

To set up the scheduler

Login to Integrator server using your Clover login.
Click the Scheduling tab.
Select the New Schedule link.
Enter a Description for the scheduler, for example, Depot Repair Incremental Load Scheduler.
Select Periodic as the Type.
Select by interval as the Periodicity.
Enter a start date and time in the Not active before date/time field.
Enter an end date and time in the Not active after date/time field.
Enter a value in the Interval (minutes) field.
Ensure you select the Fire misfired event as soon as possible check box.
Select Start a graph from the Task Type list.
Select csd from the Sandbox list.
Select graph/IncrementalLoadConfig.grf from the Graph list.
Click Create to set the scheduler.

Technical Integration Components

Roles in Oracle Depot Repair Extensions for Oracle Endeca

Role Name: Depot: Endeca Access Role
Code: CSD_ENDECA_ACCESS_ROLE

Grants in Oracle Depot Repair Extensions for Oracle Endeca

Grant Name: Depot: Endeca Access Role
Grant Code: CSD_ENDECA_ACCESS_GRANT
Grantee Type: Group of Users
Grantee: Depot: Endeca Access Role
Responsibility - select a predefined responsibility or a custom responsibility of your choice
Permission Set Code: CSD_ENDECA_ACCESS_PS
Permission Set Name- Depot: Endeca Access Permission Set

Permission Sets in Oracle Depot Repair Extensions for Oracle Endeca

Permission Set Name- Depot: Endeca Access Permission Set
Permission Set Code - CSD_ENDECA_ACCESS_PS
Permissions Included in the Set: Depot: Repair Orders Endeca Page (CSD_ENDECA_REPAIRS_DASHBOARD_PG) and Depot: Supplier Warranty Endeca Dashboard PG (CSD_ENDECA_SUPWAR_DASHBOARD_PG)

Views and Joins to Load Oracle Depot Repair Extensions for Oracle Endeca Job Search

The following views are used by the ETL layer in Oracle Endeca to load and display Oracle Depot Repair Extensions for Oracle Endeca data to the Oracle Endeca data store:

CSD_EID_SW_CLAIM_LINES_V - View to load Supplier Warranty Claims information.
CSD_EID_REPAIRS_V - View to load Repair Orders information.

Menus and Functions in Oracle Depot Repair Extensions for Oracle Endeca

The following functions are available for the Depot Repair Depot Menu (CSD_DEPOT_MENU) in Oracle Depot Repair Extensions for Oracle Endeca:


Function Code	User Function Name	Function Type	Web HTML Call
CSD_ENDECA_SUPWAR_DASHBOARD_PG	Supplier Warranty Claims Dashboard	JSP	OA.jsp?page=/oracle/apps/csd/endeca/supwar/webui/EndecaSupwarrantyPG
CSD_ENDECA_REPAIRS_DASHBOARD_PG	Repair Orders Dashboard	JSP	OA.jsp?page=/oracle/apps/csd/endeca/ro/webui/EndecaRepairDashboardPG

The following functions are available for the Depot Repair Supplier Warranty Menu (CSD_SUPPLIER_WARRANTY_SUBMENU) in Oracle Depot Repair Extensions for Oracle Endeca:


Function Code	User Function Name	Function Type	Web HTML Call
CSD_ENDECA_SUPWAR_DASHBOARD_PG	Supplier Warranty Claims Dashboard	JSP	OA.jsp?page=/oracle/apps/csd/endeca/supwar/webui/EndecaSupwarrantyPG