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 18.104.22.168.1 and later
Information in this document applies to any platform.
OBIA 22.214.171.124.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
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 126.96.36.199 it is different and it is not hard coding company '00000'
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