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 flexfiled 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 SCM Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 22.R4_Nov2022_Fusion_SCM_Analytics_Tables.html.
Tables Without WHO Columns
Objects that don't have the WHO columns are the views based on the data warehouse tables. Views based on the data warehouse tables won't have any WHO columns because they aren't tables; instead they are views joining two or more underlying data warehouse tables.
- DW_BUSINESS_UNIT_D
- DW_DEPARTMENT_D
- DW_INV_ORGANIZATION_D
- DW_BUSINESS_UNIT_D_TL
- DW_DEPARTMENT_D_TL
- DW_INV_ORGANIZATION_D_TL
- DW_PERSON_NAME_CURRENT_D