Important Oracle Apps Interview questions
Especially questions are solely asked based on your CV. Following are some of the questions for oracle apps interviews.
Group left,
Group Above,
Matrix,
Matrix with group,
Form,
Form letter,
Mailing label.
2. What are the table used during report creation? (Questions based on reports created or mention in CV)
3. What are the types of report triggers? Mention sequentially.
Ans: Before parameter form,
After Parameter form,
Before Report,
Between pages,
After report.
4. Mention the mandatory user parameter.
Ans: P_CONC_REQUEST_ID
5. What is legacy system of your client?
6. What is the connection or relation between 'concurrent request' and 'data definition' ?
Ans: 'Short Name' to be copied in 'Code' field of the data definition window.
7. Date when the project started and went live. And the your role during the supporting phase of the project.
8. Explain the complete flow of SCM with tables include.
9.Explain the Interface programs steps.
10. Name all the TCA tables.
11. What are the ways to create Order in Oracle apps.
12. Give the difference between test plan and test scripts.
13. Questions related to AIM documentations.
14. How to Copy the existing order entry data to a new in Order creation window.
15.How to make changes to an existing standard report. Explain whole process.
16.Name any 5 tables from PO and AR modules.
17.What are the types of triggers in PLSQL. Explain.
18. Primary keys between tables oe_order_headers_all and oe_order_lines_all.
19. Difference bet VARCHAR(30) and CHAR(30).
20. State Bulk collect in PLSQL with example.
21. Collection in PLSQL.
22. Difference between ROWNUM and ROWID.
23. What is System Profile options in apps.
24. How to attach concurrent program to a request group.
* Please comment if you have some different important interview questions.
Especially questions are solely asked based on your CV. Following are some of the questions for oracle apps interviews.
- What are the types of oracle reports?
Group left,
Group Above,
Matrix,
Matrix with group,
Form,
Form letter,
Mailing label.
2. What are the table used during report creation? (Questions based on reports created or mention in CV)
3. What are the types of report triggers? Mention sequentially.
Ans: Before parameter form,
After Parameter form,
Before Report,
Between pages,
After report.
4. Mention the mandatory user parameter.
Ans: P_CONC_REQUEST_ID
5. What is legacy system of your client?
6. What is the connection or relation between 'concurrent request' and 'data definition' ?
Ans: 'Short Name' to be copied in 'Code' field of the data definition window.
7. Date when the project started and went live. And the your role during the supporting phase of the project.
8. Explain the complete flow of SCM with tables include.
9.Explain the Interface programs steps.
10. Name all the TCA tables.
11. What are the ways to create Order in Oracle apps.
12. Give the difference between test plan and test scripts.
13. Questions related to AIM documentations.
14. How to Copy the existing order entry data to a new in Order creation window.
15.How to make changes to an existing standard report. Explain whole process.
16.Name any 5 tables from PO and AR modules.
17.What are the types of triggers in PLSQL. Explain.
18. Primary keys between tables oe_order_headers_all and oe_order_lines_all.
19. Difference bet VARCHAR(30) and CHAR(30).
20. State Bulk collect in PLSQL with example.
21. Collection in PLSQL.
22. Difference between ROWNUM and ROWID.
23. What is System Profile options in apps.
24. How to attach concurrent program to a request group.
* Please comment if you have some different important interview questions.
No comments:
Post a Comment