Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide Release 12.1 V5 Part Number E37993-08

Contents

Previous

Next

Oracle Outsourced Manufacturing Extensions for Oracle Endeca

This chapter covers the following topics:

• Overview
• Endeca Outsourced Manufacturing Search Page
• Setting Up Oracle Outsourced Manufacturing Extensions for Oracle Endeca
• Setup and Configuration Steps
• Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Outsourced Manufacturing
• Loading Outsourced Manufacturing Data into the Endeca Data Store
• Setting Up the Scheduler for Endeca Full Refresh
• ETL Parameters for Outsourced Manufacturing
• Views and Joins for Outsourced Manufacturing
• Menus for Endeca Outsourced Manufacturing

Overview

You can use the Oracle Outsourced Manufacturing Extension for Oracle Endeca to search and filter open subcontract orders, delayed subcontract orders, impacted customer orders, open replenishments, delayed replenishments, on-hand and in-transit inventory values, component consumption adjustments, quality rejects, rejected value, uninvoiced assemblies, and components. Using the Endeca Outsourced Manufacturing Search page from the Oracle Subcontracting dashboard, you can review and analyze data using Key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables.

You can search using a new Endeca Outsourced Manufacturing Search page utilizing Endeca Information Discovery (EID) design tools. This page is hosted in an EID environment, and called from new container pages in EBS. In Oracle Subcontracting, the following Endeca Outsourced Manufacturing Search page enables search functions using Endeca Information Discovery integration:

• Endeca Outsourced Manufacturing Search page: This page lets you quickly assess the state of the outsourcing process by identifying where component shortages occur, identifying assemblies and Manufacturing Partners (MP) with the most frequent scraps and production rejects and reasons, and identifying the top exception causes and corrective actions to take. Buyers can monitor payments due to the manufacturing partners and take appropriate actions to reduce payment backlog to promote positive supplier relationships. Buyers can also monitor on-hand inventory of manufacturing partners and take appropriate actions for better inventory and working capital management. The Endeca Outsourced Manufacturing Search page displays metrics, charts, tag clouds, and results tables.

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

Oracle Outsourced Manufacturing Extensions for Oracle Endeca User Interface

Endeca Outsourced Manufacturing Search Page

The Endeca Outsourced Manufacturing Search page for Oracle Subcontracting lets you monitor the health of your outsourcing process by searching for and displaying outsourced manufacturing information. Using the Guided Navigation, you can search on Organization Details, Subcontract Order Details, Replenishment Details, Component Details, Consumption Details, and Quality Details. You can view subcontracting metrics, charts, tag clouds, and transaction results tables. The following is a display of the Subcontracting Endeca Search page.

From the Subcontracting Super User responsibility, navigate to the Endeca Outsourced Manufacturing Search page:

(N) Subcontracting > Endeca Outsourced Manufacturing Search

(N) Subcontracting > Workbench > Dashboard (tab)

The following describes the Subcontracting Endeca Search page regions and components:

Oracle Outsourced Manufacturing Extensions for Oracle Endeca Product Configuration

Setting Up Oracle Outsourced Manufacturing Extensions for Oracle Endeca

The Oracle Outsourced Manufacturing application configuration and setup must be completed after the installation and common configurations are completed as described in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 (Doc ID: 1683053.1).

Setup and Configuration Steps

To set up Oracle Outsourced Manufacturing Extensions for Oracle Endeca, you must complete the following steps:

1. Set Access Control by assigning UMX roles and updating access grants.

2. Load Outsourced Manufacturing (Subcontracting) data to the Endeca Data Store by running graphs provided by Subcontracting.

3. Schedule Setup for Full Endeca Refresh.

Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Outsourced Manufacturing

As part of the Oracle E-Business Suite-EID integration for the Oracle Outsourced Manufacturing application, the following UMX Role is provided:

You must add the new UMX role 'Subcontracting Endeca Access Role' (Internal Code Name: UMX|JMF_SHIKYU_ENDECA_ACCESS_ROLE) to enable Endeca menus for the Subcontracting 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 Subcontracting Super User responsibility, the Endeca Search page 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):

1. Assign a UMX Role to the Responsibility.

2. Update JMF_SHIKYU_ENDECA_ACCESS_GRANT Grant.

For assigning UMX Roles and Grants, refer to Appendix C in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 (Doc ID: 1683053.1).

Loading Outsourced Manufacturing Data into the Endeca Data Store

Clover ETL within Endeca queries Subcontracting Views and does a full data load to the Subcontracting data store 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 Endeca Subcontracting data store which were updated in EBS after the last load. After the data has been loaded in the data store, it can be queried and shown in the Subcontracting pages.

Subcontracting Data Sources in the Subcontracting Data Store

The following data source is defined in the Subcontracting data store in Endeca and is used to query data for Subcontracting page. The data source includes:

• jmf - This data source queries data for the Subcontracting 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 Extensions for Oracle Endeca, Release 12.1 V5 (Doc ID: 1683053.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

1. Login to Integrator server using your Clover login.

2. Click the Scheduling tab.

3. Select the New Schedule link.

4. Enter a Description for the scheduler.

5. Select Periodic as the Type.

6. Select by interval as the Periodicity.

7. Enter a start date and time in the Not active before date/time field.

8. Enter an end date and time in the Not active after date/time field.

9. Enter a value in the Interval (minutes) field.

10. Ensure you select the Fire misfired event as soon as possible check box.

11. Select Start a graph from the Task Type list.

12. Select the graph for schedule to run. I.e. Full.grf/incremental.grf.

13. Click Create to set the scheduler.

ETL Parameters for Outsourced Manufacturing

You can load data to the JMF data store by running graphs provided by Subcontracting.

To load data to the JMF data store

1. Using the URL for the EID Integrator Server, navigate to the Sandboxes page and expand the graph node under Subcontracting.

2. Graphs to load data include:

   • FullLoadConfig.grf: This graph loads all Subcontracting dtata.

     Note: Data deleted in EBS (Subcontracting) 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.

   • IncrementalLoadConfig.grf: This graph loads changed Subcontracting data.

     Note: If you are loading data for the first time, then run FullLoadConfig.grf only. You can run other graphs according to your requirements. Run IncrementalLoadConfig.grf periodically. You can set up this graph from the Scheduling tab.

Views and Joins for Outsourced Manufacturing

The following views are used by the ETL layer in Endeca to load Subcontracting data to the Endeca data store:

Menus for Endeca Outsourced Manufacturing

Endeca Outsourced Manufacturing integration includes nine new user menu functions as follows:

Copyright © 2012, 2014, Oracle and/or its affiliates. All rights reserved.