Oracle Enterprise Asset Management Information Discovery Plus

This chapter covers the following topics:

Overview
Overview Region in the eAM Maintenance Home Page
Assets Overview Page
Work Requests Overview Page
Work Orders Overview Page
Materials Overview Page
Setting Up Oracle Enterprise Asset Management Information Discovery Plus
Setup and Configuration Steps
Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Enterprise Asset Management (eAM)
Loading eAM Data into the Data Domain
Setting Up the Scheduler for Endeca Full Refresh
ETL Parameters for Enterprise Asset Management (eAM)
Profile Options for Enterprise Asset Management (eAM)
Views and Joins for Enterprise Asset Management (eAM)
Menus for Endeca Enterprise Asset Management (eAM)

Overview

You can use Oracle Enterprise Asset Management Information Discovery Plus to search and filter assets, work requests, work orders, and item information. Using the Information Discovery dashboard pages, you can review and analyze data using key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables.

You can search using eAM pages and Information Discovery (EID) design tools. These pages are hosted in an EID environment, and called from new container pages in EBS. In eAM, the following region and pages enable search functions using Information Discovery integration:

Overview Region in the Maintenance Home Page: This page under the Maintenance Home tab lets you search for work orders and assets. The page displays work order and asset metrics, work order charts, and a work order results table.
Assets Overview Page: This page under the Assets tab lets you search for assets. The page displays asset metrics, asset charts, and an asset results table.
Work Requests Overview Page: This page under the Work Request tab lets you search for work requests. The page displays work request metrics, work request charts, and a work request results table.
Work Orders Overview Page: This page under the Work Order tab lets you search for work orders. The page displays work order metrics, work order charts, and a work orders results table.
Materials Overview Page: This page under the Stores tab lets you search for items. The page displays item metrics and an item results table.

This chapter provides product-specific details required to integrate Endeca Information Discovery (EID) with Oracle E-Business Suite Release 12.2 V8 for the Oracle Enterprise Asset Management Information Discovery Plus application. This supplements the information provided in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1). You must read this document and make note of the requirements before you begin your installation.

Oracle Enterprise Asset Management Information Discovery Plus User Interfaces

Overview Region in the eAM Maintenance Home Page

The Overview region in the eAM Mainenance Home page displays Endeca content for Oracle Enterprise Asset Management. You can search for work orders and assets, and view work order and asset metrics, work order charts, and a work order results table. The following is a partial display of the Endeca region in the eAM Maintenance Home page.

From the Maintenance Super User responsibility, navigate to the eAM Home page:

(N) Maintenance Super User > Home

the picture is described in the document text

Within the Overview region on the eAM Maintenance Home page, you can track work order and asset activity. You can analyze data and review work order and assets metrics, charts, graphs, and tables. The following describes the eAM Maintenance Home page Endeca regions and components:

Region	Components
Advanced Search Boolean Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Department Work Order Asset Activity Operation Resource Failure Dates Warranty Flexfield Asset Attributes Item Instance Flexfields Discrete Job Operation Information Operation Resource
Asset (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good - Gray: Normal	Capital Asset Count Number of distinct Capital Assets . Rebuildable Count Number of distinct Rebuildable Assets. Asset Group Count Number of distinct Asset Groups. Asset Org Count Number of Asset Organizations to which different Assets are assigned.
Work Order (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good - Gray: Normal	Work Order Count Number of distinct work orders. Total Cost Sum of total actual cost in all the work orders. Schedule Compliance (Number of completed work orders (on time) divided by number of scheduled work orders) x 100 Failure Count Number of Work Orders which have failure data.
Asset Activity (tag cloud)	Top Ten Asset Activities Tag Cloud Component Note: The Asset Activity tag cloud component displays the top ten asset activities by frequency of occurrence.
Work Orders (tabbed component container) Work Orders (tab)	Work Order Count by Start Date (chart) Sort Options Start Date (days from today) Start Date (days from today) by Work Order Count Dimensions (category axis) Start Date (days from today) Month Quarter Year Series Dimension (color) (none) Status Priority Type Work Order Count by Resource, Status (chart) Sort Options Resource Resource By Work Order Count Series Dimension (color) (none) Status Priority Type
Work Orders (tabbed component container) Work Order Count by Operation Department (tab)	Work Order Count by Operation Department (cross tab)
Work Orders (tabbed component container) Work Order Count by Resource (tab)	Work Order Count by Resource (cross tab)
Work Orders (tabbed component container) Work Order Count by Employee or Equipment (tab)	Work Order Count by Employee or Equipment (cross tab)
Work Orders (results table)	Work Orders (tab) (results table) Column Sets Work Order Asset Activity Department Cost Dates Failure Attachment Flexfield Warranty Actions Print Export Compare Print Work Order Report Export Work Order Schedule Map All Operations (tab) (results table) Column Sets Operation Work Order Asset Activity Dates Department Resource Cost Failure Attachment Flexfield Warranty Actions Print Export Print Work Order Report Export Work Order Schedule Map All

Assets Overview Page

Use the eAM Assets Overview page to search for and view asset information and activity. You can view asset metrics, asset charts, and an assets results table. The following is a partial display of the eAM Assets Overview page.

From the Maintenance Super User responsibility, navigate to the eAM Assets page:

(N) Maintenance Super User > Home > Assets (tab)

the picture is described in the document text

Within the eAM Assets Overview page, you can track assets and asset group activity. You can analyze data and review assets and activity, asset metrics, charts, graphs, and tables. The following describes the Endeca eAM Assets Overview page regions and components:

Region	Components
Advanced Search Boolean Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Department Work Order Asset Activity Operation Resource Failure Dates Warranty Flexfield Asset Attributes Item Instance Flexfields Discrete Job Operation Information Operation Resource
Asset (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good - Gray: Normal	Capital Asset Count Number of distinct capital assets. Rebuildable Count Number of distinct rebuildable assets. Asset Group Count Number of distinct asset groups. Asset Org Count Number of distinct asset organizations.
Asset Group (tag cloud)	Top Ten Asset Groups Tag Cloud Component Note: The Asset Groups tag cloud component displays the top ten asset groups by frequency of occurrence.
Assets (results table)	Assets (results table) Actions Print Export Map All Links Create Work Order icon - select this link to open the Create Work Order html page. Create Work Request icon - select this link to open the Create Work Request html page to request maintenance on an asset. Asset Number - select the Asset Number link for the selected row to open the Asset Details html page to view specific details about an asset number.
Assets (tabbed component container) Asset Count (tab)	Assets (chart) Sort Options Asset Organization Asset Organization by Asset Count Dimensions (category axis) Asset Organization Category Asset Group Area Asset Owning Department Series Dimension (color) (none) Asset Type Maintainable
Assets (tabbed component container) Work Order Count by Asset (tab)	Work Orders (results table) Actions Print Export
Assets (tabbed component container) Asset Maintenance Cost (tab)	Assets (results table) Actions Print Export
Assets (tabbed component container) Asset Maintenance Cost by Year (tab)	Maintenance Cost for Assets by Year (cross tab) Actions Export to Microsoft Excel Print
Assets (tabbed component container) Failure Analysis (tab)	Cost Analysis by Failure Sort Options Failure Total Cost (sum) by Failure Metric (value axis) Total Cost (sum) Estimated Total Cost (sum) Total Equipment Cost (sum) Total Labor Cost (sum) Total Material Cost (sum) Dimensions (category axis) Failure Asset Group Month Quarter Year Series Dimension (color) (none) Failure Cause Resolution Cost Analysis by Cause Sort Options Cause Total Cost (sum) by Cause Metric (value axis) Total Cost (sum) Estimated Total Cost (sum) Total Equipment Cost (sum) Total Labor Cost (sum) Total Material Cost (sum) Dimensions (category axis) Cause Resolution Asset Group Month Quarter Year Series Dimension (color) (none) Failure Cause Resolution
Work Orders (tabbed component container) Work Orders (tab)	Work Orders (results table) Column Sets Work Order Asset Activity Department Cost Dates Failure Attachment Flexfield Warranty Links Work Order link - select this link for the selected row to open the Work Order Details html page. Asset Number link - select this link to open the Asset Details html page to view specific details about an asset number. Actions Print Export Print Work Order Report Export Work Order Schedule Map All
Work Orders (tabbed component container) Operations (tab)	Operations (results table) Column Sets Operation Work Order Asset Activity Dates Department Resource Cost Failure Warranty Flexfield Attachment Links Work Order link - select this link for the selected row to open the Work Order Details html page. Asset Number link - select this link to open the Asset Details html page to view specific details about an asset number. Actions Print Export Print Work Order Report Export Work Order Schedule Map All

Work Requests Overview Page

Use the Work Requests Overview page to search for work requests, work request types, and work request activity . You can view work request metrics, work request charts, and a work request results table. The following is a partial display of the eAM Work Requests Overview page.

From the Maintenance Super User responsibility, navigate to the eAM Work Requests page:

(N) Maintenance Super User > Home > Work Requests (tab)

the picture is described in the document text

Within the Work Requests page, you can track work requests and activity. You can analyze data and review work requests, metrics, charts, graphs, and tables. The following describes the Endeca eAM Work Requests page regions and components:

Region	Components
Page Links	Overview - select this link to open the Endeca Work Requests Overview page to search for work requests, types, and work request activity. All - select this link to open the Work Requests html page to search for existing work requests and create new work requests for an asset. Create Work Request - select this link to open the Create Work Request html page to create new work requests for an asset.
Advanced Search Boolean Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Multi-view Available Refinements	You can use the Multi-view Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Work Order Work Order Asset Flexfield Asset Attributes Item Instance Flexfields Discrete Job Operation Information Operation Resource Work Request Work Request Work Request Dates Work Request Information Work Request Information (Descriptive Flexfield)
Work Request (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good	Number of Work Requests Total number of Work Requests. Open Work Requests Number of Open Work Requests (Statuses: Open and Additional Information) Work Requests Awaiting Work Orders Number of Work Requests awaiting Work Orders.
Work Request Type (tag cloud)	Top Ten Work Request Type Tag Cloud Component Note: The Work Request Type tag cloud component displays the top ten work request types by frequency of occurrence.
Work Requests (tabbed component container) Work Requests (tab)	Work Requests (chart) Sort Options Asset Number Asset Number by Work Request Count Dimensions (category axis) Asset Number Asset Category Asset Group Asset Area Organization Series Dimensions (color) (none) Asset Criticality Asset Type Department Priority Request Type Work Request Count by Asset (cross tab) Links Asset Number link - select this link to open the Asset Details html page for the selected row to view specific details about an asset number. Actions Print Export
Work Requests (results table)	Work Requests (results table) Column Sets Work Request Work Request Dates Asset Work Order Flex Field Links Number link - select this link to open the View Work Request details html page. Actions Print Export

Work Orders Overview Page

You can use the Work Orders Overview page to search for work orders, work order types, and work order activity. You can view work order metrics, work order charts, and a work orders results table. The following is a display of the eAM Work Orders Overview page.

From the Maintenance Super User responsibility, navigate to the eAM Work Orders Overview page:

(N) Maintenance Super User > Home > Work Orders (tab)

the picture is described in the document text

Within the Work Orders Overview page, you can track work orders and work order activity. You can analyze data and review work order orders, metrics, charts, graphs, and tables. The following describes the Endeca eAM Work Orders Overview page regions and components:

Region	Components
Page Links	Overview - select this link to open the Endeca Work Orders Overview page to search for work orders, types, and work order activity. All - select this link to open the Work Requests html page to search for existing work requests and create new work requests for an asset. Requests - select this link to open the Requests Search page to search for and view work request details. Express Work - select this link to open the Express Work Order html page to create work orders for work that has already been completed. Crew Schedule - select this link to open the Crew Schedule html page to view work schedules. Mass Time Entry - select this link to open the Mass Time Entry html page to enter time and operation details against a work order. Generate PM Work Orders - select this link to open the Schedule Request html page to create Preventive Maintenance (PM) work orders.
Advanced Search Boolean Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Department Work Order Asset Activity Operation Resource Failure Dates Warranty Flexfield Asset Attributes Item Instance Flexfields Discrete Job Operation Information Operation Resource
Work Order (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good - Gray: Normal	Work Order Count Number of distinct work orders. Open Work Order Count Number of distinct Open work orders. Schedule Compliance (Number of Work Orders completed on time divided by total number of Work Orders) x 100. Work Orders are completed on time if Actual Start Date of a Work Order is less than or equal to Scheduled Start Date. Total Cost Sum of total actual cost in all work orders. Estimated Cost Sum of total estimated cost in all work orders.
Work Order Type (tag cloud)	Top Ten Work Order Type Tag Cloud Component Note: The Work Order Type tag cloud component displays the top ten work order types by frequency of occurrence.
Work Orders (tabbed component container) Work Orders (tab)	Work Orders (chart) Sort Options Asset Number Asset Number by Work Order Count Metric (value axis) Work Order Count Actual Cost Estimated Cost Labor Cost Material Cost Equipment Cost Dimensions (category axis) Asset Number Asset Group Category Organization Work Order Owning Department Source Cause Activity Type Schedule Name Project Task Series Dimensions (color) (none) Status Work Order Type Priority Asset Type Criticality Cause Failure Resolution
Work Orders (tabbed component container) Operation Count by Resource (tab)	Operations Assigned to Employee or Equipment (results table) Actions Print Export Operations Assigned to Resource (results table) Actions Print Export
Work Orders (tabbed component container) Operation Count by Department and Resource (tab)	Operation Count by Operation Department and Resource (cross tab) Actions Export to Microsoft Excel Print
Work Orders (tabbed component container) Work Orders (tab)	Results Table Column Sets Work Order Dates Asset Activity Cost Failure Attachment Flexfield Warranty Actions Print Export Print Work Order Report Export Work Order Schedule Map All
Work Orders (tabbed component container) Operations (tab)	Results Table Column Sets Operation Work Order Asset Activity Department Resource Cost Dates Failure Attachment Flexfield Warranty Actions Print Print Work Order Report Export Work Order Schedule Map All Export Note: You can select a Work Order from the list and add operations attachments against the work orders in EBS for various file formats. Format types allowed include: Long Text Short Text File URL

Materials Overview Page

Use the Materials Overview page under the Stores tab to search for items, item details, and activity. You can view item metrics. subinventories, and an item results table. The following is a display of the eAM Materials Overview page.

From the Maintenance Super User responsibility, navigate to the eAM Materials Overview page:

(N) Maintenance Super User > Home > Stores (Tab)

the picture is described in the document text

Within the Materials Overview page, you can track item, inventory, and sub-inventory information and activity. You can view item and inventory, metrics, and an Item results table. The following describes the Endeca eAM Materials Overview page regions and components:

Region	Components
Page Links	Overview - select this link to open the Endeca Material Overview page to search for items, item details, and activity. Material Issue - select this link to open the Material Issue html page to search for material allocations by material request number. One Step Material Issue - select this link to open the One Step Material Issue html page. A one-step material issue does not create a request and is used to issue one-off or ad hoc material to a work order. Return Material to Inventory - select this link to open the Return Material to Inventory html page to return material to inventory from a maintenance work order. Only material issued to work orders can be returned to Inventory.
Advanced Search Boolean Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Inventory Organization Subinventory Item Item Description Asset Group/Activity (BOM) Item Type Cross Reference Type Cross Reference Cross Reference Description Manufacturer Manufacturer Part Number UOM
Item (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: - Red: Critical warning state - Green: Good - Gray: Normal	Item Count Total Items Subinventory Count Total subinventory items.
Subinventories (tag cloud)	Top Ten Subinventories Tag Cloud Component Note: The Subinventories tag cloud component displays the top ten subinventories by frequency of occurrence.
Items (results table)	Items (results table) Actions Print Export

Oracle Enterprise Asset Management Information Discovery Plus Product Configuration

Setting Up Oracle Enterprise Asset Management Information Discovery Plus

The Oracle Enterprise Asset Management (eAM) application configuration and setup must be completed after the installation and common configurations are completed as described in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1).

Setup and Configuration Steps

To set up Oracle Enterprise Asset Management Information Discovery Plus, you must complete the following steps:

Set Access Control by assigning UMX roles and updating access grants.
Load eAM data to the Endeca Data Domain by running graphs provided by eAM.
Schedule Setup for Full Endeca Refresh.
Set Profile Options.

Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Enterprise Asset Management (eAM)

As part of the Oracle E-Business Suite-EID integration for the Oracle Enterprise Asset Management (eAM) application, the following UMX Role is provided:

UMX Role	Internal Code Name
EAM Endeca Access Role	UMX\|EAM_ENDECA_ ACCESS_ROLE

You must add the new UMX role 'EAM Endeca Access Role' (Internal Code Name: UMX|EAM_ENDECA_ ACCESS_ROLE) to enable Endeca menus for the Maintenance Super User responsibility (or any other custom responsibility which is using the same menu). You must assign this UMX role to the responsibility. When this UMX role is assigned to the eAM Information Portal, the Information Discovery tab appears.

If you want to use the Endeca-related role with more than one responsibility, then you must have an additional grant with a security context corresponding to each responsibility. You can add grants for a given role as a separate process instead of while you are adding the role to the responsibility.

Complete the following steps to enable Endeca Menus in Oracle E-Business Suite (EBS):

Assign a UMX Role to the Responsibility.
Update EAM_ENDECA_ACCESS_GRANT Grant.

For assigning UMX Roles and Grants, refer to Appendix C in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1).

Loading eAM Data into the Data Domain

Clover ETL within Endeca queries eAM Views and does a full data load to the eAM data domain in Endeca. After the first data load, full data load or incremental data load can be performed periodically. Incremental data load will update all the records in the Endeca eAM data domain which were updated in EBS after the last load. After the data has been loaded in the eAM data domain, it can be queried and shown in the eAM pages.

eAM Data Sources in eAM Data Domain

Three data sources are defined in the eAM data domain in Endeca and are used to query data for different pages in eAM. These data sources include:

eam-wo: This data source queries data for the Home Page, Work Order page, and Asset Page.
eam-wr: This data source queries data for the Work Request Page.
eam-mat: This data source queries data for the Stores Page.

Setting Up the Scheduler for Endeca Full Refresh

The initial data upload for Endeca Search is complete when the Full graph is run as described in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1). Full refresh deletes all data from Endeca and repopulates it with a full data extract from the E-Business Suite system. For incremental refresh, you should determine how often the Endeca data should be refreshed from E-Business Suite depending on your organizational requirements.

To schedule ETL 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.
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 the graph for schedule to run. I.e. Full.grf/incremental.grf.
Click Create to set the scheduler.

ETL Parameters for Enterprise Asset Management (eAM)

You can load data to the eAM data domain by running graphs provided by eAM.

To load data to the eAM data domain

Using the URL for the EID Integrator Server, navigate to the Sandboxes page and expand the graph node under eAM.
Graphs to load data include:
- LoadDataFull.grf: This graph loads data from Work Order View, Work Request View, and Material View. This graph is for internal use.
- LoadDataIncr.grf: This graph loads incrementally changed order line transaction data. This graph is for internal use.
- Full.grf: This graph loads metadata and data from all views. It resets all records in the eAM data domain, and then loads data. Run this graph if you plan to load data for all pages. This graph will load data for Home, Assets, Work Requests, Work Orders, and Material pages.
- Incremental.grf: This graph performs incremental load for work orders, work requests and assets. Only those records that were updated subsequent to the last load are loaded.
  
  Note: Data deleted in EBS (eAM) will not be removed from Endeca by running Incremental Graph. You must run Full.grf graph to remove all the data from Endeca and reload everything. If you are loading data for the first time, then run Full.grf only. You can run other graphs according to your requirements. Run Incremental.grf periodically. You can set up this graph from the Scheduling tab.

Profile Options for Enterprise Asset Management (eAM)

You must set the following profile options if you do not want to load all historical data. Oracle recommends that you load data for all years. If you do not set the following profile options, then all Work Order, Asset, and Work Request data will be loaded.

Profile Option Name	Description
EAM : Endeca Work Order Data Load Start Date (mm/dd/yyyy)	Loads all Work Orders created on and after the specified date to the Endeca Data Domain.
EAM : Endeca Work Request Data Load Start Date (mm/dd/yyyy)	Loads all Work Requests created on and after the specified date to the Endeca Data Domain.
FND: Endeca Portal URL	This profile acts as the gateway between EBS and Endeca to bring the Endeca pages from the Endeca Studio Portal Server.

Views and Joins for Enterprise Asset Management (eAM)

The following views are used by the ETL layer in Endeca to load eAM data to the Endeca data domain:

View Name	Purpose
EAM_EID_WORK_ORDERS_V	Loads work order and asset data
EAM_EID_WORK_REQUESTS_V	Loads work request data
EAM_EID_MATERIALS_V	Loads material data

The following temporary views are used as part of parallel processing for use with flexfields and attachments.

View Name	Purpose
EAM_EID_WO_PROCESS_TEMP	Loads flexfield and attachments of work orders and assets.
EAM_EID_WR_PROCESS_TEMP	Loads work request flexfield and attachment details.
EAM_EID_MAT_PROCESS_TEMP	Loads flexfield and attachment details for materials in the Store (Materials) page.

Menus for Endeca Enterprise Asset Management (eAM)

Endeca Enterprise Asset Management (eAM) integration includes nine new user menu functions as follows:

User Function Name	Function Name
EAM Endeca Home Page Destination	EAM_ENDECA_HOME_DEST
EAM Endeca Asset Landing Page	EAM_ENDECA_ASSET_LANDING_PAGE
EAM Endeca Assets Page Destination	EAM_ENDECA_ASSET_DEST
EAM Endeca Work Order Landing Page	EAM_ENDECA_WO_LANDING_PAGE
EAM Endeca Work Order Page Destination	EAM_ENDECA_WO_DEST
EAM Endeca Work Request Landing Page	EAM_ENDECA_WR_LANDING_PAGE
EAM Endeca Work Request Page Destination	EAM_ENDECA_WR_DEST
EAM Endeca Stores Landing Page	EAM_ENDECA_MAT_LANDING_PAGE
EAM Endeca Stores Page Destination	EAM_ENDECA_MAT_DEST

Home: One new function added to the existing Home menu
Asset: Two new functions added to the existing Assets menu
Work Order: Two new functions added to the existing Work Orders menu
Work Request: Two new functions added to the existing Work Request menu
Materials (Under Stores Tab): Two new functions added to the existing Stores menu
Permission Set: New Permission set 'EAM Endeca Access Permission Set' has been created and all new functions are assigned to this permission set