My Oracle Support Banner

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 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.6.0.1.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
Zone- C1_ACCRULDLT
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.

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