My Oracle Support Banner

E1: 09: P0902W Displays Incorrect Amount For Currency Code "***" (Doc ID 2814129.1)

Last updated on OCTOBER 18, 2021

Applies to:

JD Edwards EnterpriseOne General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In the Account Balance by Currency Code(P0902W) when there are multiple currency records including CRCD = blank in the Account Balance Table (F0902) ,the P0902W incorrectly displays the Cumulative Amount and Cumulative CA Amount for the currency "***". The amount is not total amount of records with CRCD = blank in F0902, but total of all currencies account balances.

Steps:

  1. In F0902, there are multiple currency records which has CRCD = USD, CAD,EUR and blank in AA ledger.  For the USD, the net posting amount is 100, and CAD = 200 EUR = 80 and blank = 120.
  2. Open Account Balance By Currency Code (P0902W) and query by the account id
  3. See the currency-specific account balances are correctly displayed which is USD =100, CAD =200, EUR = 80. But the cumulative amount for the currency "***" is displayed with 300 where should be 120(CRCD = blank).

 

Changes

 

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
Changes
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.