My Oracle Support Banner

Issue in ACCT_CURRENCY_NEW column in SDE_JDE_GLBalanceFact_Norm_W_JDE_GL_BALANCE_F_NORM_TMP_SQ_W_GROUP_ACCT_FIN_STMT_D_TMP mapping (Doc ID 2358887.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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

Symptoms

Data source: JDE 9.0

The current mapping for ACCT_CURRENCY_NEW in SDE_JDE_GLBalanceFact_Norm_W_JDE_GL_BALANCE_F_NORM_TMP_SQ_W_GROUP_ACCT_FIN_STMT_D_TMP is

CASE
WHEN SDE_JDE_GL_BAL_LKP_GRP_ACCT.CHECK_NON_CURRENCY = 'Y'
THEN '#DOC_CURR_CODE'
ELSE
 CASE
 WHEN IS_SPACES(SDE_JDE_GL_BAL_LKP_GRP_ACCT.GMCRCD)
 THEN
  CASE
  WHEN SDE_JDE_GL_BAL_LKP_GRP_ACCT.CHECK_NON_CURRENCY = 'Y'
  THEN '#DOC_CURR_CODE'
  ELSE SDE_JDE_GL_BAL_LKP_GRP_ACCT.GBCRCX
  END
 ELSE SDE_JDE_GL_BAL_LKP_GRP_ACCT.GMCRCD
 END
END

This results in GBCRCX (the local currency code from account balance) being put in the account currency code column (ACCT_CURRENCY_NEW).

ACCT_CURRENCY_NEW is then used to calculate BALANCE_ACCT_AMT column in SDE_JDE_GLBalanceFact.W_GL_BALANCE_FS.

Since the value in ACCT_CURRENCY_NEW is mostly the local currency code, the converted value in BALANCE_ACCT_AMT is also mostly same as BALANCE_LOC_AMT (Balance amount in local currency).

The correct mapping for ACCT_CURRENCY_NEW should be

IIF(
  IS_SPACES(SDE_JDE_GL_BAL_LKP_GRP_ACCT.GBCRCD),
  SDE_JDE_GL_BAL_LKP_GRP_ACCT.GBCRCX,
  SDE_JDE_GL_BAL_LKP_GRP_ACCT.GBCRCD)

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.