2 Tables
Overview
This section provides information about tables within Oracle Fusion CX Analytics and their columns, primary keys denoted as key columns, data types, and the referred table and column names.
Note:
Tables ending with the suffix_EN and those listed in Tables Without WHO Columns are for
Oracle Internal use only. You must not use the UPDATE
W$_INSERT_DT and W$_UPDATE_DT columns for reporting purposes. Use these columns with
caution for downstream custom ETL. Fusion Data Intelligence truncates and reloads tables as required, effectively removing the historical record
of these columns.
Download this ZIP file that contains available tables that apply to the current version of Oracle Fusion CX Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 25R2_Fusion_CX_Analytics_Tables.html.
Table Types
The suffixes in table names designate the table type.
- CA, A: Aggregate
- CF, F: Fact
- CF_DN: Denormalized Fact
- CG, G: General
- D: Dimension
- DH: Dimension Hierarchy
- EF: Extended Fact
- EN: Oracle internal use only
- H: Helper
- P: Prediction
- TL: Translation