OBIA 11g Using Fusion Apps as source for OBIA, there are missing SLA/GL Transaction Sources (Doc ID 1966806.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.8.0 Financials Analytics, Procurement and Spend Analytics
Soure: Fusion Apps 11.1.8.0.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:

'SDE_FUSION_TRANSACTIONSOURCEDIMENSION_GLJOURNALSOURCES'?
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

  

Cause

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