My Oracle Support Banner

OBIA 11g Interface SDE_JDE_APTransactionFact_Full Is Not Returning Data (Doc ID 1927482.1)

Last updated on DECEMBER 23, 2019

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.1 Fresh installation ,Full load. Source system JDE 9.0 ,DB 12c

Interface SDE_JDE_APTransactionFact_Full is not returning Data

Table W_AP_XACT_FS is not populated. All the source tables have data.

After debugging, you discovered that:-

In interface SDE_JDE_APTransactionFact_Full.W_AP_XACT_FS_Base, in the Join condition

F0012_DFLT.KGCO = '00000' AND F0012_DFLT.KGITEM = 'PC'|| F0411.RPGL

This condition is not returning any data as there is no combination between KGCO 00000 and KGITEM and this condition is left outer join, so all the fields coming from F0012_DFLT will be null

and if you look at the join between F0012_DFLT and F0901_DFLT ,it is inner join with the following condition

F0012_DFLT.KGSUB=F0901_DFLT.GMSUB
AND F0012_DFLT.KGOBJ=F0901_DFLT.GMOBJ
AND F0012_DFLT.KGMCU=F0901_DFLT.GMMCU


this condition will never evaluate to true as F0012_DFLT is always null as an outcome of the Left outer join with table F0411 .

Running the SQL directly does not return any data

Looking at the sql generated from 7.9.6.3 it is different and it is not hard coding company '00000'
 

Cause

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
Symptoms
Cause
Solution
References


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