Oracle Applications FAQs/ info   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse Talk � Archives � Cine Talk - Reviews, Gossips, Insider Info etc. � Archive through January 06, 2005 � Oracle Applications FAQs/ info � Previous Next �

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Manishi
Bewarse
Username: Manishi

Post Number: 1474
Registered: 06-2004
Posted From: 129.9.163.233

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, January 04, 2005 - 9:35 am:   Edit PostDelete PostView Post/Check IP

Admin/Mods chinna request -

Ila tech interview questions anni okha chota petti main page/DB lo aa link post cheya vachuga ! In future if anyone wants they refer them directly from here

mamalu everyone try to send their area of expertise Tech faq.

Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3399
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, January 04, 2005 - 9:31 am:   Edit PostDelete PostView Post/Check IP

Thank You very Much mama.
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3413
Registered: 07-2004
Posted From: 198.169.189.226

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, January 04, 2005 - 7:17 am:   Edit PostDelete PostView Post/Check IP

Hemanth maama... am putting the answers for tech qns...func qns ki answers u cna find in metalink..or i will post here in 2 days ...

*************************************************

1) How to register a report
Create an executable file
Define concurrent program
Define request group
Attach request group to responsibility
Attach responsibility to user

2) What are different types of flexfields

3) What are rollback segments
Rollback segments are areas in database which are used to temporarily save the previous values when some (DML commands ) updates, insert and deletes are executing.

4) What is a request set
Group (set) of requests

5) What are the new features in Oracle 9i
EXPLICITLY NAMED INDEXES ON KEYS
In Oracle9i the index used to support Primary and Unique keys can be defined independently of the constraint itself by using the CREATE INDEX syntax within the USING UNDEX clause of the CREATE TABLE statement
PK LOOKUP DURING FK INSERTION
During insertions foreign key values are checked against the primary keys of referenced tables. This process is optimized in Oracle9i by caching the first 256 PK values of the referenced table on insertion of the second record of a multiple insert. The process is done on the second record to prevent the overhead of managing the cache on a single insert.
VIEW CONSTRAINTS
Declarative primary key, unique key and foreign key constraints can now be defined against views. The NOT NULL constraint is inherited from the base table so it cannot be declared explicitly
FUNCTION BASED INDEX ENHANCEMENTS
MULTI TABLE INSERTS
FTP From PL/SQL
RENAMING COLUMNS, CONSTRAINTS
UTL_FILE - Random Access of Files
FILE UPLOAD AND DOWNLOAD PROCEDURES
Oracle provide a mechanism to upload and download files directly from the database using a Database Access Descriptor (DAD).

6) How many types of triggers in reports and the sequence of triggers
Types of triggers:-
Formula tiggers
Fomat triggers
Action triggers
Validation triggers
Report triggers
Group filters
Oracle reports has five global report triggers and the sequence of triggers are
Before parameter form
After parameter form
Before report
Between pages
After report

7) What is a place holder column
Place holder column is used to store the data on a report

8) What is the use of user_exit
User Exits means a program that you write and then link into the Report Builder executable. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
SRW.User_Exit(String)
String is the name of the user exit you want to call and any columns or parameters that you want to pass to the user exit program.

9) Different types of valuesets
Independent
Dependent
Table
None
Special/pair
Translatable independent
Translatable dependent

10) How to register a form
Create a form using dev 6i/ developer 2000
Save the form as template.fmb in the apps template path.
Registering the forms should be done under Apllication Developer Responsibility.
It involves following steps.
1: Application-->Form
Register form under custom application.
2: Application-->Function
Register your form as a function here.
3: Apllication-->Menu
Attach the form function to the desired responsibilty menu.
4.Attaching menu to responsibility
5.Attaching responsibility to user

11) Can we delete a concurrent program once it is created
We can disable a concurrent program once created but we can’t delete it.

12) Sequence of triggers in forms
Pre_form
Pre_block
Pre_record
Pre_text_item
When_new_form_instance
When_new_block_instance
When_new_record_instance
When_new_item_instance
Post_text_item
Post_record
Post_block
Post_form

13) Can we change the sequence of triggers in forms

14) What are pl/sql tables?
Objects of type TABLE are called "PL/SQL tables", which are modeled as (but not the same as) database tables, PL/SQL tables use a primary PL/SQL tables can have one column and a primary key.

15) Howmany columns will be there in pl/sql tables
PL/SQL tables can have one column and a primary key

16) What is a token
Token is nothing but the user parameters that user will pass when running the report at run time.

17) What are instead of triggers
Instead of triggers are used to perform DML commands in complex views.
Syntax:
create or replace trigger trigger name instead of update/ insert/delete on viewname
begin
---
end



18) How to remove duplicate rows in a table
Yes, using the ROWID field. The ROWID is unique.
Delete from tablename where rowid not in
(select max(rowid) from tablename group by no)

19) Can we update from another table
Yes. For example, if we had a table DEPT_SUMMARY, we could update the number of employees field as follows
update DEPT_SUMMARY s set NUM_EMPS = (select count(1) from EMP E where E.DEPTNO = S.DEPTNO);

20) How can we rename a column
Yes. Its an oracle 9i feature.
Syntax :
ALTER TABLE table name RENAME COLUMN old column name TO new column name

21) What are % TYPE and % ROWTYPE What are the advantages of using these over datatypes
% TYPE provides the data type of a variable or a database column to that variable.

% ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor.

The advantages are : I. Need not know about variable's data type
ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly.

22) What is diffeence between % ROWTYPE and TYPE RECORD
% ROWTYPE is to be used whenever query returns a entire row of a table or view.

TYPE rec RECORD is to be used whenever query returns columns of different
table or views and variables.

23) Types of cursors
There are two types of cursors, Implict Cursor and Explicit Cursor.
PL/SQL uses Implict Cursors for queries.
User defined cursors are called Explicit Cursors. They can be declared and used.

24) When implicit cursors will be used
When running SQL Queries

25) Can we use commit / rollback in a trigger
It is not possible. As triggers are defined for each table, if you use COMMIT or ROLLBACK in a trigger, it affects logical transaction processing.

26) What are two virtual columns available during database trigger execution
The virtual columns are OLD.column_name and NEW.column_name.
For triggers related to INSERT only NEW.column_name values only available.
For triggers related to UPDATE only OLD.column_name NEW.column_name values only available.
For triggers related to DELETE only OLD.column_name values only available.


27) Different types of exceptions
Exception is the error handling part of PL/SQL block.
The types are
Implicit - defined by system(pre defined)
Explicit – defined by user(user defined)
Explicit exceptions has to declare, raise and catch the exception.
In implicit exceptions we have to catch the exception no need to declare and raise.

28) What is Pragma EXECPTION_INIT
The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error.
e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

29) What are the return values of functions SQLCODE and SQLERRM
SQLCODE returns the latest code of the error that has occured.
SQLERRM returns the relevant error message of the SQLCODE.

30) Differnce between procedure and function
Function returns one value
Procedure returns multiple values as out parameters
Function return value
Procedure returns variable
Function return type can be assign to a value
Procedure return type can not be assigned to a variable
In procedure we can use one parameter for both input and out put (in out parameter)
In function we can not use one parameter for both input and output

31) Advantages of packages
Package is a database object that groups logically related procedures.
The advantages of packages are Modularity, Easier Applicaton Design, Information. Hiding,. reusability and Better Performance.

32) If we create a table from another table what will happened to the constraints of the table
Only not null constraint will come to the new table. All other constraints (unique, check, primary key) will not come to the new table.


33) What are global temporary tables
TEMPORARY TABLES introduced in Oracle8i. This new feature allows temporary tables to be created automatically in a users temporary tablespace. Syntax: CREATE GLOBAL TEMPORARY TABLE tablename ( columns ) [ ON COMMIT PRESERVE | DELETE ROWS ] The default option is to delete rows on commit

34) What is mutuating error
If we execute more than one transaction on one table on same time then mutuation error will occur

35) What is diff between ref cursor and cursor
Ref cursors are dynamic cursors.
Sometimes the definition of the cursor may not be known until runtime, then we can use ref cursor.
Normal cursors are static cursors. first we have to declare the cursor.

36) Exceptions in UTL files
WHEN UTL_FILE.INVALID_PATH THEN
WHEN UTL_FILE.INVALID_MODE THEN
WHEN UTL_FILE.INVALID_OPERATION THEN
WHEN UTL_FILE.INVALID_FILEHANDLE THEN
WHEN UTL_FILE.WRITE_ERROR THEN
WHEN UTL_FILE.INTERNAL_ERROR THEN

37) What are _vl, _v and pl tables

38) Autonomus transactions
An autonomous transaction is an independent transaction started by another
transaction, the main transaction. Autonomous transactions let you suspend
the main transaction, do SQL operations, commit or roll back those
operations, then resume the main transaction.
Advantages of Autonomous Transactions
Once started, an autonomous transaction is fully independent. It shares no
locks, resources, or commit-dependencies with the main transaction. So, you
can log events, increment retry counters, and so on, even if the main
transaction rolls back.

39) Dynamic sql
Dynamic SQL allows an application to run SQL statements whose contents are not known until runtime. Generally dynamic SQL is slower than static SQL so it should not be used unless absolutely necessary.
The main advantage of dynamic SQL is that it allows you to perform DDL commands that are not supported directly within PL/SQL, such as creating tables.

40) Standard WHO columns
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

41) In ff’s what type of data will store

42) Sql command to print
Great if sal>10000, less if sal<10000 and normal if sal=10000

select
sal,
case
when sal < 1000 then 'Less'
when sal > 1000 then 'Great'
when sal = 1000 then ‘Nomal’
end
from emp

43) Tables for flex fields, value sets and values

44) What are format triggers
Format triggers are PL/SQL functions executed before the object is formatted. These triggers can be used to dynamically change the formatting attributes(ex: Font) of any object of the report.

45) What are lexical parameters
Lexical parameters are dynamic parameters . Instead of giving one value we can pass text by using lexical parameter.
Lexical parameters can replace all parts of the query upon which the report is based.
SELECT empno,ename
FROM emp
&p_where
In the example above, the lexical parameter “p_where” can replace the WHERE or ORDER BY uses or a combination of them. The lexical parameter can be built either by the application calling the report, or by the report itself in a program unit such as an AFTER-PARAMETER-FORM trigger or a formula column.


46) What are bad files
These are process files created during data loading thru sql loader when the data records are rejected

47) Diff between primary key and unique key
Unique key accepts null values
Primary key not accepts null values.
Unique key can not establish a relationship
Primary key establish relationship

48) Interface tables in purchasing
49) Process in purchasing
50) Diff between system profiles and user profiles
51) Sourcing rule
52) Punchouts
53) 4 way matching
54) primary key in vendor site contacts table

55) multi org structure
56) what is request group
it determines what reports and request sets a user is allowed to run with the responsibility.
57) system packages


58) different dffs

59) how to restrict a specific org
60) What is the syntax of loading a Data file to a Table? What types file is required to Load a data file? What is the syntax of control file

Sqlldr user name/password control=control file name.ctl
control files are required to load data.
This sample control file will load an external data file containing delimited data:
load data
infile 'c:\data\mydata.csv'
into table emp
fields terminated by ","
( empno, empname, sal, deptno )

The mydata.csv file may look like this:
10001,"Scott Tiger", 1000, 40
10002,"Frank Naude", 500, 20

61) What are the different types of PO? What are the differences among those Pos?

62) What are the different types of Execution Method
PL/SQL Stored Procedure
Oracle Reports
Host
Request set stage function
Immediate
Java stored Procedure
Java Concurrent Program
Multi Language function
Spawned
SQL * Loader
SQL Plus

63) How do you call/register a Form or Report from a menu

64) What is the difference between DISCARD and BAD file
Bad file
If a record cannot be loaded because it is rejected it will be written into the bad file.
Discard file
The discard file contains records that didn't meet any of the record selection critierias.

65) What is the link between po and ap modules
66) Can we change the creation date in an approved po
67) one data file consists of 500 records. How to load only 10 records into a staging a Table, from that data file? In which file we can find all the unloaded records?
We can load only 10 records out of 500 records by using "SKIP n"
All the unloaded records will be in dis card file

68) Suppose u have received a mail from your client, for the development of a new form/report/interface. For this development, you have not received any document. In which way, you will proceed? From Analysis to Implementation and Production Support.
69) How are cross validation rules differ from security rules
70) Which module in orcle application uses LE
71) Howmany segments can be there in the chart of accounts
30
72) What is the use of primary and secondary set of books
73) What is a distribution hold in AP ? Can it be removed manually ?
74) How did you use document sequencing for each org ? How would you accomplish it for multiple operating units ?
75) Which module will not support MRC feature
76) If my instance is multi-org for suppliers, should we specify at header level or site level ?
The multiorg structure is enforced at the supplier site level. The org id is stored in the PO_VENDOR_SITES_ALL table

77) How is the localization implemented for the tax accounting module ?
Localized taxes – Excise duty, Sales taxes, customs duty, service taxes etc can be associated at the PO or SO level and they ultimately flow into AP / AR.

78) Difference between delete and truncate
Truncate is a ddl command, so we cant rollback once its run.
Delete is a dml command, we can rollback the transaction.
Delete is followed by Commit but truncate does not
Delete uses memory space but Truncate does not

79) Difference between nested tables and varrays
Varrys have max size, nested tables does not have max size
Varrays store in the same table with the containing table
Nested tables are stored in a separate table

80) What is mutating table error

81) Oracle system tables
System Table Description
ALL_ARGUMENTS Arguments in object accessible to the user
ALL_CATALOG All tables, views, synonyms, sequences accessible to the user
ALL_COL_COMMENTS Comments on columns of accessible tables and views
ALL_CONSTRAINTS Constraint definitions on accessible tables
ALL_CONS_COLUMNS Information about accessible columns in constraint definitions
ALL_DB_LINKS Database links accessible to the user
ALL_ERRORS Current errors on stored objects that user is allowed to create
ALL_INDEXES Descriptions of indexes on tables accessible to the user
ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES
ALL_LOBS Description of LOBs contained in tables accessible to the user
ALL_OBJECTS Objects accessible to the user
ALL_OBJECT_TABLES Description of all object tables accessible to the user
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
ALL_SNAPSHOTS Snapshots the user can access
ALL_SOURCE Current source on stored objects that user is allowed to create
ALL_SYNONYMS All synonyms accessible to the user
ALL_TABLES Description of relational tables accessible to the user
ALL_TAB_COLUMNS Columns of user's tables, views and clusters
ALL_TAB_COL_STATISTICS Columns of user's tables, views and clusters
ALL_TAB_COMMENTS Comments on tables and views accessible to the user
ALL_TRIGGERS Triggers accessible to the current user
ALL_TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables
ALL_TYPES Description of types accessible to the user
ALL_UPDATABLE_COLUMNS Description of all updatable columns
ALL_USERS Information about all users of the database
ALL_VIEWS Description of views accessible to the user
DATABASE_COMPATIBLE_LEVEL Database compatible parameter set via init.ora
DBA_DB_LINKS All database links in the database
DBA_ERRORS Current errors on all stored objects in the database
DBA_OBJECTS All objects in the database
DBA_ROLES All Roles which exist in the database
DBA_ROLE_PRIVS Roles granted to users and roles
DBA_SOURCE Source of all stored objects in the database
DBA_TABLESPACES Description of all tablespaces
DBA_TAB_PRIVS All grants on objects in the database
DBA_TRIGGERS All triggers in the database
DBA_TS_QUOTAS Tablespace quotas for all users
DBA_USERS Information about all users of the database
DBA_VIEWS Description of all views in the database
DICTIONARY Description of data dictionary tables and views
DICT_COLUMNS Description of columns in data dictionary tables and views
GLOBAL_NAME global database name
NLS_DATABASE_PARAMETERS Permanent NLS parameters of the database
NLS_INSTANCE_PARAMETERS NLS parameters of the instance
NLS_SESSION_PARAMETERS NLS parameters of the user session
PRODUCT_COMPONENT_VERSION version and status information for component products
ROLE_TAB_PRIVS Table privileges granted to roles
SESSION_PRIVS Privileges which the user currently has set
SESSION_ROLES Roles which the user currently has enabled.
SYSTEM_PRIVILEGE_MAP Description table for privilege type codes. Maps privilege type numbers to type names
TABLE_PRIVILEGES Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
TABLE_PRIVILEGE_MAP Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names

82) Work flow of po
83) Trouble areas in India localization
Mainly India Localization Taxes

84) Tables for tax category and item tax category
ja_in_tax_categories
ja_in_item_category_list_hdr
ja_in_item_category_list_dtl

85) Can we change the chart of accounts in sob once it is created

86) How the po form will be different in localized po
Tax amount will be added to the total price on main screen of the po.
There will be one tax button on the po if we open that we can see the individual taxes added for that po.

87) Can we delete a DFF

88) KFF’s in oracle gl, inv, po and hr
GL
Accounting FF
INV
Item Catalogs FF
Item Categories FF
Sales Orders FF
Stock Locators FF
System Items FF
PO
No KFF’s
HR
Grade FF
Job FF
Position FF
Personal Analysis FF
Soft coded FF


89) Can we delete oracle application user













Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3364
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:34 pm:   Edit PostDelete PostView Post/Check IP

vaake mama Bye mama.
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3363
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:33 pm:   Edit PostDelete PostView Post/Check IP

sure mama.

complete knowledge vachaka resume thayaru cheyyana, leka munde resume thayaru cheyyana, denikantee, chadavakunda resume thayaru chesananuko, manaku theliyani topics unte aa projects pettalo vadho ardam kaadu. kaani pettesthee vatilni chadavali compulsory ga. So resume thayaru chesesi chadavatam start cheyyana???
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3412
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:33 pm:   Edit PostDelete PostView Post/Check IP

Nitho maama

thanks n wish u the same maama.....thanks maama


hemanth maama..will be talking to u shortly...repati kalla answers istha below qns ki..(they are asked in infy,wipro,tcs,deliotte,kpmg etc etc qns ..i consolidated them)

chalo bye for now

Nitho maama...repu matladutha...feel avamaaku
Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Kurra Bewarse
Username: Nitho

Post Number: 1000
Registered: 12-2004
Posted From: 63.231.161.118

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:30 pm:   Edit PostDelete PostView Post/Check IP

MM mama aippy new year mama
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3411
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:29 pm:   Edit PostDelete PostView Post/Check IP

kool hemanth maama

metalink unte ika kummukooo

thats mother of all oracle stuff
emanna additional docs kaavaalante naaku mailing seyyi maama..

Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3362
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:27 pm:   Edit PostDelete PostView Post/Check IP

megamama, dont worry I got the metalink userid and password. :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3361
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:26 pm:   Edit PostDelete PostView Post/Check IP

thanks mama, mail cheseyy mama naaku ok na, thanks mama, inka full swing lo start cheyyala. :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3410
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:26 pm:   Edit PostDelete PostView Post/Check IP

yeah manishi maama thats other good way of doing it..
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3360
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:25 pm:   Edit PostDelete PostView Post/Check IP

Manishi mama, thanks maam, kaani naaku first of all topic names thelsu anthee, I am searching for questions, so inka nenu questions ni google kotte chance ledu. :-) anyway thats the best method which u told.
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3409
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:25 pm:   Edit PostDelete PostView Post/Check IP

Hemanth maama

metalink lo oracle ki sambhandinchina anni qns untaayi

oracle reports
oracle forms
SQL
PL/SQL
Oracle apps
and etc oracle products

neeku login iddamu anukunna kaani its too official maama..anduke ivvaledu..nene anni ikkade or neeku mail chestha

kinda ichian 80 qns lo 40 answering chesa..inko 40 repu morning kalla chesi neeku mailing setta..leka ikkade seckign sesko repu morning...vaake na??
Top of pagePrevious messageNext messageBottom of page Link to this message

Manishi
Bewarse
Username: Manishi

Post Number: 1469
Registered: 06-2004
Posted From: 129.9.163.233

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:23 pm:   Edit PostDelete PostView Post/Check IP

>>>megamama, metalink lo even PL/SQL lo kooda questions and answers untaya mama??

hemanth mama, Simple trick. aa questions ki answer kavali ante okha question ni teesukoni google lo search kottu !

You will find answers to all the questions in no time
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3358
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:20 pm:   Edit PostDelete PostView Post/Check IP

nee yankamma brad sampethaaa.
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3357
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:19 pm:   Edit PostDelete PostView Post/Check IP

megamama, metalink lo even PL/SQL lo kooda questions and answers untaya mama??
Top of pagePrevious messageNext messageBottom of page Link to this message

Brad
Bewarse ke Bewarse!
Username: Brad

Post Number: 13847
Registered: 03-2004
Posted From: 204.99.118.40

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:19 pm:   Edit PostDelete PostView Post/Check IP

Megamama.. ikaa dookeyyi mama..
nee questions/knowledge ni Hemu mama cross seck settunnadu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3408
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:17 pm:   Edit PostDelete PostView Post/Check IP

Manishi maama

the link which you gave is very good maama..good info..

bur for ur kind info ....oracle apps or oracle or pl/sql lo evaru interview chesina they will ask as-is qns from oracle metalink(we do generally that way and i have observed that in top cos)
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3356
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:15 pm:   Edit PostDelete PostView Post/Check IP

megamama, thank you very much mama, neeku ee 2005 lo anni subhalee kalugu gaka. :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3355
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:14 pm:   Edit PostDelete PostView Post/Check IP

Manishi mama, simpesav. :-) mega and manishi mee idhariki
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3407
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:14 pm:   Edit PostDelete PostView Post/Check IP

kool maama ..konchem busy ani mail cheyaledu neeku....below 80 qns kooda answer postutha le ide theddulo by tomorrow...nene kookoni answers raastha
Top of pagePrevious messageNext messageBottom of page Link to this message

Manishi
Bewarse
Username: Manishi

Post Number: 1467
Registered: 06-2004
Posted From: 129.9.163.233

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:13 pm:   Edit PostDelete PostView Post/Check IP

hemanth mama,

http://jminds.hollosite.com/dbms/concepts/oracle-c oncepts-6.htm
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3354
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:12 pm:   Edit PostDelete PostView Post/Check IP

mama feel avvaku mama, ninnu adiginatle andarini aduguthunna mama emanan extra info untundemo ani anthe kaani ninu kincha parachalani kaadu maam, doc gaa pampeyy naaku. ok na. :-( nannu apardam sesukunav mama. :-((
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3406
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:11 pm:   Edit PostDelete PostView Post/Check IP

nee enkamma docs la prepare chesi pampiddam ante neeku aage attu ledu..

inko 1 hour lo ee theddu lo anni qns with answers postutha ...ekkichuko ika ...enjoyy
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3353
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:10 pm:   Edit PostDelete PostView Post/Check IP

megamama, exactly I am searching for these type of questions. :-)


Thank You very much mama.
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3352
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:09 pm:   Edit PostDelete PostView Post/Check IP

Ohh thank u mama, copy chesukuntunna. docs ga pampeyy mama, no problem. vaakenaa.
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3351
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:08 pm:   Edit PostDelete PostView Post/Check IP

No problem megamana. Nenu waiting chesthunna mama nee mail kosam, cheppav ga prepare chesthunna ani anduke aaga. :-) ee lopu inka vere valla daggara unnayemo choosthunna mama. I am having the access to metalink mama. :-) Is that is sufficient. denikante mama for example naaku mundu konni basic info theliyadu antee Discoverer tool, daani gurunchi emi ledu metalink lo kaani dani meeda questions and answers unnayi. ante daanni use chesthunnappudu vachina problems etc. andukani basic questions nunchi start ayina docs unnayemo ani searching. :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3405
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:07 pm:   Edit PostDelete PostView Post/Check IP

some qns I composed for u today ...

*******************************************

1) How to register a report in oracle apps
2) What are different types of flexfields
3) What are rollback segments
4) What is a request set
5) What are the new features in Oracle 9i
6) How many types of triggers in reports and the sequence of triggers
7) What is a place holder colmn
8) What is the use of user_exit
9) Different types of valuesets
10) How to register a form
11) Can we delete a concurrent program once it is created
12) Sequence of triggers in forms
13) Can we change the sequence of triggers in forms
14) What are pl/sql tables?
15) Howmany columns will be there in pl/sql tables
16) What is a token
17) What are instead of triggers
18) How to remove duplicate rows in a table
19) Can we update from another table
20) How can we rename a column
21) What are % TYPE and % ROWTYPE What are the advantages of using these over datatypes
22) What is diffeence between % ROWTYPE and TYPE RECORD
23) Types of cursors
24) When implicit cursors will be used
25) Can we use commit / rollback in a trigger
26) What are two virtual columns available during database trigger execution
27) Different types of exceptions
28) What is Pragma EXECPTION_INIT
29) What are the return values of functions SQLCODE and SQLERRM
30) Differnce between procedure and function
31) Advantages of packages
32) If we create a table from another table what will happened to the constraints of the table
33) What are global temporary tables
34) What is mutuating error
35) What is diff between ref cursor and cursor
36) Exceptions in UTL files
37) What are _vl, _v and pl tables
38) Autonomus transactions
39) Dynamic sql
40) Standard WHO columns
41) In ff’s what type of data will store
42) Sql command to print
43) Great if sal>10000, less if sal<10000 and normal if sal=10000


44) Tables for flex fields, value sets and values
45) What are format triggers
46) What are lexical parameters
47) What are bad files
48) Diff between primary key and unique key
49) Interface tables in purchasing
50) Process in purchasing
51) Diff between system profiles and user profiles
52) Sourcing rule
53) Punchouts
54) 4 way matching
55) primary key in vendor site contacts table
56) multi org structure
57) what is request group
58) system packages
59) different dffs
60) how to restrict a specific org
61) What is the syntax of loading a Data file to a Table? What types file is required to Load a data file? What is the syntax of control file
62) What are the different types of PO? What are the differences among those Pos?
63) What are the different types of Execution Method
64) How do you call/register a Form or Report from a menu
65) What is the difference between DISCARD and BAD file
66) What is the link between po and ap modules
67) Can we change the creation date in an approved po
68) one data file consists of 500 records. How to load only 10 records into a staging a Table, from that data file? In which file we can find all the unloaded records?
69) Suppose u have received a mail from your client, for the development of a new form/report/interface. For this development, you have not received any document. In which way, you will proceed? From Analysis to Implementation and Production Support.
70) How are cross validation rules differ from security rules
71) Which module in orcle application uses LE
72) Howmany segments can be there in the chart of accounts
73) What is the use of primary and secondary set of books
74) What is a distribution hold in AP ? Can it be removed manually ?
75) How did you use document sequencing for each org ? How would you accomplish it for multiple operating units ?
76) Which module will not support MRC feature
77) If my instance is multi-org for suppliers, should we specify at header level or site level ?
78) How is the localization implemented for the tax accounting module ?
79) Difference between delete and truncate
80) Difference between nested tables and varrays
81) What is mutating table error
82) Oracle system tables
83) Work flow of po
84) Trouble areas in India localization
85) Tables for tax category and item tax category
86) Can we change the chart of accounts in sob once it is created
87) How the po form will be different in localized po
88) Can we delete a DFF
89) KFF’s in oracle gl, inv, po and hr
90) Can we delete oracle application user












Top of pagePrevious messageNext messageBottom of page Link to this message

Megamama
Vooriki Bewarse
Username: Megamama

Post Number: 3404
Registered: 07-2004
Posted From: 84.230.141.94

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:05 pm:   Edit PostDelete PostView Post/Check IP

Hemanth maama

1 day time ivvu maama nee kosam document prepare chestunna...

konchem busy unna anduke neeku mail ivvaledu..

in 2 days u will be getting ..is that ok???

P.S: ask any of your friends if they have ORACLE METALINK access

site is http://www.metalink.oracle.com/

this contains everything maama...i have the login but its offcial ..anduke naaku time isthe nene neeku compose chestha qns...

just for ur info

thanks
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3350
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:05 pm:   Edit PostDelete PostView Post/Check IP

Thanks mama for the link.

I am more specific on Oracle Applications Financials.

anyway Forms, Reports and PL/SQL meeda kooda kavali mama. Thanks for the link mama, I am saving all those.
Top of pagePrevious messageNext messageBottom of page Link to this message

Sollu
Kurra Bewarse
Username: Sollu

Post Number: 896
Registered: 03-2004
Posted From: 144.160.130.16

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:05 pm:   Edit PostDelete PostView Post/Check IP

madishi mama avi application linkse antava leka Data Base links antava?
Top of pagePrevious messageNext messageBottom of page Link to this message

Manishi
Bewarse
Username: Manishi

Post Number: 1466
Registered: 06-2004
Posted From: 129.9.163.233

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:02 pm:   Edit PostDelete PostView Post/Check IP

Idhi choosava?

http://www.google.com/search?sourceid=navclient&ie =UTF-8&rls=GGLD,GGLD:2004-15,GGLD:en&q=oracle%2Bin terview%2Bquestions

Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3349
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 2:00 pm:   Edit PostDelete PostView Post/Check IP

avi anni soosesaa mama. avi kakunda mana janala daggara manchi FAQs unnayemo ani. ayina naaku Google lo antha manchi info dorakaledu mama, different search creteria ichina saree.
Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3348
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 1:59 pm:   Edit PostDelete PostView Post/Check IP

endi mamalu evvadu OA (Oracle Applications) meeda working seyyatam ledaa???
Top of pagePrevious messageNext messageBottom of page Link to this message

Manishi
Bewarse
Username: Manishi

Post Number: 1464
Registered: 06-2004
Posted From: 129.9.163.233

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 1:59 pm:   Edit PostDelete PostView Post/Check IP

Hemanth mama , Neeku bagha Baddakam ekkuva mama.

Google mama ni "oracle+faq" anni search chesthe boludu linklu.

http://www.orafaq.com/faq/

Top of pagePrevious messageNext messageBottom of page Link to this message

Hemanth
Desanike Pedda Bewarse
Username: Hemanth

Post Number: 3346
Registered: 03-2004
Posted From: 216.138.82.157

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, January 03, 2005 - 1:55 pm:   Edit PostDelete PostView Post/Check IP

Mamalu, Oracle Applications ki sambandinchina FAQs mee daggara untee naaku pampandi mamalu.

FAQs e kaadu ee document unna sare pampeyandi.

even validations meeda or reports meeda unna docs pampeyandi naaku.

PL/SQL lo FAQs unna pampeyandi naaku.

OK naa mamalu.

Naa mail id hemu13@yahoo.com

ee help chesi pettandi mamalu. vaakenaaaa. :-)

(avi lenollu bothu mpegs pampukovachu same mail id ki. kikiki)