Difference between revisions of "OEE Oracle Work Order Process Flow"

From 42Q
Jump to navigation Jump to search
Line 16: Line 16:
 
----->  
 
----->  
 
= '''Work Order Process Flow: OEE → Oracle → 42Q''' =
 
= '''Work Order Process Flow: OEE → Oracle → 42Q''' =
 +
  
  
Line 23: Line 24:
 
The following steps outline how to set an ERP Route. This process can be used by EMS plants using ShopVue or Oracle as an ERP system.
 
The following steps outline how to set an ERP Route. This process can be used by EMS plants using ShopVue or Oracle as an ERP system.
  
*Set the Target UPH value in Target Maintenance.  
+
#Set the Target UPH value in Target Maintenance.  
*Set the Complete Quantity in Target Maintenance.  
+
#Set the Complete Quantity in Target Maintenance.  
*Set the Good Quantity in Target Maintenance.  
+
#Set the Good Quantity in Target Maintenance.  
*Set the following parameters in Oracle: Plant Code, Client ID, Locations, Start Time, End Time.  
+
#Set the following parameters in Oracle: Plant Code, Client ID, Locations, Start Time, End Time.  
*OEE sends parameters to 42Q's MES-API.  
+
#OEE sends parameters to 42Q's MES-API.  
*42Q returns the results to OEE: Plant Code, Location, Start Time, End Time, Shop Order, MFG Line, Part Number, Process, Finished QTY, Good QTY, Target QTY.
+
#42Q returns the results to OEE: Plant Code, Location, Start Time, End Time, Shop Order, MFG Line, Part Number, Process, Finished QTY, Good QTY, Target QTY.
  
 
== '''Revision Log''' ==
 
== '''Revision Log''' ==

Revision as of 20:47, 4 March 2019

Work Order Process Flow: OEE → Oracle → 42Q

Steps

The following steps outline how to set an ERP Route. This process can be used by EMS plants using ShopVue or Oracle as an ERP system.

  1. Set the Target UPH value in Target Maintenance.
  2. Set the Complete Quantity in Target Maintenance.
  3. Set the Good Quantity in Target Maintenance.
  4. Set the following parameters in Oracle: Plant Code, Client ID, Locations, Start Time, End Time.
  5. OEE sends parameters to 42Q's MES-API.
  6. 42Q returns the results to OEE: Plant Code, Location, Start Time, End Time, Shop Order, MFG Line, Part Number, Process, Finished QTY, Good QTY, Target QTY.

Revision Log

 

Revision # Revision Date Description Updated by Approved by
1 10/4/18 This is the first draft of the OEE/Oracle How To Martha Jordan