Inventory, PO and GL

butterbeansarmΔιαχείριση

18 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

109 εμφανίσεις

Marc Kilburn

Deloitte & Touche Consulting Group

18th of September, 1998

Integrating Indus EMPAC with Oracle
Inventory, PO and GL

Atlanta OAUG


Our experience


Indus EMPAC


Indus/Oracle linkage


A typical project


Issues


Summary


Q&A

What’s the story?

Atlanta OAUG

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

A s s et M anagem ent
W ork M anagem ent
P roc urem ent
S t ores
Res ourc e M anagem ent
P erform anc e Indi c at ors
Atlanta OAUG

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


Atlanta OAUG

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

Atlanta OAUG

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)






Atlanta OAUG

Where can I get some help ?

Indus

Oracle

Indus World Network
-

1800
-
868
-
0497

Oracle World Wide Support
-

1800
-
223
-
1711

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

Metalink is the online resource which
provides access to technical bulletins,
problem/solution articles, documentation and
more.

CareNet is the online resource for product
support from Indus International

Atlanta OAUG

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


Explosives truck weighed
before and after explosives
are unloaded

Explosives supplier
sends receipt to Plant
Manager

Shot record handed over
to Plant Manager


Manager compares
receipt with measured
weight of explosives

Do they
match?

Get back to vendor and
blaster and reconcile

Release payment to
vendor through
Accounts H/O

No

Yes

Example
-

A blasting process

Atlanta OAUG

A typical project


Asset hierarchies need to
be mapped out

HAUL UNIT
ENGINE
POWER
TRANS
BRAKES
FRAME
WORK
EQUIP
CONV
TRANS
DRIVE
LINE
DIFF
CAB
CHASIS
STEER
WHEEL
ASSY
SUSP
CHARG
CRANK
FILTER
COOL
EXHAUST
FUEL
ENG GR
HYDR
BED
TIRES
A/C
GLASS
ELECT
TIN
WORK
Example
-

A haul unit

Atlanta OAUG

A typical project


Design asset numbering and category coding
systems

Atlanta OAUG

EMPAC

Oracle

Requisition

Purchase Order

Receipt

Invoice Voucher

Requisition

Stock Details

Work Order Details

On Approval

PO Feedback

Receipt Feedback

Price Variance

Information is exchanged across
the two systems

Atlanta OAUG

Accounting Interface between EMPAC
and Oracle Apps

Stock issues/


returns

General Stock

Adjustments

Physical Count


Adjustments

Location Transfer

Transactions

Obsolete

Transaction Details

Scrap Stock

Transactions

Cost Journal Process

Scrap Stock

Transactions

G/L Data Transfer
process

G/L Interface

OF Import

API

EMPAC

Oracle Financials

Atlanta OAUG

Open Item Interface

Manual Initiation

Data Views between EMPAC & Oracle
Apps

Buyer Details

Vendor Details

Chart of Accounts

Units of Measure

G/L Periods

Stock Details

Inventory Org.

View

View

View

View

View

Stock Details API

Location/ Organization
Assignment

View

View

Buyer Details

Supplier Details

Chart of Accounts

Units of Measure

Stock Details

Fiscal Periods

Locations

EMPAC

Oracle

API

Atlanta OAUG

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

Atlanta OAUG

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