My Oracle Support Banner

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

Last updated on DECEMBER 18, 2019

Applies to:

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


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





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.