OBIA 11g Using Fusion Apps as source for OBIA, there are missing SLA/GL Transaction Sources
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
OBIA 126.96.36.199.0 Financials Analytics, Procurement and Spend Analytics
Soure: Fusion Apps 188.8.131.52.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
Million Knowledge Articles and hundreds of Community platforms