In Oracle : Oracle Applications 11i Database 

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle Applications 11i File Database  

 

Oracle Applications 11i Database  

This article covers the following topics:

 

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). 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle Applications 11i File Database 

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  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.