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.

Concept Of Profiles

Webmasters Earn Money Here!
_______________________________________

Profiles
_______________________________________________
1. Overview Of Profile Options
2. Different Levels in Setting Profiles
3. Steps in Setting a Profile Option
4. Some Important Profile Options
5. Some Important API’s Of Profiles
___________________________________________________
1. Overview of User Profiles
___________________________________________________
Oracle Application user profiles help you satisfy the following business needs.

> A user profile is a collection of changeable options that affect the way your applications run.
> You can modify product – specific variables that affect the functionality of your application to suit your business environment .
> Set Options that affect your application’s behavior to your preference.
> Oracle Application establishes a value for each option in a user’s profile when the user logs on or changes responsibility
> Oracle Applications uses a set of user profile options are common to all the application products or each application product has its own unique set of user profile options.
____________________________________________________
2. Different Levels in Setting Profiles
____________________________________________________
User profile options can be set at one or more of four levels.

They are Site, Application, Responsibility, and User. Your system administrator can set default option values at any of these levels.

Site Level:
Site is the lowest profile level. Site—level option values affect the way all applications run at a given installation site.

Application Level:
Application is the profile level immediately above site. Application –level option values affect the way a given application runs.

Responsibility Level:
Responsibility is the profile level immediately above Application. Responsibility—level option values affect the way application run for all users of a given responsibility.

User Level:
User is the highest profile level and is immediately above Responsibility. User—level option values affect the way applications run for a given application user.

User Profile Hierarchy
Oracle Application treats user profile levels as a hierarchy, where User is the highest level of the hierarchy, followed by Responsibility, Application, and at the lowest level, Site.
____________________________________________________
3. Steps in Setting a Profile Options
____________________________________________________
> Your system administration can set values for user profile options at each profile level.
> Typically, your system administrator sets site—level option values after installing Oracle Application at a site.
> These site—level option values apply until you or your system administrator changes them.
> Oracle application derives a run—time value for each user’s profile option based on the values set at the highest hierarchy level.
> Any change your system administrator makes to your profile options takes effect as soon as you log on again or change responsibilities.
> You can set your own preference at the user—level, since your user—level setting overrides the Responsibility—level setting.
> Some option values can only be changed by the system administrator.

Steps in Setting a Profile Option

Step-1 Log into sysadmin and open the profile setup screen
Navigation: – Sysadministrator > Profile > System

















Step-2 Select Profile Level

















Step-3 Select Profile Name Click on Find

















Step-4 Setup your Profile value at any level.



















____________________________________________________
4. Some Important Profile Options
____________________________________________________
# Attachment File upload directory : This Provides the Directory path used to upload attachment files.
# Set of Books name : Provides access to specific Set of Books in GL.
# MO Operating Unit : This allows user to specify operating unit.
# Sign-on Notification : Message about failed concurrent programs of failed logins.
# Viewer : To set up Browser for viewing the documents.
# Defaulter Country : This is the default source for the Country filed for all address zones and is used by the Flexible Address Formats feature, the Flexible bank structures feature and the Tax Registration Number and Taxpayer ID Validation routines.
# Flex fields : Open Descr Window : You can control whether a descriptive flex fields window automatically opens when you navigate to a customized descriptive flex field.

_____________________________________________________
5. Some Important API’s Of Profiles
_____________________________________________________
User profile APIs can be used in your PL/SQL procedures to manipulate the option values stored in profile caches.

Procedure FND_PROFILE.PUT
(name IN varchar2, value IN varchar2);
Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.
EX– FND_PROFILE.PUT ( ‘USER_ID’, User_Id);

procedure FND_PROFILE.GET
(name IN varchar2, value OUT varchar2);
Gets the current value of the specified user profile option, or NULL if the profile does not exist.
EX– FND_PROFILE.GET ( ‘USER_ID’, User_Id);

function FND_PROFILE.VALUE
(name IN varchar2) return varchar2;
VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.
EX– FND_PROFILE.VALUE ( ‘USER_ID’);

Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!

Application Access, Navigations and Commands

__________________________________________________
Application Access, Navigations and Commands
__________________________________________________
1.Overview of Application Access in Oracle Apps
2.Overview of User
3.Overview of Responsibility
4.Overview of Data, Menu, and Request groups
5.Overview of Basic Navigations and Features
6.Overview of Some Commands
__________________________________________________
1.Overview of Application Access in Oracle Apps
__________________________________________________

Oracle Application Security is based on your oracle application sign on. Sign on is your username and password to log on to Oracle Applications.
Sign On connects you to your responsibility, which controls your access to application, forms, reports, Programs and Data.

This Sign-on will help you to connect to the application from user tier. This is used by functional consultant and users to log into the application.















Application Log on Steps:
step1: Open your web browser and click on application URL

















step2: Log on using username and password



















step3:Choose a responsibility

















step4:Click on function to open the form



















__________________________________________________
2.Overview of user
__________________________________________________
User - who has permission log-in to the application. Default username and password is Operations and welcome.


Navigation to Create new user:
Security > User > Define


















__________________________________________________
3.Overview of Responsibility
__________________________________________________
Responsibility – Group of form, reports and Program user can access. One User can have many responsibilities.
Navigation to Create new Responsibility
Security > Responsibility > Define


















__________________________________________________
4.Overview of Menu Group
__________________________________________________
Menu Group – Group of forms user can access. Menu can have form from many application.
Navigation to Create new Menu Group
Application > Menu



















__________________________________________________
5.Overview of Request Group
__________________________________________________
Request Group – It talk about which programs and reports user should access. And you can add program from different applications.
Navigation to Create new Data group
Security > ORACLE > Data group




















__________________________________________________
6.Overview of Basic Navigations and Features
__________________________________________________
Expand/Collapse Buttons:
Double ++ to expand all sublevels
Single + to expand all child sublevels
Double - - to collapse all sublevels
Single - to collapse all child sublevels

Creating shortcut to frequently using forms:
You can copy the most frequently used forms to navigation top 10 list allocated on the right hand side of navigation window. By tying the top ten list number to open that form


































You can see the history of the form from help menu.This is called who information. Create by, creation date, updated by, updated date and updated login.
Help > Record History

















__________________________________________________
7.Overview of Some Commands
__________________________________________________
There are some short cut keys in the application which are very useful working with the application.
F11 – To get the for to query mode
CTL+ F11 – To Execute the query
Navigation to get more keys
Help > Key Board Help

Concept Of MULTIORG

_____________________________________________________

Overview of Multiorg
_____________________________________________________

1. Need for Multiorg.
2. Parts of Multiorg.
3. Steps in defining the Multiorg.
4. Technical Impact of Multiorg.
5. Applications Secured by Diff Organization.

_____________________________________________________
1.Need for Multiorg
_____________________________________________________

/>In a single installation of Oracle Application product can support any number of organizations.
/>Secure access to data so that users can access only the information that is relevant to them.
/>Sell product from a legal entity that uses one set of books and ship them from another legal entity using a different set of books, and automatically record the appropriate inter company accounts payable and accounts receivable invoices
/>Support any number of legal entities within a single installation of Oracle Applications

_____________________________________________________
2.Parts of Multiorg
_____________________________________________________

Set of Books:
A Financial Reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only .

Business Group:
The business group represents the highest level in the organization structure, such as the consolidated enterprise, a major division, or an operation company. The business group secures human resources information. For example, when you request a list of employees, you see all employees assigned to the business group of which your organization is a part.

Legal Entity:
A legal company for which you prepare fiscal or tax reports. You assign tax identifies and other legal entity information to this type of organization.

Operating Unit:
An organization that uses Oracle Cash Management, Order Management and Shipping Executing, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales office, a division, or a department, an operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.

Inventory Organizations
An Organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products
The following applications secure information by inventory organization: oracle inventory, bill of material, engineering, work in process, master scheduling/MRP, capacity, purchasing receiving functions.

















______________________________________________________
3.Steps in defining the Multiorg
______________________________________________________

Step-1 Define Location
Step-2 Define New Business Group and add Location
Step-3 Add Business group to HR Security profile,MO security profile option at responsibility level and HR User type as HR user or payroll.
Step-4 Define New Set of books and add it to GL Sets of Books Name profile option at set of books level.
Step-5 Define Legal entity and add it to Sets of Books
Step-6 Define Operating Unit and add it to Legal entity
Step-7 Define workday calendar in Inventory
Step-7 Add the operating unit to MO Security profile at responsibity level.
Step-8 Define workday calendar.
Step-9 Run Replicate seed data Concurrent Program by giving operating unit name as parameter.

You can define Multi Org from Purchasing, Inventory and HRMS responsibilities.
One Parent organization can have multiple child organizations

______________________________________________________
4.Technical Impact of Multiorg
______________________________________________________

Table of Multiorg Setup

Business Group data will store in HR_ORGANIZATION_UNITS

Legal Entity data will store in HR_LEGAL_ENTITIES

Operating Unit data will store in HR_OPERATING_UNITS

Inventory data will store in MTL_PARAMETERS

Relations ships between this organizations are stored in will store in ORG_ORGANIZATION_DEFINITIONS


Design of Views and Table:
Multiple organizations in oracle applications is enabled by partitioning some database tables by operating unit . Other tables shared across operating units ( and thus across sets of books).
In the base tables all org will be stored but it is divided using specific column based on the organization. Each sob data is divided by sob_id , operating unit by org_id and inventory organization data by organization id.
All Operating specific tables end with ALL at the end of the table.
In oracle applications, data partitioning is performed by database views. These views reside in the apps oracle schema and drive the appropriate operating unit. Context form an RDBMS variable.

RDBMS Variable:
A global variable exits in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes used to store the operating unit id ( or org-id)for the multiple organization support feature. The client-info context is derived from a profile option that the user sets for each responsibility as part of the multi-org setup steps.

All Multiorg views are partitioned by org_id and org_id value will be stored in for CLIENT _INFO variable. It will in be initialized form profile option when run for applications.
When you query Multi org view from database it will not give any data because org_id will not be initialized we have to explicitly initialize it.

Example – Select * from PO_HEADERS_ALL
it will give all organizations po details.

Example – Select * from PO_HEADERS
will give specific po details for initialized org

Setting Up Client Info:

Begin
Fnd_Client_info.SetUp_Client_Info(resp_appl_id, resp_id, user_id, security_group_id) ;
End;

Setting Up Organization Context:

Begin
Fnd_Client_info.Set_Org_Context(org_id) ;
End;

___________________________________________________
5.Applications Secured by Diff Organization
___________________________________________________

Set Of Books:
General Ledger

Operating Unit:
Payables
Receivables
Project Accounting

Inventory Origination:
Inventory
BOM
WIP

FAQ'S I FACED IN INTERVIEW FOR INTELLIGROUP ASIA LIMITED

HI DUDES
I HAD ATTENDED INTERVIEW ON ORACLE APPLICATIONS TECHNICAL.....
THE QUESTIONS ARE PRETTY SIMPLE AND ALL R BASIC
1. HOW DO U RATE URSELF IN SQL AND PL SQL?
2. WHAT U HAD DONE IN UR TRAINING PERIOD OF ORACLE APPLICATIONS?
3. WHAT R THE DATE FUNCTIONS AVAILABLE IN SQL?
4. WHAT IS A JOIN ? HOW MANY JOINS ARE POSSIBLE IN ORACLE AND WHAT ARE THEY?
5. WHAT IS A CURSOR? EXPLAIN ABOUT CURSORS?
6. WHAT ARE EXCEPTIONS U HANDLED UPTO NOW?
7. WHAT IS A PACKAGE AND HOW TO CALL PROCEDURE FROM PACKAGE?
8. WHAT R THE REPORTS U DEVELOPED WHAT ARE THE ERRORS U FACED?
9. WHAT IS FORM PERSONALIZATION?
10. WHAT IS A FORMULA COLUMN? WHY DO U USE IT?
11. WHAT ARE REPORT LEVEL OBJECTS?
12. HOW DO U REGISTER A REPORT IN A CONCURRENT PROGRAM?
THEN AT LAST WHAT ARE UR HOBBIES????????
THERE COMES THE END .........