Paging Issue At SA Financial History (Doc ID 2706631.1)

Last updated on SEPTEMBER 25, 2022

Applies to:

Symptoms

On : 2.7.0.3.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
Records should not repeat when Arrear date, Accounting date or GL Extract date of record 25/50/75/100 and so on is same.

STEPS
-----------------------
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.
SELECT
  SA.SA_ID,COUNT(SA.SA_ID)
  
  FROM
  CI_FT FT,
  CI_SA SA
  
WHERE
  FT.SA_ID=SA.SA_ID
  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.

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.