My Oracle Support Banner

GLDWAVBL -Internal GL Statistics Record Not Found (Doc ID 2997786.1)

Last updated on JANUARY 15, 2024

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

GLDWAVBL - Record not found


User is fetching the records from GLDWAVBL function id. We encounter the error

In the sub tables, gltb_avgbals_ptd & gltb_avgbals_fytd --> Data is not inserting as part of EOD along with the balance updation.
Our team inserted the record manually, however the balances needs to be updated as part of EOD.
The case is tested in UAT, The issue is seen in production.
Attaching all the details for references.

Kindly assist if there is any batch to be configured or any maintenance to be done so that the insert will happen to gltb_avgbals_ptd & gltb_avgbals_fytd as part of EOD.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. User is fetching the records from GLDWAVBL function id. We encounter the error :Branch-000:General Ledger Code-102010104:Currency Code-GHS:Financial Year-FY2023:Period Code-M11
2 In the sub tables, gltb_avgbals_ptd & gltb_avgbals_fytd --> Data is not inserting as part of EOD along with the balance updation.
3. Bank team inserted the record manually, however the balances needs to be updated as part of EOD.
4. The case is tested in UAT, The issue is seen in production.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users GLDWAVBL - Record not found

Changes

  The average balance is not populated post EOD. 

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.