Event Triggers

The following are the steps to view event triggers:

  1. In Oracle Analytics Publisher report, there are three different types of event trigger: Before Data, After Data and Schedule.
  2. In the Event Triggers, for the Generic Line Listing Report you will create Before Data trigger, which will set the user context before populating all the reporting GTTs. The function called in the Event Trigger as shown in the above picture is:

    pkg_rep_linelisting.f_pop_report_data(:pi_enterprise_id,:xdo_user_name,:pi_id,:pi_querytype)

  3. In case, you want to delete some customized tables after data is generated, you can create Event Trigger of type After Data and call package with delete statements.

    See Also:

    Report Designer's Guide for Oracle Analytics Publisher