1. Extensibility Guide
  2. Report Extensibility
  3. Oracle Analytics Publisher Extensibility
  4. Global Temporary Tables

Global Temporary Tables

Global Temporary Tables (GTTs) are the Oracle tables, having data type as private; such that data inserted by a session can be accessed by that session only.

The session-specific rows in a GTT can be preserved for the entire session, as AI report tables are created using ON COMMIT PRESERVE ROWS clause.

The report specific package pkg_rep_linelisting, populates the following report GTTs:

  • rep_case_tmp
  • rep_event_tmp
  • rep_prod_dose_tmp
  • rep_evt_assess_tmp
  • rep_case_detail_tmp - The Case Detail GTT is populated with user accessible cases in the generic package after applying user data security.

For more information, see:

Parent topic: Oracle Analytics Publisher Extensibility