Oracle Applications revised

what is oracle applications?
Oracle applications is a application software for business.It basically integrates and manages the activities of an organization to attain optimization of business.
___________________________________________

Technical Architecture of Oracle Apps
___________________________________________

1.Software used in Build of Application
2.Overview of three tier Architecture
3.Architecture of User tier
4.Architecture of Application tier
5.Architecture of Data base tier
6.Different ways to Access Application
7.Tools Used in Oracle Apps

____________________________________________

1.Software used in Build of Application
____________________________________________

-> SQL
-> PL/SQL
-> UNIX
-> FORMS 6i
-> REPORTS 6i
-> Java
____________________________________________

2.Overview of three tier Architecture
____________________________________________

/> User Tier
/> Application Tier
/> Dtatabase Tier
____________________________________________

3.Archetecture of user tier
____________________________________________
User tier contains a java Applet which helps you to connect to the application Server.

____________________________________________

4.Archetecture of Application Tier
____________________________________________
/> This tier contains forms , reports , sql scripts, control file and Unix scripts.
/> There will be a folder for each module.
/> Each folder contains subfolders to store report, forms etc of each module.














a) Forms folder contains the forms of a module
b) Report folder contains the reports of a module
c) Bin folder contain Unix or shell scripts and ctl files
d) SQL folder contains sql scripts
e) IN and OUT contains transferring data files.

___________________________________________________

5.Architecture of Data base tier
___________________________________________________

/> This tier contain db objects like Tables ,Views, Synonyms, Sequences, Index, functions, Procedures, packages and triggers.
/> Each Module contains a schema in db.These are called Base schemas. This contains tables, sequences and indexes.
/> Apps schema is the parent schema. It contains functions, procedures, packages and synonyms of base schema objects

















___________________________________________________

6.Different ways to Access Application
___________________________________________________
/> Connect to Database Tier
User Name, Password , Database or TNS Names
/> Connect to User Tier
User Name, Password and URL
/> From Application Tier
User Name, Password, Server name and Path
___________________________________________________

7.Tools Used in Oracle Apps
___________________________________________________
/> SQL plus
/> SQL Loader
/> Toad 8
/> Reports 6i
/> Forms 6i
/> Work Flow Builder
/> Data Loader

___________________________________________________
chapter 2
Overview of tables and forms relationships
___________________________________________________

1. Different types of tables in apps
2. Different types of column in a table
3. Overview of Form and table relationship
4. Finding related tables of a forms
5. Finding related table and column of a form field
6. Finding primary and foreign keys of a table
7. Overview of sysadmin tables and relationships

___________________________________________________
Different types of tables in apps
___________________________________________________

As per the usage oracle tables can be divided into

INTERFACE TABLE
These are intermediated tables between apps base tables and external tables. when loading the data into apps using interface program you have to load the data into interface tables then oracle program will take care of loading data to base tables.
Example – AP_INVOICE_HEADER_INTERFACE
AP_INVOICE_LINES_INTERFACE

BASE TABLE
This tables will store all the data in oracle apps. These table are not allowed to update form backend. Each form will be dependent on or more base tables. EX- AP_INVOICES_ALL

Oracle application supports multiple business data in a single instance. So based on data storage base tables can be divided into below types.

GLOBAL TABLES
The data in this tables will not be specific to any org of a business. This can be share across all business org’s.
Ex – Employee details are share across the business. PER_PEOPLE_F table will store all employees data

ORG SPECIFIC TABLES
This table will store data which can not be shared across orgs of a business.Like Invoice details of one org will not be show by other org employee of a business.Org id column of table helps to keep the data secure.
EX- AP_INVOICES_ALL –It will have ALL at the end,

LANGUAGE SPECIFIC TABLE
Apps supports multi-languages. This tables will store language specific data. –This will have TL at end
_______________________________________________________________
Different types of columns in a table
_______________________________________________________________
Based on the usage, columns in apps table can be divided into below types.

DATA COLUMNS
This column contains base transaction data entered form apps form.
Ex- In AP_INVOICES_ALL – INVOICE_NUM

ATTRIBUTE COLUMNS
There are the additional columns provided by oracle for future use.
Ex- Attribute1 , Attribute2…etc

WHO COLUMNS
This columns stores history details of the form.
EX- Created by , Creation data, Last updated by
Last updated date, Last updated login.