Oracle Applications 11i eBusiness Suite DBA   

Oracle Applications Database

NOTE: This article named Oracle Applications Database  was taken from  www.in-oracle.com.

Oracle Applications Database Objects

   The Oracle Applications Database objects are divided in 3 categories:

1. Data objects : store and access business data (tables, indexes, sequences, index-organized tables, etc);

2. Code objects : process data objects but them don't contains business data (functions, procedures, packages, views, synonyms);

3. Hybrid objects : store and process data (materialized views).

Oracle Applications Database Schemas

    In Oracle Applications Database there are schemas for each product (GL- General Ledger, AR-Receivable ) or for group of products (Example: HR schema for PAY-Payroll and PER-Human Resource). These schemas contain ONLY Data objects. ALL the code objects are stored in the APPS schema. APPS schema has synonyms to all base tables and sequences and all products grant FULL privileges to APPS schema, so APPS schema has universal access to the Oracle Applications.   

    Data objects for the Oracle Applications technology layer products (FND, AD) are stored under APPLSYS schema. 

    A particular schema in the Oracle Applications Database is APPLSYSPUB public schema. This schema is used for the signon process. When we sign on to the Oracle Applications, we first connect to APPLSYSPUB schema, after that Oracle Applications verify our username/password and all is ok we can connect to APPS schema (all the products are accessible only by connecting to the APPS schema).  

Multiple Organization Architecture in the database

    One installation of Oracle Applications can support more than one organization (business group, operating unit, etc). That means with Oracle Applications we can have a Multi-Org (Multiple Organization) Architecture. 

    The tables which contains Multi-Org data have a suffix "_ALL" and have a column named ORG_ID (the table has a partition on this column).

    Here is the select which tell us if the database is Multi-Org or not (we must be connected to the database as apps):

    select ad_config.is_multi_org from dual;

Multiple Reporting Currencies

    Oracle Applications allow to run reports in more that one currency. This is the Multiple Reporting Currency (MRC) feature which is based on the Multi-Org Architecture and is a significant aspect of a globalization strategy. However MRC can be used even if the Multi-Org architecture is not enabled. To use this feature the MRC process must be started. 

    
Multiple Languages in the database

    Multiple Languages in the database are implemented by using translations language tables (_TL tables like IRC_ALL_RECRUTING_SITES_TL) or transaction language views (_VL vierws like JTF_LOC_AREAS_VL view). 

            NOTE: This article named Oracle Applications Database  was taken from  www.in-oracle.com.

Oracle Home - home page

Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk. Copyright (c) 2009-2011 Paul Catalin Tomoiu. All rights reserved.