ORACLE ERP STRUCTURE

APPL_TOP is a directory contains the directories and files for oracle application.

CUSTOM_TOP custom _Top is nothing but Customer Top, which is created for customer only. we can have multiple custom tops based on client requirement. It is used to store developed & customized components. whenever we apply patches it will over ride on all the modules except custom top. that's why we will use custom top.Every client should maintain one or more custom tops to store custom files like custom reports,froms,packages e.t.c,.


AU_TOP  is a directory where the oracle utilities are installed& it is a common top forall the products by maintaining common objects.
GL_Top is a directory where each oracle application is installed


BIN:Contains executable code of concurrent program written in programing language like c,fortran,sql* loader or operating system scripts

LOG:by default all .log files of concurent programs are stored.

SQL,PL/SQL : contains all concurrent programs written in sql * plus and pl/sql

By default all the plx ,pll files are avaliable in au_top.

   In all modules .fmb s are maintained in au_top and .fmx files in respective tops.

 plx,pll----->AU_TOP/11.5.0/RESOURCE

.FMB-------->AU_TOP/11.5.0/FORMS/US

.FMX----->RESPECTIVE FOLDERS

AP FMX---->AP_TOP/11.5.0/FORMS/US.

              
               We have mainly two types of structures

1. Database structure
2. application file structure

Database structure   :Data base is a collection of schema s and schema is a collection of objects like tables,views,sequences,indexes e.t.c,.

                          schema s are of 3 types:

• product schema:  Every module having its own schema called as product schema whic contains its own objects.

example

po schema contains po tables,views,sequences.

• apps schema :it is a parent schema which contains all the schema data in the form of synonyms.

                 synonym is an alias name to refer objects from one schema to another schema. we should use  only apps schema fro developping any technical components like reports,interfaces,workflow & pl/sql subprograms.

• custom schema: every client should maintain one/more custom schemas tocreate custom objects like custom tables,views sequences e.t.c,.

one should not create any custom objects in product schema bcoz once patch is applied it will be over written.

   schemas are develeped by DBA s whereas objects are created by developers.

NOTE:TO WORK WITH MULTIPLE SERVERS DBA WILL SEND HOST NAMES WHICH YOU CAN ADD INTO TNSNAMES.ORA. AND TO SEARCH FOR HOST NAMES USE 'TNSNAMES.ORA*.*

SIGNIFICANCE OF US FOLDER:

 It is a language specific folder & having only forms and reports bcoz these are GUI tools ,By default oracle apps supports only english language by following quires we can find  what are the other langunages implemented/not implemented in our projects using following queries:

for all languages--->'sql>select * from fnd_langunages;'

for base language---->'sql>select * from fnd_langunages where installed_flag = 'B';'

for disabled language--'sql>select * from fnd_langunages where installed_flag = 'D';'

     

    If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.