Friday, November 13, 2009

Oracle apps Reports 6i FAQ

1. What are the various types of reports?
2. What is the difference between Master - Detail Report and report created by breaks?
3. What are Anchors?
4. What are the various types of anchors in Reports?
5. What are the various report triggers? What is their order of firing?
6. What are Placeholder Columns?
7. What are the various Module Types in Reports?
8. What are Physical and Logical pages in Reports?
9. What are the various page layout sections in Oracle Reports?
10. What are various types of parameters?
10. How do you reference parameters and columns in reports?
12. What are Bind Referencing and Lexical Referencing?
13. Can you create a group without any break columns?
14. Types of Matrix report?
15. In Reports, how can you print one record per page in the output?
16. How do you print a Report 2.5 report in character mode?
17. What are widow lines?
18. What are widow records?
19. What is 'page protect' property for objects?
20. What is the 'Print Condition Type' property?
21. What are the various values of the 'Print Condition Type' property in Reports?
22. What is the 'Print Condition Object' property?
23. What are the various values of the 'Print Condition Object' property in Reports?
24. What is the horizontal of vertical sizing property of objects?
25. What are the various values of the horizontal of vertical sizing property?
26. How do you display a message in reports?
27. What are the various values of 'Print Panel Order' property of report?
28. What is the 'Print Direction' Property of Repeating frames?
29. What are the various values of the 'Print Direction' Property of Repeating frames?
30. What is the 'Keep with Anchoring Object' object property?
31. What is 'Page Break Before' object property?
32. What is 'Page Break After' object property?
33. What is the 'Break Order' property of columns?
34. What are the various types of links?
35. Name some of the procedures in the SRW package?
36. What are the various report layout regions?
37. What is more efficient: Maximum rows or Group Filter?

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...