Oracle Application Architecture
Oracle Application fallows the 3 Tier Architecture
Front end Tier Middle Tier Database
Front end User Collection of DB
Collection of files
Interface(UI) Related Objects
Ex:- .rdf, .fmb, .txt,
Ex:- i.e or chrome Ex:- Collection of
.data, .sql etc.
or Mozilla tables, Views,
procedures,
functions and
Packages etc.
Front end Tier
• 1. Front end is the UI.
• User Interface is going to communicate with
User actions
• 2. By using the any web browser connect to
the Oracle Applications.
How to Connect to Oracle Application Front end
Open any web Browser and Enter the Url
provided by DBA
Enter User Name and Password supplied by
DBA.
MiddleTier:
Middle Tier is the Collection of files.
Ex:- .rdf files, .sql files, .txt, .fmb and .fmx files
Modules Short Name Server Path
1.INV $INV_TOP
1.Inventory
2.Purchasing 2.PO $PO_TOP
3.Order Management 3.ONT $ONT_TOP
4.Accounts receivable 4.AR $AR_TOP
5.Accounts Payable 5.AP $AP_TOP
6.Cash Management 6.CM $CM_TOP
7.General Ledger
7.GL $GL_TOP
Middle Tier structure:
/U01
/CER Project Name
$PO_TOP=
/u01/cer/apps/apps_st/appl/po/12.0.0/apps Project folder (or)
Custom_top
/apps_st
/appl
INV PO ONT AP AR CM GL AU XXCER
12.0.0 12.0.0
data bin reports sql forms data bin reports sql forms
.txt .ctl .txt .ctl .sql
.sql
.csv .prog .csv .prog
US EUR US EUR US EUR US EUR
.rdf .rdf .rdf .rdf .fmb .fmb
.fmb .fmb
.fmx .fmx .fmx .fmx
Middle Tier Connection and tools
• How to Connect to Middle Tier
• Winscp and Putty Tools are Used to connect to
Middle tier.
• WINSCP TOOL:
• Winscp is the tool used to transfer files from
Local Machine to server and Vice versa.
Winscp tool
Local Machine
Server or Middle Tier
We can transfer the files from Local Machine to Server or server
to Local machine.
Select the file and click on F5 to transfer the files.
PUTTY TOOL:
Putty tool is used to identify the winscp directory
Paths and execute the scripts.
Important Commands :
cd – to change the directory
pwd – present working directory
ls -lrt – list all the files under current directory
Identify the PO_TOP
List all the folders under PO_TOP
Database Tier
1. Database tier is the collections of schemas.
Ex:- AP Schema, AR Schema, PO Schema,
XXCER Schema, APPS Schema.
2. Apps Schema is the central schema contains
all the synonyms and tables relevant to other
schemas.
3. Each schema is the collection of DB Objects.
Ex:- Tables, Views , Indexes, Procedures ,
Functions, Triggers and Packages etc.
Database Architecture: Collection of Schemas
DATABASE
AR
AP SCHEMA
POSCHE SCHEMA
MA CM
SCHEMA
GL
SCHEMA INV
AP SCHEMA
SCHEMA
Schema: Collection of Database Objects
Tables
Views
Synonyms
Indexes
Functions
Packages
Procedures
Triggers
Q: How to access the Table from Schema?
ANS: shemaName.TableName
Select * from po.po_headers_all;
