OBIA 11g Using Fusion Apps as source for OBIA, there are missing SLA/GL Transaction Sources
Last updated on MARCH 23, 2018
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
OBIA 18.104.22.168.0 Financials Analytics, Procurement and Spend Analytics
Soure: Fusion Apps 22.214.171.124.0 GL, AP, AR, PO, CE, Tax
There are no GL/SLA transaction sources in the OBIA data warehouse (select * from W_XACT_SOURCE_D WHERE SOURCE_TYPE IN ('GL_JOURNAL_SOURCE'); -- now rows returned --) after configuring OBIA and running a full ETL.
The step SDE_FUSION_TRANSACTIONSOURCEDIMENSION_GLJOURNALSOURCES has not been included in the generated load plan although it is defined in the LP "3 SDE Dims TRXSRC_DIM FUSION_1_0"
The following error is seen in the BIACM log:
Logical Schema: DW_BIAPPS11G
PLVC of associated LS: BIA_11
PLVC of LS is not matching PLVC of node. Must be shortcut to versioned adaptor
LS of versioned adaptor :DS_FUSION10_DOWNLOAD_FILES
DSN of associated LS: -1
Yes. Reason: DSN does not match. DSN of node: 503
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms