Friday, August 1, 2008

Oracle Apps Question / Answer


1.Q. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i).
Ans:- There are 8 types of Values Sets.
a. None (Non Validate at all) (Validation is Minimal)
b. Independent (Input must exist on previous defined list of values)
c. Dependent (Input is checked against a subset of values based on prior Value)
d. Table (Input is checked against a subset of values in an application table)
e. Special (advanced) (Value set uses a flexfield itself)
f. Pair (advanced) (Two Flexfields together specify a range of valid values)
g. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)
h. Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)
(Note:- When you first define your flexfields, you choose how many segments
You want to use and what order you want them to appear. You also
Choose how you want to validate each of your segments. The decisions
You make affect how you define your value sets and your values.)

2.Q. How to run a concurrent program. What all concurrent programs u have created.
Ans:- (Definition :- A concurrent program is an instance of an execution file, along with
parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.)
Oracle Tool Concurrent Program * A concurrent program written in
· Oracle Reports, PL/SQL package procedures,
SQL*Loader, SQL*Plus, Host Scripting.
How to Run : * Write a execution file and place in correct directory.
· Establish executables in Oracle apps specify execution file and method.
· Define Concurrent Program (Program, Parameters and Incompatibilities)
· Call your Program (- Thu application form, from other concurrent program.
- OR through standard request submission, you must check the ‘USE in SRS check box’ and register your program parameters when you define your concurrent program. Add your program into the request security group for your custom application.)
I have created reports through concurrent program, load(sql*loader/pl-sql pkg-proc) the file through concurrent program.

3.Q. What is parameter in apps and from where u can create it.
Ans:- Parameters only using in report, you can create in defining the report in
apps (you can create the parameter there only).

4.Q.What all are the tables used in the modules u have worked on.
*In GL – I have worked on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES), GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),
*In PO- I have worked on PO_HEADER_ALL…..

5.Q.What is Profile? Explain different levels of Profile.
Ans:- A user profile is a set of changeable options that affects the way your
applications run. Oracle Application Object Library establishes a value
for each option in a user’s profile when the user logs on or changes
responsibility. Your user can change the value of profile options at any
time a) To create Profile Option. ( Profile Option can created by developer in application developer area) b)set the value (Values of the profile option , who will have what value at various levels is set by SYSADMIN). Oracle Application Object Library provides many options that. (Edit profile feature for every user is available to set any value to allow the user).your users can set to alter the user interface of your applications to satisfy their individual preferences.
Profile Option – set at run time like – User Related, responsibility, Sequence, Printer, Security.
Values in 4 Levels(HIEARCHY WISE) :-
A. USER
B. RESPONSIBILITY
C. APPLICATION
D. SITE
Application Developer create the profile.
System Administrator make profile option.
(NOTE:- If any change in value, it will active when you re-login or switch
to the responsibility.)
( Usage in the multi-tier, the profile is biggest impact)

6. Q.How to restrict the data for a responsibility as per the ORG-ID
Ans:-Through Multi – Org(MO) u can restrict the data for a responsibility as per the ORG-ID. Only in GL- Set of book Id you set the value to restrict the data for a responsibility.

7.Q. What is Flexfield? What is flexfield qualifier and what is segment qualifier?
Ans:- A flexfield is made up a segments (Which are actually table columns). Each segment has a name that can be assigned, and set of valid value.
Purpose and Application:-
* Flexibility to implement code structure.
* Flexibility to capture additional information.
Two Types of Flexfields in oracle apps.
Key Flexfields (KFF)
Descriptive Flexfields (DFF)
A key flexfield segment has a name you assign, and set of valid values you specify. Each value has a meaning which can be specified.
Flexfield Qualifier:-A flexfield qualifier identifies a particular segment of a key flexfield..
Usually an application needs some method of identifying a particular
segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to
use for segment identification.
Segment Qualifier :- A segment qualifier identifies a particular type of value in a single
segment of a key flexfield.
In the Oracle Applications, only the. Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type

8.Q. Which flexfield qualifiers are mandatory?
Ans:- ‘Balancing Segment’ flexfield qualifier is mandatory.

9. Difference Between versions of Apps.(Front end & Database)
Ans:- In backend- Client server architecture (old)/ Three tire architecture
In font end- Client Server Application (old)/ Web Based application

10.Q.What Difference Between report development and report customization.
Ans:- Report Development means – make the new report and attach to the oracle apps.
Report Customization means – customize the existing oracle apps report.

11.Q.What is MULTI-ORG and what is structure of multi-org.
Ans:- Use a single installation of any oracle applications product to support any number of organizations. if those organizations use different set of books.
Support any number or legal entities with a single installation of oracle applications.
Secure access to data so that users can access only the information that is relevant to them.
Structure :- Business Unit
-HRMS(Employee)
-GL(Set of Books)(Currency, Calendar, Chart of Account)
-Balancing Segment(You can do multiple balancing segment)
-Operating Units (Purchase, Selling, Fixed Asset, Payable,
Receivables)
-Inventory Organizations (Storing Items, Transaction Happening,
Ware Housing)
(Note:- Means if you maintaining GL(set of book id), If u have operating unit, if you
have inventory then its called MULTI-ORG)

12.Q.What is difference between ORG_ID and ORGANIZATION_ID in Multi-Org.
At where we can set ORG_ID and ORGANIZATION_ID level it comes in the
structure.
Ans:-A Global Variable exists in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes are used to store the operating unit ID(or ORG_ID) for the multiple organization support feature.
Multi-Org views are partitioned by ORG_ID. The ORG_ID value is stored in CLIENT_INFO variable.(It comes in AP,PO,AR,OM level)
ORGANIZATION_ID – Its for Inventory, Mfg, & BOM.

13.Q.ORG_ID can be set at master levels or transaction level.
Ans:- ORG_ID can be set at transaction Level.

14.Q.Differnet type of execution methods in Conc.Progs. Explain Each Type.
Ans:- a.Oracle Reports- You can register your report as executable file type is oracle reports.
b. PL/SQL Package Procedure - You can register your PL/SQL Package Procedure as executable file type is oracle PL/SQL Package Procedure.
SQL Loader- You can register your SQL Loader SQL Loader is your executable file type.(for data loading)
SQL*Plus :- You can register your SQL script as SQL*Plus executable type.
Host Scripting:- You can write down Unix Host scripting and register here.

15.Q. What is Database Tuning:-
Ans:- Database Tuning is required when your program is using more resource and performance is very slow, database tuning is required. Means its required some optimization in database level. There are two types of optimization
Cost Based optimization.
Rule based optimization.

16.Q.What is Schema
Ans:-The create Schema command creates a collection of tables, views, and previlege grants as a single transaction. The schema name is the same as your oracle user name. The create table, create view, an grant commands are the standard commands, and the order in which the commands appear is not important, even if there internal dependencies.

17.Q. What is difference between oracle schema and apps schema.
Ans:-Database Schema-
The APPS schema- is an ORACLE schema that has access to the
complete Oracle Applications data model. This schema is maintained
by AutoInstall.

18.Q.What are the objects APPS schema contain.
Ans:- The APPS schema contains synonyms to all tables and
sequences as well as all server–side code (stored procedures, views,
and database triggers).
For ERP applications, data partitioning is performed by database
views. These views reside in the APPS Oracle schema and derive the
appropriate operating unit context from an RDBMS variable.

19.Q.What is Workflow and what is the benefit of using workflow
Ans:-A graphical tool that allows you to CREATE, TRACK and MODIFY business process.
Embedded in the Oracle Database Server, It can monitor the workflow activity statuses.
Benefits:-
*Create a clear business process definition
*Automate the business routings
*Monitor the process
*Allow users to define their own business process to suit their organization needs.
*Readily change the business process definitions in case of a change business process.

20.Q.Where exactly u place your forms in APPS environment.
Ans:- /apps/visappl/au/11.5.0/forms/US

21.Q.What is type of Triggers in Oracle
Ans:- Two Types of trigger in Oracle.
Trigger only fire on table or any specific column for that table, it will fire when any DML statement (INSERT,UODATE,DELETE) will execute, its system control
Statement Level Trigger. (Under this there are 6 triggers)
1.Befor Insert
2.Before Update
3.Before Delete
4.After Insert
5.After Update
6.After Delete
Row Level Trigger. (Under this there are 6 triggers)
1.Befor Insert
2.Before Update
3.Before Delete
4.After Insert
5.After Update
6.After Delete

1 comment:

Unknown said...
This comment has been removed by the author.