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 and later
Information in this document applies to any platform.


OBIA 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 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

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