Recommended: System Errors? Click here to Fix your PC »
USA/Canada: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 5520, Mexico: 52-55-535-04027, Brazil: 55-11-3444-4949, help@albaspectrum.com skype:albaspectrumThe Oracle E-Business Suite, also known as Oracle Applications or Oracle Financials,has close to 25,100 tables and 33,000 views on its database. One of the main issuesfor Oracle E-Business suite reports development is to find the right data in so manyavailable objects. In this article we are going to discuss how Oracle has organizedits database to make developers life easier.A database schema determines the ownership of the products database objects. Oraclehas separated each product of Oracle E-Business suite in one schema. For example,the module Bill of Materials has a code id  BOMÂ' and a named schema with the samename as its code id, in this case BOM. Each Oracle E-Business suite module has adefault Oracle database user id, with the product abbreviation as name of thedatabase schema. There is one  main schema , called APPS, with a user also calledAPPS, which has privileges to access most of the objects from any schema. The APPS schema owns procedures, triggers, functions, packages, views andmaterialized views and has permission to access tables, indexes, sequences andconstraints from other schemas (products). The APPS schema improves the reliabilityover Oracle E-Business database and reduces the time needed for installation,upgrade, and patching by eliminating the need for cross-product grants.Once APPS user has permissions to access all the objects that are part of OracleE-Business Suite, developers should be connected to the database as APPS user (in atest instance) to produce their reports. Oracle also has helped developers bycreating standards on database objects naming. All objects names starts with theabbreviation of the product. For example, the purchasing product has  POÂ' as itsabbreviation and all Purchasing objects start with  PO_Â'.Finding the data that you need in more than 50,000 objects is not an easy job.Knowing the naming standards of the objects and how they are storage facilitatesdevelopersÂ' life. Oracle has also made available an Electronic Technical ReferenceManual that has information about all the objects in all schemas. It can be accessedon line at http://etrm.oracle.com (metalink access needed) and it provides a verygood help to find the data that you need. Our company is specialized on OracleE-Business suite customizations; if you need service in this area we will be glad tohelp.
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture ofseveral IT and business consulting companies, now operating as single businessentity. We have local presence in the Houston, Chicago, New York, Los Angeles, SanDiego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, SanFrancisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believein the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#,VB) platforms and systems and specialize in several product lines and cross platformintegration, customization, heterogeneous report design, plus we provide ERP/CRMsystems comparison and reviews, not being committed to just on MRP platform. We alsostake on XML cross-platform data interchange to be advanced in the coming decade.
Alba Spectrum Technologies websites: http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br http://www.ronix-systems.de
