Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Process Points

A Process Point defines when, during the page rendering or page processing, the process will be considered for execution. 

Application Level Process Points

On New Instance - After Authentication:  This is an application level process and should be created as such.  When creating an application level process in the shared components section, it is called On New Session - After Authentication.  This can be confusing as it is for an application level computation.  A technique that can be used for this type of process if the user logging in is listed as a developer is to set an application level item to a TRUE value.  Then the application level item in the Conditions of other page level items can be used for debugging information.

  • Page Rendering Processes

  • The following is a listing of page rendering processes:

  • On New Instance. After Authentication

  • On Load – Before Header

  • On Load – After Header

  • On Load – Before Regions

  • On Load – After Regions

  • On Load – Before Footer

  • On Load – After Footer

  • On Submit – Before Computations and Validations

  • On Submit – After Computations and Validations

The On New Instance and On Load will direct the process to be considered for execution during page rendering.  These display points are commonly used for populating the page items of an application page. 

When a Form page is created using the wizard, it will create an After Header process used to fetch the row from the database and populate the page items.  This is the process point to choose when writing custom queries to populate page items.  The Before Header and Before Regions process point could also be used for populating page items during page rendering.

The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty  

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.