oracle_ERP

Does an oracle ERP (peoplesoft) or CRM have thousands of tables in the database?

How many applications is the schema really supporting? and does oracle do one install regardless what application you buy.

is there  any link for general info too.

thanks,

sam15Asked:
Who is Participating?
 
P2OConnect With a Mentor Commented:
Oracle ERP (R12)  has around 25000+ tables.
It has total 292 modules. You have to enable those modules which you have license, Oracle check (with their automated script all details) when you will  renew your contract for support.

Licensing is depends on various factor, it is CPU based license or it's user based license, when and how you negotiated  with them ? How many Oracle Databases you are running ?

Basic knowledge about ERP, you want from DBA view, Management view or from Developer view ?


0
 
George K.Commented:
Regarding your question there are two things you should have in mind whichever application you use (PeopleSoft, SAP etc)
  1. Database server
  2. Application server
  • It may be  up to the minimum requirements of the application
  • the overall performance
  • and the total IT planning, for proper operation of how many databases servers/aplpication servers are necessary.

0
 
George K.Connect With a Mentor Commented:
To be mmore specific
in the Oracle Database Reference 11g Release 2 it says that you can have
2,147,483,638 schemas by counting addtiional the roles.
Here is a link with all Oracle Documentation.
http://www.oracle.com/pls/db111/portal.all_books
If you explain your needs (Application, number of users, network, storage capacity, record processing, number of transactions)
may be I could provide you with more specific information/guidance regarding your specific needs.




0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
sam15Author Commented:
I think you misunderstood my question.

I am trying to get general info on ERP packages like how many applications it has, how many tables it needs, how is it licensed, how does it get installed, is it very complicated schema, etc.

someone was telling me peoplesoft has 5000 tables behind it and i am trying to verify if that is for one application or 10 applications, etc. just general basic knowledge about ERPs.
0
 
sam15Author Commented:
basic knowledge like how many application does an ERP has? how complext is the schema behind each application? how much it costs for license.

things like that.

when you say 292 modules. Does module = application. is it like 100 tables per application?
0
 
sam15Author Commented:
good info
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.