| Oracle Reports, Oracle E-Business Suite, Oracle | | | | APPS schema improves the reliability over Oracle |
| Applications, Oracle Database Schemas | | | | E-Business database and reduces the time needed for |
| The Oracle E-Business Suite, also known as Oracle | | | | installation, upgrade, and patching by eliminating the |
| Applications or Oracle Financials, has close to 25,100 | | | | need for cross-product grants. |
| tables and 33,000 views on its database. One of the | | | | Once APPS user has permissions to access all the |
| main issues for Oracle E-Business suite reports | | | | objects that are part of Oracle E-Business Suite, |
| development is to find the right data in so many | | | | developers should be connected to the database as |
| available objects. In this article we are going to discuss | | | | APPS user (in a test instance) to produce their reports. |
| how Oracle has organized its database to make | | | | Oracle also has helped developers by creating |
| developers´ life easier. | | | | standards on database objects naming. All objects |
| A database schema determines the ownership of the | | | | names starts with the abbreviation of the product. For |
| products´ database objects. Oracle has | | | | example, the purchasing product has 'PO' as its |
| separated each product of Oracle E-Business suite in | | | | abbreviation and all Purchasing objects start with 'PO_'. |
| one schema. For example, the module Bill of Materials | | | | Finding the data that you need in more than 50,000 |
| has a code id 'BOM' and a named schema with the | | | | objects is not an easy job. Knowing the naming |
| same name as its code id, in this case BOM. Each | | | | standards of the objects and how they are storage |
| Oracle E-Business suite module has a default Oracle | | | | facilitates developers' life. Oracle has also made |
| database user id, with the product abbreviation as | | | | available an Electronic Technical Reference Manual |
| name of the database schema. There is one "main | | | | that has information about all the objects in all |
| schema", called APPS, with a user also called APPS, | | | | schemas. It can be accessed on line at (metalink |
| which has privileges to access most of the objects | | | | access needed) and it provides a very good help to |
| from any schema. | | | | find the data that you need. Our company is |
| The APPS schema owns procedures, triggers, | | | | specialized on Oracle E-Business suite customizations; |
| functions, packages, views and materialized views and | | | | if you need service in this area we will be glad to help. |
| has permission to access tables, indexes, sequences | | | | Give us a call 1-866-528-0577, 1-630-961-5918 or if you |
| and constraints from other schemas (products). The | | | | need additional information or directions. |