TECHNOLOGY : ORACLE REPORTS

CONCEPTS

1.        Data Model

• System Parameters
• User Parameters
• Queries
• Groups
• Columns
• Summary Column
• Place Holder Column
• Data Links
• Formula Column

2.       Web Source

3.       Paper Layout

4.      Paper Parameter Form

5.     Classification of Triggers

           

           a.  Report Triggers

•         Before Parameter Form
•          After Parameter Form
•           Before Report
•          Between Pages
•          After Report

    b. Data Triggers

•           Group Filter
•           Ref Cursor Query
•          Formula
•          Validation Trigger

 c. Layout Trigger

• Format Trigger
• Action Trigger

6.      Program Units

7.      Attached Libraries

8.      SRW.USER_EXIT

9.      Data Link

10.  P_CONC_REQUEST_ID

OPERATIONS

• How to Register the Custom Report (Purchase Requisition Status Report)

• b