Apps Technical Interview Questions
1) How to delete duplicate rows?
2) What is cursor what is the different types of cursors?
3) What is exception and what are different type’s exceptions?
4) What is others exception?
5) How to raise user defined exceptions?
6) In a procedure I have one select stmt that is not retrieving any rows and I have predefined NO_DATA_FOUND exception and user defined no_data_found then which error will raise first?
7) What is materialized view?
8) Can we update a view?
9) What are the types of joins and what is outer join?
10) How will you mention outer join?
11) What is autonomous transaction?
12) What is purpose of autonomous transaction?
13) How to find how many ‘a’ are there in the specified string ‘aasfdhhjkgjaaaa’?
14) What is LSTRING?
15) What are the error codes u faced frequently in your experience?
16) What is primary key?
17) I want to specify 5 columns in a table as NOTNULL and UNIQUE how to do that?
18) What are database triggers? How many types of database triggers are there?
19) When a specific row in a table is updated then I want to insert that row into another table how to do that by using the trigger?
20) What is %row type and %type?
21) I have declare a variable x as emp%rowtype and I have passed a value ‘10’ in run time then is it work successfully if not what error you will get?
22) How you will do performance tuning?
23) What are the forms u developed?
24) What are the types in master details forms?
25) What are the procedures that will gets created when a master details form created?
26) How call a form from another form in apps?
27) What are the triggers that will fire when the cursor moves from master form to detail forms?
28) I want to validate a field not to enter wrong data how to that in forms/
29) What is when validate item trigger?
30) What is the trigger firing sequence in forms?
31) I have developed a form on a complex view now I want to insert on that view is it possible? If not how to do that?
32) What are the work flows you have developed and customized?
33) How you have sent your message to preparer?
34) What are the parameters you pass to a function in work flow?
35) What is role?
36) What are the interfaces you have done?
37) What is FILLER in sql*loader?
38) What are the validations you have done in gl interface?
39) What are the conversions you have done?
40) What is procedure to do a conversion?
41) What is the concurrent program name for customer conversion?
42) What are the tables you have used in customer &vendor conversions?
43) What is the links between these tables?
44) Where will you write plsql code in reports?
45) Where will you execute your plsql code in reports i.e. in which trigger?
46) In a report if we enter any parameters that time the report should not run? How to do that? In which trigger you will write the code?
47) How will you do debugging in reports?
48) What is report tuning?
49) What are the different procedures available in srw.package?
50) What is user exit?
51) What is lexical and bind parameters?
52) What is token?
53) What are the precautions you will take while customizing a report?
54) If I run a report values like profiles have to store in different table how to do that where will you write the code (In which trigger)?
Apps Technical Interview Questions asked in Oracle
1. What are steps of interface?
2. What are the validations you have done in uploading date from Pre interface-to-interface table?
3. What are the forms you have customized and developed?
4. What is your role to develop a new form?
5. Who is giving you specification?
6. What are the steps to develop a new form?
7. What are the problems you had faced after developing a new form’s?
8. Is this form is working fine or not?
9. Tell me about the functionality of the new form you have developed?
10. How to set up Multi Org?
11. How to hide the data from different users in the same Organization?
12. what is the difference between Alert and WF?
13. What is the difference between Data Log file and Tablespace?
14. Can a view be updated? How?
15. What are the lookups of PO?
16. what are the steps to create and customize Forms?
17. What for CUSTOM.PLL is used?
18. How to call a WF in your form?
19. How can you set Value sets in Flex Field?
20. How can you create a module in APPs and how to make it working?
21. What is the structure of Multi Org?
22. Where the ORG ID exists in Multi Org?
23. How to check the Multi Org is enabled or not ?
24. How can you hide some columns of DFF?
25. How can you call the API in any program, especially in Forms and reports?
26. How can you allow the official to see the information of two employees and not to each other?
27. What are the Concurrent Interface Programs you have run for your developed Interfaces?
28. What is the Tablespace, Segment and Extent in Database?
29. Draw the Multi Org structure.
30. What is Set Of Books Id and Chart Of Account?
31. What will be your approach for the assignment to develop the new Form?
a) Analyse the Form
b) Check whether the requirement can be implemented doing Flex Field? If Not then Check, whether the requirement can be accommodated in the existing form by adding some more functionality in the existing form?Else Create a new form.
32. How can you set your Operating Id (Org Id)?
33. what is the methodology of Documentation you use?
34. what is the hierarchy of Organization?
a) Set Of Books B) Legal Entity C) Operating Unit d) Inventory
35. What is the difference between Accruals and Payables?
It’s the recognition of Revenue when you sell goods and recognition of Expense when the supplier provides services or goods.
36. How can you make the program incompatible with itself?
PL/SQL Interview Questions
1. What is Exception? Types of Exceptions? Exception Propagations?
2. What is RAISE_APPLICATION_ERROR?and what is PRAGMA INIT_EXCEPTION?
3. What are the Predefined exceptions we have?
4. When we is SELECT statement in the Execution block what are the Predefined exceptions we have to use in the Exception Block?
5. What is the diff between NO_DATA_FOUND and %NOT FOUND
6. What is CURSOR? What are the Cursor types? what are cursor declaration steps?
7. What is the diff between Implicit and Explicit and Ref Cursor?
8. In which program u has used the Cursor? One example for implicit cursor?
9. What are the Cursor attributes we have?
10. Can we issue the commit inside of the Cursor for Loop?
11. What is For Update OF Clause in the Cursors?
12. What is Procedure and what is Function?
13. What is the RND and WND?
14. What is the diff between Procedure and Function?
15. When we will create Procedure and when we will create function?
16. What is the diff between Package procedure and Standalone procedure?
17. If we drop the table which we have used in the procedure do we need to recompile the procedure then how?
18. How to get the Procedure Source code from database?
19. What is the Advantage of Package?
20. What are the other objects we can group inside of Package?
21. How to Recompile the Package?
22. When we will go for creation of Package? Can we create Package body without creation of Package Specification?
23. Can we declare Procedure directly in the package body without declaring in the package specification?
24. What is Trigger
25. Can we commit inside of trigger? How to delete the Trigger? How many triggers we can use maximum?
26. What are The DML Triggers? What is diff between Row and Statement level trigger?
27. How to Debug PL/SQL Code?
28. What are the Trigger Predicates we have?
29. What is diff between Trigger and Procedure?
30. What is Package Variable what is advantage?
31. What are the Collections?
32. What is PL/SQl Table what is the advantage of that when we will use PL/SQL Table?
33. What is Global temporary table what diff between PL/SQL table and Temporary table?
34. What is %ROWTYPE?
35. What is Instead of Trigger? How can u use that?
36. What is mutating trigger how can you handle this?
37. What are PL/SQL table attributes?
Apps Technical Interview Questions asked in wipro
1. What are different cursors available?
2. What are cursor attributes?
3. Can we use sql%found in Explicit cursors opened in cursor for loop?
4. What is token?
5. What is init pragma exception?
6. How do you define a table type value set depending on another table value set?
7. In this case, if the child parameter has sequence no. as 5 and the parent parameter has sequence no. as 10, what is the effect? When you will get the error and what is the error?
8. What is the order flow including tables effected at each stage?
9. What is the hierarchy of Multi org concept?
10. Where do you define the ‘Set of Books’ in Multi Org Concept?
11. In which table, you will get Organization_id and in which tables, you will get org_id?
12. What is Run alone report?
13. What is incompatibility in Report definition?
14. What you have done for an interface?
15. What is the procedures you have done?
16. Any API used in your procedures?
17. What are different APIs available in Oracle Apps?
18. How the oracle Applications recognizes the print style?
19. what is the use of Row & column columns in Report Definition above the printer style?
20. When the workflow back end process will run in the order cycle?
21. Can you customize a workflow?
22. How a multi org concept effects in GL module?
23. What is a miscellaneous receipts & issues?
24. Do you face any performance related issues in your work?
25. What is TCA architecture?
26. What are the tables effected when ‘ship confirm’?
27. In the order cycle, where it is interrelate with other oracle modules like INV, AR etc.
28. what are the table affected when you make a customer under credit hold?
No comments:
Post a Comment