GLDVWBAL Generated Wrong (Doc ID 2934675.1)

Last updated on MARCH 16, 2023

Applies to:

Symptoms

On : 14.5.5.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
GLDVWBAL generated wrong

EXPECTED BEHAVIOR
-----------------------
System should generate GLDVWBAL correctly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open GLDVWBAL
2. Fill parameter as ss Capture.PNG
3. Click ok
4. Result is in Capture1.PNG
5. Close GLDVWBAL and open GLDVWBAL
6. Fill parameter as ss Capture.PNG (the same as step 2)
7. Click ok
8. Result is in Capture2.PNG

Capture1.PNG and Capture2.PNG look different even if we input same parameter. We've attached debug log for both time.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, GLDVWBAL generated wrongly.

Changes

 Fix provided to ensure that the "query source" option has been disabled for the data source used in GLDVWAVG function ID so as to ensure that the
relevant information is displayed on querying the GL details using General Ledger Average Balance function ID(GLDVWBAL).

Cause

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