Oracle Forms - Best Practices and Standards ~ Symrich

Oracle Forms - Best Practices and Standards

1. Oracle Apps standard naming convention has been followed.

2. Form names should be descriptive.

3. Object alignment done.

4. Messages included at proper places.

5. Form design based on standard templates provided by apps.

6. All objects defined as per apps conventions.

7. Standard trigger code modified at required places.

8. Inline comments/Header comments have been added in triggers/program units

9. PL/SQL Exception handled

10. All Cursors properly closed

11. All triggers compiled.

12. If underline package specification is changed, the dependent forms compiled

Checklist at the time of delivery

1. Files( reports , ldts , scripts(unix , sql ) , pll , fmb & fmx ) 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. Installation document prepared ( Md-120 ).

Recent Posts