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

Last updated on AUGUST 10, 2023

Applies to:

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

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