The FDI Data Share (Preview) connector currently provides only partial coverage of Fixed Assets / Subledger Accounting fact tables. Several depreciation-related multi-currency fact tables that are core to FA analytics are not in the eligible-tables list, including but not limited to:
- DW_FA_MC_SLA_TRX_DEPRN_CF (primary ledger)
- DW_FA_MC_SLA_TRX_DEPRN_CF_SEC (secondary ledger)
This idea proposes expanding Data Share to include the full set of FA SLA depreciation fact tables, with both primary and secondary ledger variants, so that customers can consume Fixed Assets data end-to-end through the native, supported connector.
Use Case:
Fixed Assets depreciation is one of the most commonly requested data domains for external analytics, AI workloads, and finance data-lake initiatives. Common scenarios that require these tables include:
- AI / ML workloads on Oracle AI Data Platform (AIDP) modeling depreciation patterns, asset utilization, and impairment risk.
- Multi-ledger reporting where corporate, tax, and statutory ledgers must be reconciled — requiring both primary (_CF) and secondary (_CF_SEC) variants.
- Asset accounting integration with downstream consolidation, treasury, and ESG / sustainability reporting platforms.
- Replacement of legacy ODI / OAC pipelines with the modern Data Share architecture Oracle is positioning as the strategic path.
Proposed Solution:
Add full coverage for FA SLA depreciation fact tables in the FDI Data Share connector, with explicit inclusion of:
- DW_FA_MC_SLA_TRX_DEPRN_CF
- DW_FA_MC_SLA_TRX_DEPRN_CF_SEC
...and any related FA SLA facts that complete the depreciation reporting model (book/period, source-line, retirement, adjustment) where customers currently rely on workarounds.
More broadly, publish a roadmap or documented list of which DW_* warehouse tables are in scope for Data Share, so customers can plan AIDP / data-lake architectures without trial-and-error discovery of gaps.
Business Value:
- Enables Fixed Assets analytics use cases on AIDP, data lakes, and partner platforms via the supported Data Share path — the experience Oracle is positioning customers toward.
- Eliminates the per-object view-creation workaround and its patch-time maintenance overhead.
- Unlocks dual-ledger / multi-GAAP analytics through the secondary-ledger variant, which is impossible to address through Data Share today.
- Provides architectural certainty: a published in-scope table list lets customers confidently design AIDP / lakehouse consumption layers without discovering gaps mid-implementation.
Reference:
Oracle SR 4-0002894483 and SR 4-0002894335— Oracle Support has confirmed these tables are not currently in scope for the Data Share connector and recommended raising this Idea Lab for inclusion.
