Skip Headers

Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide
Release 12.1.3.4
Part Number E37993-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Outsourced Manufacturing Extensions for Oracle Endeca

This chapter covers the following topics:

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:

This chapter provides product-specific details required to integrate Endeca Information Discovery (EID) with Oracle E-Business Suite Release 12.1.3.3. This supplements the information provided in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID: 1562372.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 picture is described in the document text

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

Region Components
Alerts The Subcontracting Alerts region displays notifications of delayed subcontract orders. The Alerts region also identifies potential delayed subcontract orders by reviewing subcontract orders containing unallocated components with a subcontract order required date within 7 days from the current date.
Guided Navigation You can use the Guided Navigation component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names:
  • Subcontract Order Details

  • Subcontract Order Quantity and Price

  • Subcontract Order Dates

  • Organization Details

  • Replenishment Details

  • Replenishments Quantity and Price

  • Replenishment Dates

  • Component Details

  • Component Price and Quantity

  • Consumption Details

  • Consumption Quantity

  • Quality Details

  • Quality Quantity and Price

  • Quality Dates

Outsourcing Metrics (metrics bar)

Note: The Metric Components are color coded to highlight warnings and health:

- Red: Critical warning state

- Yellow: Warning

- Gray: Normal

- Green: Good

  • Open Subcontract Orders

  • Delayed Subcontract Orders

  • Impacted Customers

  • Open Replenishments

  • Delayed Replenishments

  • On Hand Value At MP

  • In Transit Value

  • Subcontract Orders with Quantity

  • Subcontract Orders with Rejections

  • Rejected Assemblies

  • Uninvoiced Replenishments

  • Uninvoiced Assemblies

Component Adjustment Reason (tag cloud component) Top Ten Component Adjustment Reason Tag Cloud Component

Note: The Component Adjustment Reason tag cloud component displays the top ten Component Adjustment Reasons by frequency of occurrence.

Subcontracting Order Insights (tabbed component container)
Subcontract Order (tab)
Subcontract Order Allocations (chart)
  • Sort Options

    • Subcontract Allocations

    • Subcontract Allocations by Subcontract Order (count distinct)

  • Series Dimension (color)

    • MP Organization Code

    • Component Category Name

    • Assembly Category Name

    • Is Customer Order Associated


Subcontract Orders Schedule Status (chart)
  • Sort Options

    • Subcontract Order Schedule Status

    • Subcontract Order Schedule Status by Subcontract Order (count distinct)

  • Series Dimension (color)

    • Is Customer Order Associated

    • MP Organization Code

    • OEM Organization Code

    • Assembly Name

    • Customer Sales Order


Subcontract Order Pending Value (chart)
  • Sort Options

    • Assembly Name

    • Assembly Name by Pending Order Value (sum)

  • Dimensions (category axis)

    • Assembly Category Name

    • Assembly Name

    • OEM Organization Code

    • MP Organization Code

Subcontracting Order Insights (tabbed component container)
Replenishments (tab)
Replenishment Allocations (chart)
  • Sort Options

    • RSO Allocations

    • RSO Allocations by RSO Number (count distinct)

  • Series Dimension (color)

    • Component Category Name

    • OEM Organization Code

    • MP Organization Code

    • Assembly Category Name


Replenishments Schedule Status (chart)
  • Sort Options

    • Shipments Schedule Status

    • Shipments Schedule Status by RSO Number (count distinct)

  • Series Dimension (color)

    • OEM Organization Code

    • MP Organization Code

    • Component Category Name

    • Is Customer Order Associated

    • Dropship PO Supplier

Subcontracting Order Insights (tabbed component container)
Inventory (tab)
Component Value (chart)
  • Sort Options

    • MP Organization Code

    • MP Organization Code by On Hand Value at MP (sum)

    • MP Organization Code by In Transit Value (sum)

  • Series Dimension (color)

    • OEM Organization Code

    • Component Category Name


Component Details (cross tab)
  • Column Sets

    • Component Overview

    • Component Quantity and Price Details

Subcontracting Order Insights (tabbed component container)
Consumptions (tab)
Consumption Overview (chart)
  • Sort Options

    • Subcontract Adjustment Reason

    • Subcontract Adjustment Reason by Adjustment Value (sum)

  • Series Dimension (color)

    • OEM Organization Code

    • Component Category Name


Consumption Details (cross tab)
  • Column Sets

    • Adjustment Details

    • Adjustment Quantity

Subcontracting Order Insights (tabbed component container)
Financials (tab)
Uninvoiced Replenishments (chart)
  • Sort Options

    • Component Category Name

    • Component Category Name by Uninvoiced Replenishment (sum)

  • Dimensions (category axis)

    • Component Category Name

    • OEM Organization Code

    • MP Organization Code


Uninvoiced Assemblies (chart)
  • Sort Options

    • Assembly Name

    • Assembly Name by Uninvoiced Assemblies (sum)

  • Dimensions (category axis)

    • Assembly Category Name

      • Assembly Name

    • OEM Organization Code

    • MP Organization Code

Subcontracting Order Insights (tabbed component container)
Quality (tab)
Reject Reasons (chart)
  • Sort Options

    • MP Organization Code

    • MP Organization Code by Rejected Assemblies (sum)

  • Dimensions (category axis)

    • MP Organization Code

    • OEM Organization Code

    • Assembly Category Name

  • Series Dimensions (color)

    • (none)

    • Rejection Reason


Quality Details (cross tab)
  • Column Sets

    • Subcontract Order Details

    • Quality Inspection

Subcontract Order Search Results (tabbed component container)
Subcontract Order Details (tab)
Subcontract Order Details (results table)
  • Column Sets

    • Subcontract Order Details

    • Work Order Details

    • Customer Sales Order Details

    • Assembly Details

    • Organization Details

    • Subcontract Quantities and Price

Subcontract Order Search Results (tabbed component container)
Replenishment Details (tab)
Replenishment Details (results table)
  • Column Sets

    • RSO Details

    • RSO Quantities and Price

    • Organization Details

    • Dropship Details

Subcontract Order Search Results (tabbed component container)
Component Details (tab)
Component Details (results table)
  • Column Sets

    • Component Details

    • Component Quantities and Prices

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.3.4 (Doc ID: 1562372.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:

UMX Role Internal Code Name
Subcontracting Endeca Access Role UMX|JMF_SHIKYU_ENDECA_ACCESS_ROLE

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.

Permission Set Internal Code Name
Subcontracting Endeca Permission Set JMF_SHIKYU_ENDECA_ACCESS_PS

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.3.4 (Doc ID: 1562372.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:

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.3.4 (Doc ID: 1562372.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:

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:

View Name Purpose
JMF_EID_SUBCONDET_V Loads subcontracting order and replenishments data.
JMF_EID_SUBCONADJ_V Loads adjustments data.
JMF_EID_SUBCONQUALITY_V Loads quality inspection data.

Menus for Endeca Outsourced Manufacturing

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

User Function Name Function Name
Subcontracting Endeca Home Page JMF_SHIKYU_ENDECA_HOME