Multiple Records For The Same Accrual ID Is Displayed On Accrual UI
(Doc ID 2439643.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Financial Services Revenue Management and Billing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.0 version, BNK - Banking Control Central
Multiple records for the same accrual ID is displayed on Accrual UI
When an accrual is created for an account, there is a single entry in the database but in the Accrual UI, there are multiple records being displayed. On checking the query used in the zone, found out that the query includes account person table but there is no check for main person.
For example- If there are three persons linked to the account, three records are displayed on the UI
Condition to be added in the query - CIAP.ACCT_REL_TYPE_CD='MAIN'
STEPS TO REPLICATE
1) Create a person in RMB
2) Create an account with the person created above as the main person
3) Associate two or more persons to the account with relationship type other than main person
4) Create trial bill
5) Run C1_ACCAL batch to create accruals
6) Check the UI for the account id for which the accrual is created. Multiple records are displayed based on number of persons linked to the account.
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