My Oracle Support Banner

OBIA 11g SDE_JDE_APTransactionFact_Full.W_AP_XACT_FS_Base Join Not Considering Leading 0s (Doc ID 1927500.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 perfoming a Full load.

Source system JDE 9.0 DB Oracle 12c

SDE_JDE_APTransactionFact_Full.W_AP_XACT_FS_Base join not considering leading zeros

Interface SDE_JDE_APTransactionFact_Full.W_AP_XACT_FS_Base under folder SDE_JDE_APTransactionFact_Full ,is not taking into consideration leading zeros in column RPPO.

The same issue exists also in "SDE_JDE_APTransactionFact_Full.W_AP_XACT_FS_Initial_Balance"

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.