Paging Issue At SA Financial History
(Doc ID 2706631.1)
Last updated on SEPTEMBER 25, 2022
Applies to:Oracle Utilities Customer Care and Billing - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 2.7]
Information in this document applies to any platform.
FT- Financial Transaction
GL- General Ledger
On : 184.108.40.206.0 version, ENV - Environment
Paging Issue at SA Financial History
Check if record 25 and 24 or record 50 and 49 have same arrear date. Click on Next.
Records will repeat check record 26 and 51 will be same as record 24 and 49 respectively.
Records are being repeated if Arrear date of record 25/50/75/100 and so on is same as above records of 25/50/75/100. Same thing is happening when we search the records by Accounting date or GL Extract date.
Records should not repeat when Arrear date, Accounting date or GL Extract date of record 25/50/75/100 and so on is same.
The issue can be reproduced at will with the following steps:
1. open an account. (Conditions:- SA Financial History should have more than 25 records and record 25 and 24 should have same arrear date)
Use below Query to get SA where FT's are more than 25.
AND FT.FREEZE_DTTM IS NOT NULL
GROUP BY SA_ID HAVING COUNT(SA_ID)>25;
2. Go to SA Financial History from Account's Context Menu.
3. Search records by Arrear date and Select SA.
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