Integrating Indus EMPAC with Oracle Inventory, PO and GL - PowerPoint PPT Presentation

golda
integrating indus empac with oracle inventory po and gl n.
Skip this Video
Loading SlideShow in 5 Seconds..
Integrating Indus EMPAC with Oracle Inventory, PO and GL PowerPoint Presentation
Download Presentation
Integrating Indus EMPAC with Oracle Inventory, PO and GL

play fullscreen
1 / 15
Download Presentation
Integrating Indus EMPAC with Oracle Inventory, PO and GL
367 Views
Download Presentation

Integrating Indus EMPAC with Oracle Inventory, PO and GL

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Integrating Indus EMPAC with Oracle Inventory, PO and GL Marc Kilburn Deloitte & Touche Consulting Group 18th of September, 1998

  2. What’s the story? • Our experience • Indus EMPAC • Indus/Oracle linkage • A typical project • Issues • Summary • Q&A

  3. EMPAC- Whoami? • EMPAC - An asset management bolt-on to Oracle and Peoplesoft from Indus International • Principally used as a computerized maintenance management system • Major Modules: • Competitors • Datastream • Maximo • Others

  4. EMPAC talks to Oracle Applications • ISI (Integrated Solutions Initiative) software is designed to allow EMPAC to communicate with Oracle applications • Interfaces used for integration • Inventory open interface • Requisition open interface • Purchasing open interface • Receiving open interface

  5. Indus Stores is specifically linked to Oracle Inventory • All stock items in EMPAC must be linked to an equivalent inventory item in Oracle • Stores locations in EMPAC must be linked to inventory organization locations in Oracle applications • Inventory organizations in Oracle must be associated with master Inventory organization, to cross reference with the store locations in EMPAC

  6. The interlinkages have been extensively documented • Oracle EMPAC and Oracle applications - Integration Guide • ( Part no. A55811-01) • Oracle EMPAC - Stores Manual • ( Part no. A51317-01) • Oracle EMPAC - Asset Management • ( Part no.A51315-01) • Oracle EMPAC - Administrator’s Manual • ( Part no. A51319-01)

  7. Where can I get some help ? Indus Oracle Indus World Network - 1800-868-0497 Oracle World Wide Support - 1800-223-1711 CareNet is the online resource for product support from Indus International Metalink is the online resource which provides access to technical bulletins, problem/solution articles, documentation and more. Carenet - www.indusworld.com/carenet Metalink - http://support.oracle.com/metalink Product Update information - www.indusworld.com/html/indusworld_carenet.html Metalink - http://support.oracle.com/metalink Click on ‘Certify’ option

  8. A typical project • The first step is chart out the As-Is & To-Be processes Blaster takes shot record with details of number & layout of holes and seismograph reading Example - A blasting process Explosives truck weighed before and after explosives are unloaded Shot record handed over to Plant Manager Manager compares receipt with measured weight of explosives Release payment to vendor through Accounts H/O Do they match? Yes Explosives supplier sends receipt to Plant Manager No Get back to vendor and blaster and reconcile

  9. A typical project • Asset hierarchies need to be mapped out Example - A haul unit

  10. A typical project • Design asset numbering and category coding systems

  11. Requisition Requisition Stock Details Purchase Order Receipt Work Order Details Invoice Voucher Information is exchanged across the two systems EMPAC Oracle On Approval PO Feedback Receipt Feedback Price Variance

  12. Accounting Interface between EMPAC and Oracle Apps EMPAC Oracle Financials Stock issues/ returns General Stock Adjustments Physical Count Adjustments Cost Journal Process Location Transfer Transactions G/L Data Transfer process Scrap Stock Transactions Obsolete Transaction Details G/L Interface Scrap Stock Transactions OF Import API

  13. Buyer Details Buyer Details Supplier Details Vendor Details Chart of Accounts Chart of Accounts Units of Measure Units of Measure Fiscal Periods G/L Periods Stock Details API Stock Details Stock Details Location/ Organization Assignment Locations Inventory Org. Data Views between EMPAC & Oracle Apps EMPAC Oracle API View View View View View Manual Initiation Open Item Interface View View

  14. But, there are issues that arise... • When interfacing with Oracle 8.0, Work Order completion, is currently not possible due to a bug ( a patch is due for release) • Collecting information necessary to maintain the system might be difficult in remote /small sites • Detailed training manuals need to be developed

  15. Summary • EMPAC - An asset management bolt-on to Oracle and Peoplesoft from Indus International • ISI (Integrated Solutions Initiative) software is designed to allow EMPAC to communicate with Oracle applications • What does a typical project entail ? Asset hierarchy, asset numbering, assign category codes, populate asset database and charge costs to assets • Issues pertaining to Oracle/EMPAC interface