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