2 Tables
Overview
This section provides details of tables such as key columns, data types, and table descriptions. Use the "Referred Table" and "Referred Column" information to decide on the join condition between Fact and Dimension tables.
Note:
Tables ending with the suffix_EN
and those listed in Tables Without WHO Columns are for
Oracle Internal use only. In addition, tables storing descriptive flexfield data (DFF
tables) aren't included in the documentation
Download this ZIP file that contains available tables that apply to the current version of Oracle Fusion ERP Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 24R1_Fusion_ERP_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
Tables Without WHO Columns
All tables have two system date columns which can be used to get the last refresh dates.
- W$_INSERT_DT - the timestamp when that particular record was inserted into that table.
- W$_UPDATE_DT - the timestamp when that particular row was updated in that table.
- DW_LEGAL_EMPLOYER_D_TL
- DW_INV_ORGANIZATION_D_TL
- DW_DEPARTMENT_D_TL
- DW_BUSINESS_UNIT_D_TL
- DW_OFA_SEGMENT_D_TL
- DW_FISCAL_QUARTER_ACCT_D
- DW_FISCAL_YEAR_BC_D
- DW_FISCAL_YEAR_ACCT_D
- DW_FISCAL_DAY_BC_D
- DW_FISCAL_PERIOD_BC_D
- DW_FISCAL_DAY_D_NO_ADJUST
- DW_FISCAL_QUARTER_BC_D
- DW_FISCAL_PERIOD_ACCT_D
- DW_FISCAL_DAY_ACCT_D
- DW_DEPARTMENT_D
- DW_BUSINESS_UNIT_D
- DW_LEGAL_EMPLOYER_D
- DW_INV_ORGANIZATION_D
- DW_JOB_D_CURRENT_TL
- DW_PERSON_LEGISLATION_ALL_CURRENT_D
- DW_JOB_CURRENT_D
- DW_PERSON_NAME_CURRENT_D
- DW_AR_AGING_ACCT_INV_RCPT_CA
- DW_AR_AGING_ACCT_INV_RCPT_CUST_CA
- DW_AP_SLA_AGING_INV_CA
- DW_PROJECT_INVOICE_ALL_CF
- DW_GL_VARIANCES_CA
- DW_AR_ACC_UNACC_SCHEDULES_CF
- DW_AR_ACC_UNACC_REVENUE_CF
- DW_PROJECT_ASSET_LINE_CF
- DW_PROJECT_ASSET_D
- DW_FA_MC_SLA_TRX_DEPRN_CF
- DW_FA_ASSET_FINANCIALS_CF
- DW_FA_SLA_TRANSACTIONS_CF
- DW_FA_DEPRN_PERIODS_D
- DW_FA_ASSET_SOURCE_LINES_D
- DW_FA_BOOKS_D
- DW_FA_RETIREMENTS_D
- DW_FA_BOOK_CONTROLS_D