interview oracle apps tech

1. Brief about yourself and self rating on RICE components

2. What are the user defined data types in PL/SQL?

3. Have you ever used bulk collect and give the scenario where exactly you used?

4. What is ref-cursor?

5. What are the mandatory parameters required to register a pl/sql procedure with EBS suite.

6. What are the report triggers?

7. What is the signification of p_conc_request_id?

8. How do you register an xml publisher report with EBS?

9. How do you capture the flex-field values in a report?

10. Have you ever worked on workflow?

11. How do you make your sql query dynamic in a oracle report?

12. What is your approach when a report is running for a long time?

1. What are the modules you are familiar with?

2. Explain about drop shipment in OM?

3. In which column of oe_order_lines_all table holds the drop shipment information

4. Have you ever worked on service contracts?

5. What are the major differences between 11i and R12?

6. Explain about SLA?

7. List out the TCA architecture tables and explain the relation between those tables?

8. Which table holds the value sets values information?

9. What is the main difference between form personalization and form customization?

10. Can an end user do a change in item level trigger code using form personalization?

11. What we can do using form personalization?

12. How can we do a form customization and registration with Oracle EBS?

13. What is the major difference between a procedure and function?

14. What is a save point?

15. What is pragma autonomous transaction?

16. What are the mandatory parameters in sales order conversion?

17. Table joins between inventory and order management?

18. List out the warehouse management tables?

19. Difference between pick release and pick confirm?20. What are the interface tables in OM?

21. What is the signification of _ALL table?

22. What are database triggers?

23. What are the Oracle report triggers?

24. Can we use user exits in after parameter form trigger?

25. After which report trigger, sql query parsing happens?

26. What is user-defined exception?

27. Write syntax of user-defined exception on board?

28. Can we write a pl/sql block as below?

DeclareVar declaration

Begin

Sql statements

Exception

Declare

Var Declaration

Begin

Sql Statements

End

End

29. How do you handle performance tuning?

30. A Sql query is inserting 30 thousand records into a table. After 20 thousand records, the insertion process became very slow. How can you handle?

31. What is Index?

32. Can you create 15 indexes on a single table?

33. When unnecessary indexes are created, how does it impact on performance?

34. What is soft reservation and hard reservation of item?