Skip to Main Content

The ShopVue-Oracle Connector allows you to benefit from a world-class MES that supports your manufacturing operations while providing a seamless integration into your Oracle environment. 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.

With ShopVue, 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

The ShopVue-Oracle Connector

The ShopVue-Oracle Connector automatically downloads from Oracle the necessary information for accurate shop floor data collection, order tracking, and efficiency reporting. After Operators report transactions on the shop floor, the ShopVue-Oracle Connector uploads information like quantities produced and scrap (moves) as well as labor (resource) hours to Oracle.

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

ShopVue’s Advantages for Oracle Users

Validation & 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 o[erator if she attempts to report a quantity that is less than X percentage (user-defined) of this standard.

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

Multi-Organization Support

With the ShopVue-Oracle Connector, 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 ShopVue-Oracle Connector automatically applies resource and move transactions to the correct organization when exported back to Oracle.

Changes Only

The Changes Only feature ensures ShopVue will download only 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 ShopVue-Oracle Connector queues transactions until a connection is reestablished.

Calculated Over-Completion Quantities

Rather than asking the operator to identity quantities produced over planned quantities, the ShopVue-Oracle Connector can be configured to send calculated over-completion quantities to Oracle.

Automatic Move Completion at Last Operation

The ShopVue-Oracle Connector 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 a single place. The ShopVue-Oracle Connector uses delta logic along with its export history to transmit the correction and keep the two systems in sync.

Utilities to Synchronize Oracle and ShopVue

WIP status between ShopVue and Oracle can be monitored and synchronized with the inherent 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 ShopVue-Oracle Connector includes several reports that are specific to Oracle WIP including, Oracle RRT Error Report, Oracle WIP Transaction History, and Oracle WIP Order Summary.