Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 18353 invoked from network); 8 Aug 2006 15:40:10 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 15:39:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5822F3BE33F; Tue, 8 Aug 2006 16:39:39 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07918-02; Tue, 8 Aug 2006 16:39:39 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B45273BE337; Tue, 8 Aug 2006 16:39:38 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 16:38:48 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47AD33BE178 for ; Tue, 8 Aug 2006 16:38:48 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07740-04 for ; Tue, 8 Aug 2006 16:38:48 -0400 (EDT) Received: from ahmler1.mail.eds.com (ahmler1.mail.eds.com [192.85.154.71]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CB31B3BE1A0 for ; Tue, 8 Aug 2006 16:38:47 -0400 (EDT) Received: from ahmlir1.mail.eds.com (ahmlir1-2.mail.eds.com [192.85.154.131]) by ahmler1.mail.eds.com (8.13.7/8.12.10) with ESMTP id k78Kd1xX017792 for ; Tue, 8 Aug 2006 16:39:03 -0400 Received: from ahmlir1.mail.eds.com (localhost [127.0.0.1]) by ahmlir1.mail.eds.com (8.13.7/8.12.10) with ESMTP id k78KcgFB010792 for ; Tue, 8 Aug 2006 16:38:42 -0400 Received: from usahm011.amer.corp.eds.com ([130.175.214.152]) by ahmlir1.mail.eds.com (8.13.7/8.12.10) with ESMTP id k78KcgCj010787 for ; Tue, 8 Aug 2006 16:38:42 -0400 Received: from usahm236.amer.corp.eds.com ([130.175.214.169]) by usahm011.amer.corp.eds.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 8 Aug 2006 16:38:41 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6BB2A.A269760E" Subject: RE: ot: Please reference to excellent Enterprise Resrouce Planning book references Date: Tue, 8 Aug 2006 16:38:40 -0400 Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410508178A6A@usahm236.amer.corp.eds.com> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ot: Please reference to excellent Enterprise Resrouce Planning book references From: "Powell, Mark D" To: X-OriginalArrivalTime: 08 Aug 2006 20:38:41.0680 (UTC) FILETIME=[A28CE100:01C6BB2A] X-archive-position: 37908 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-to: mark.powell@eds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------_=_NextPart_001_01C6BB2A.A269760E Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Being that ERP is really just an an expansion of MRPII ( MRP + Financials + feedback loops) with full logistics and customer relationship management plus the kitchen sink as Dennis said, why not visit the APICS web site: www.apics.com. =20 APICS was once known as the American Production and Inventory Control Society, but now is something like the Association for Operations Research. Nevertheless the CPIM (Certification in Production and Inventory Management) program includes several reference texts for each major area of the program: supply chain management, master scheduling, production control, etc.... =20 Or you could read all the documentation for each of the Oracle Applications or SAP modules. By looking at what the systems do you can devise a background layout. However a full ERP system would probably have better than 3,000 tables so you probably want to start with a limited area. =20 HTH -- Mark D Powell CPIM, CIRM, OCP -- =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Carlos Reyes Pacheco Sent: Tuesday, August 08, 2006 3:20 PM To: Dennis Williams Cc: oracle-l@freelists.org Subject: Re: ot: Please reference to excellent Enterprise Resrouce Planning book references =09 =09 Thanks a lot Dennis, I know how big they are, but if you want to start one, you have to start from somewhre, I know about accounting, employee, etc. What I was looking was good sources for ideas designing erps. =09 =09 =09 On 8/8/06, Dennis Williams wrote: Juan, =20 You've set a rather ambitious task for yourself. First of all, ERP is mainly a buzzword. It consists of whatever a company decides it should. As you have stated, an ERP consists of modules. The modules are where the real significance is, the real brains. The rest is just how you get the modules to communicate. Usually the key module is the general ledger module, since money is the key resource in an organization and the general ledger tracks the money. There are other modules that usually round out a fully-fledged accounting system such as budgeting, accounts payable, accounts receivable. Then there are other modules that companies have come to expect from a fully-fledged ERP system such as payroll, support for human relations, and perhaps inventory control. But the point is that at some point there is discretion whether to include particular modules or not in a vendor's ERP design, depending on what the vendor's clients are requesting, and where the vendor's competence lies.=20 To develop any of these modules would take an education in that subject and years of professional practice. A company which wishes to develop one of these modules first hires a team of competent professionals in that subject area to design that module.=20 Once you've developed individual modules, then you must decide how the modules will exchange information. A key decision is how frequently the modules need to exchange information. Sometimes it must be real-time. Sometimes you want an overnight cycle. Sometimes it is a month-end accounting cycle.=20 In summary, ERP systems, even small ones, tend to be vast, sprawling affairs with complexity that boggles the imagination. But the number of features varies according to the size of organization which purchases them. Take payroll for example. Say you are a payroll clerk paying a dozen employees at a small organization. You just need a very simple payroll program to assist you. Maybe only one employee has a garnishment against his/her wages. You just handle that manually without assistance from the program. Now, suppose you manage a payroll department for a medium-sized company and you pay thousands of employees. Now there will be hundreds of people with garnishments against their wages so you must have a payroll program with a good garnishment feature or you'll spend a lot of time each month handling the garnishments manually. So small organizations use simple, cheap programs with few features, while large organizations use complex, expensive programs with many, many features. Hopefully this gives you some small insights into the ERP landscape.=20 From the point of view of a database administrator, it is all tables and demanding users. You aren't expected to be an expert in any of the ERP modules. But you must ensure the users don't encounter any database errors and fix any errors promptly and courteously. You should have a professional demeanor that lets you work with many types of people.=20 =09 =20 Dennis Williams --=20 ---------------------------------------- http://www.oracleboliviaspecialists.com/ =09 Oracle Certified Profesional 9i 10g=20 Orace Certified Professional Developer 6i =09 10 years of experience from Oracle 7 to Oracle10g and developer 6i=20 ------_=_NextPart_001_01C6BB2A.A269760E Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
Being that ERP is really just an an expansion = of MRPII=20 ( MRP + Financials + feedback loops) with full logistics and customer=20 relationship management plus the kitchen sink as = Dennis said, why not=20 visit the APICS web site: www.apics.com.
 
APICS was once known as the American = Production and=20 Inventory Control Society, but now is something like the Association for = Operations Research.  Nevertheless the CPIM (Certification in = Production=20 and Inventory Management) program includes several reference texts for = each=20 major area of the program: supply chain management, master scheduling,=20 production control, etc....
 
Or you could read all the documentation for = each of the=20 Oracle Applications or SAP modules.  By looking at what the systems = do you=20 can devise a background layout.  However a full ERP = system would=20 probably have better than 3,000 tables so you probably want to start = with a=20 limited area.
 
HTH -- Mark D Powell CPIM, CIRM, OCP=20 --
 

From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Carlos = Reyes=20 Pacheco
Sent: Tuesday, August 08, 2006 3:20 PM
To: = Dennis=20 Williams
Cc: oracle-l@freelists.org
Subject: Re: = ot:=20 Please reference to excellent Enterprise Resrouce Planning book=20 references

Thanks a lot Dennis, I know how big they are, but if you = want to=20 start one, you have to start from somewhre, I know about accounting, = employee,=20 etc.
What I was looking was good sources for ideas designing=20 erps.


On 8/8/06, Dennis=20 Williams <oracledba.williams@gmail.com= >=20 wrote:
Juan,
 
You've set a rather ambitious task for yourself. First of all, = ERP is=20 mainly a buzzword. It consists of whatever a company decides it = should. As=20 you have stated, an ERP consists of modules. The modules are where = the real=20 significance is, the real brains. The rest is just how you get the = modules=20 to communicate. Usually the key module is the general ledger module, = since=20 money is the key resource in an organization and the general ledger = tracks=20 the money. There are other modules that usually round out a = fully-fledged=20 accounting system such as budgeting, accounts payable, accounts = receivable.=20 Then there are other modules that companies have come to expect from = a=20 fully-fledged ERP system such as payroll, support for human = relations, and=20 perhaps inventory control. But the point is that at some point there = is=20 discretion whether to include particular modules or not in a = vendor's ERP=20 design, depending on what the vendor's clients are = requesting, and=20 where the vendor's competence lies.
    To develop any of these modules would take = an=20 education in that subject and years of professional practice. A = company=20 which wishes to develop one of these modules first hires a team of = competent=20 professionals in that subject area to design that module.
    Once you've developed individual modules, = then you=20 must decide how the modules will exchange information. A key = decision is how=20 frequently the modules need to exchange information. Sometimes it = must be=20 real-time. Sometimes you want an overnight cycle. Sometimes it is a=20 month-end accounting cycle.
    In summary, ERP systems, even small ones, = tend to be=20 vast, sprawling affairs with complexity that boggles the = imagination. But=20 the number of features varies according to the size of organization = which=20 purchases them. Take payroll for example. Say you are a payroll = clerk paying=20 a dozen employees at a small organization. You just need a very = simple=20 payroll program to assist you. Maybe only one employee has a = garnishment=20 against his/her wages. You just handle that manually without = assistance from=20 the program. Now, suppose you manage a payroll department for a = medium-sized=20 company and you pay thousands of employees. Now there will be = hundreds of=20 people with garnishments against their wages so you must have a = payroll=20 program with a good garnishment feature or you'll spend a lot of = time each=20 month handling the garnishments manually. So small organizations use = simple,=20 cheap programs with few features, while large organizations use = complex,=20 expensive programs with many, many features. Hopefully this gives = you some=20 small insights into the ERP landscape.
    From the point of view of a database = administrator,=20 it is all tables and demanding users. You aren't expected to be an = expert in=20 any of the ERP modules. But you must ensure the users don't = encounter any=20 database errors and fix any errors promptly and courteously. = You should=20 have a professional demeanor that lets you work with many types of = people.=20
 
Dennis Williams


--
----------------------------------------
http://www.oraclebolivi= aspecialists.com/

Oracle=20 Certified Profesional 9i 10g
Orace Certified Professional = Developer=20 6i

10 years of experience from Oracle 7 to Oracle10g and = developer 6i=20
------_=_NextPart_001_01C6BB2A.A269760E-- -- http://www.freelists.org/webpage/oracle-l