Solved

oracle_ERP

Posted on 2010-09-19
6
972 Views
Last Modified: 2013-11-23
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,

0
Comment
Question by:sam15
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:George K.
ID: 33713920
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
 
LVL 13

Assisted Solution

by:George K.
George K. earned 150 total points
ID: 33713944
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
 

Author Comment

by:sam15
ID: 33715930
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 3

Accepted Solution

by:
P2O earned 350 total points
ID: 33722404
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
 

Author Comment

by:sam15
ID: 33745680
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
 

Author Closing Comment

by:sam15
ID: 33761904
good info
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connect MS Access to Cloud JD Edwards Database 4 519
do i need to be administrator to programmatically update salesforce 5 314
TCODE and TABLE relationship 1 187
MIS vs ERP 11 309
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question