CascoDev
CascoDevTagline
CascoDevBolt
Casco Development > ERP Partners > Oracle Manufacturing
Shop Floor Data Collection for Oracle Manufacturing 

Interface Overview

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 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.

Features

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

Casco 1-207-773-0944

Contact us to discuss your shop floor software needs.

A Perfect Fit

Every ShopVue system is tailored to your business using configuration and only minimal custom code, reducing costs and risks.
Learn more »

ShopVue Demo

See how shop floor execution helps your business stay lean and competitive.