Oracle Reports - Best Practices and Standards ~ Symrich

Oracle Reports - Best Practices and Standards

1. Oracle Apps standard naming convention has been followed.

2. Report names should be descriptive.

3. The entire report format throughout the application should be consistent.

4. The text font size on the report detail section should not be less than 8 pnts.

5. The header and footer should be the same font.

6. Use one font in the body of the report.

7. The title should describe the scope of the data.

8. The data sorting and grouping should be considered.

9. The columns of data should be arranged in logical order.

10. All columns of numbers should be right justified.

11. If a legend is used it should be understandable.

12. For data that spans multiple pages, section breaks should be set to keep data and titles together when possible.

13. Inline comments/Header comments have been added in triggers/code.

14. PL/SQL Exception handled.

15. All Cursors properly closed.

16. The overall report should be readable.

Checklist at the time of delivery

1. Files (reports, ldts, scripts (unix, sql) migrated at proper directory location

2. Underline packages are valid.

3. Trigger coding as per coding conventions.

4. Unit testing done.

5. All the test cases tested by developer and peer reviewer.

6. Test case documentation.

7. Installation document prepared( Md-120 ).

Recent Posts