ShopVue for Oracle 

Shop Floor Data Collection and Control

ShopVue offers Oracle users an integrated manufacturing execution system with an easy-to-use factory interface.

ShopVue delivers real-time labor and order tracking, machine monitoring and full-featured time and attendance in one reliable system that interfaces directly with Oracle. By using ShopVue together with Oracle, you can:

  • Offer factory users friendlier screens that save time at terminals.
  • Save money by potentially reducing the number of Oracle licenses needed in your factory.
  • Configure the technology to meet your needs in days, not months.

Learn more about the business solutions ShopVue can provide to your Oracle-powered business.

The following provides technical details on how ShopVue and Oracle work together.

About the ShopVue-Oracle Interface

The ShopVue-Oracle Manufacturing interface (svOracle) allows you to front end your Oracle system with a state-of-the-art shop floor data collection and control system.

The svOracle interface automatically downloads from Oracle the necessary information for accurate shop floor data collection, order tracking and efficiency reporting. Soon after operators report transactions on the shop floor, svOracle uploads information like quantities produced and scrap (moves) as well as labor (resource) hours to Oracle.

Ultimately, the svOracle interface enables Oracle Manufacturing to display your updated order status, additional actual labor and transfers to finished goods inventory.

Validation and Error Handling

ShopVue uses Production Order information from Oracle to interactively validate each operator entry. For example, if ShopVue knows a standard in Oracle is 100 pieces per hour, ShopVue can warn an operator if she attempts to report a quantity that is less than X percentage (user-defined) of this standard.

The svOracle interface validates these entries again when it updates the Oracle through the Oracle WIP interface. In the unlikely event that an error slips through, svOracle returns the error to ShopVue for correction and automatic reposting.


Multi-Organization Support

With the svOracle interface, you can release Production Orders from different Oracle organizations into the appropriate instance of ShopVue. ShopVue operators and supervisors don’t have to worry about charging work to the right company. The svOracle interface automatically applies resource and move transactions to the correct organization when exported back to Oracle.

Changes Only

The Changes Only feature ensures ShopVue will only download new orders and changes to existing orders, limiting network traffic and speeding download time. Seconds after planners input that new hot job into Oracle, operators can begin working on the job in ShopVue.

Automatic Operation

ShopVue-Oracle interactions happen automatically at frequent intervals. If either system is temporarily unavailable, the svOracle interface queues transactions until a connection is reestablished.

Calculated Overcompletion Quantities

Rather than asking the operator to identity quantities produced over planned quantities, svOracle can be configured to send calculated overcompletion quantities to Oracle.

Automatic Move Completion at Last Operation

svOracle can be configured to automatically perform a ‘Move Completion’ when sending Moves on the last operation. ShopVue will also perform a ‘Move Return’ when returning pieces with a supervisor edit.  Without this setting, pieces from the last operation will not be moved to inventory and would require another process within Oracle Manufacturing to move to inventory.

Corrections in ShopVue with Delta Logic

Supervisors can make corrections to operator transactions in one place – ShopVue.  svOracle uses delta logic along with its export history to transmit the correction to svOracle to keep the two systems in sync.

Utilities to Synchronize Oracle and ShopVue

WIP status between ShopVue and Oracle can be monitored and synchronized with SvOracle utility applications.  This is useful at system startup to set initial WIP status in ShopVue; after physical inventory, to resynchronize ShopVue with Oracle; or to correct specific WIP orders in ShopVue based on Oracle.

WIP Reports

In addition to standard ShopVue reports, the svOracle interface includes several reports that are specific to Oracle WIP including:

  • Oracle RRT Error Report
  • Oracle WIP Transaction History
  • Oracle WIP Order Summary

About ShopVue: ShopVue is a shop floor data collection system that provides a fast, friendly and foolproof user experience. Our MES software works with your ERP such as SAP; Oracle; Dynamics NAV, GP, or AX; Infor Syteline, XA, Point.Man, ForthShift; Macola ES; BPCS; PRMS and more.