Learning Oracle Integration Cloud Services SOA | BPM

There are three types of columns in Oracle report. Placeholder Column : Placeholder column is used to store a value for a variable. Formula Column :  Used For doing mathematical calculations and returning one value Summary Column : The summary columns perform aggregate functions such as SUM, COUNT, MAX, MIN, AVG, and the like.

Bind variables are used in oracle reports  for replacing the single parameter in the SELECT statement. Example SELECT * FROM employee e WHERE e.emp_no = :empno;

Lexical Parameter is used to replace the where clause at run time. Lexical Parameter identified by & sign and are used to execute query dynamically. Example Select * from employee &where

When confine mode is on, the object cannot be moved outside its parent in the layout.   

When flex mode is ON, reports automatically resizes the parent when the child is resized.

After parameter Trigger : It will fire after the parameter form is displayed and here we can do validation on parameter values. Before Report Trigger : It will fire before the report is executed and after the query is parsed and date is fetched. 

We can set the message level using the system variable SYSTEM.MESSAGE_LEVEL or trap errors using the ON-ERROR or ON-MESSAGE  in Form level triggers. MESSAGE_LEVEL: 0     : Default value. All types of messages from the other levels of severity. 5     : Reaffirms an obvious condition. 10   : Indicates that the operator has made a procedural mistake.