My Oracle Support Banner

Cannot post ACC_NON_PRIM_STA_MAINT non monetary transaction to disable customer who has secondary relationship : error exact fetch returns multiple rows (Doc ID 2660235.1)

Last updated on APRIL 17, 2020

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------

Users cannot post ACC_NON_PRIM_STA_MAINT non monetary transaction to disable customer who has secondary relationship in the account. System throws an error exact fetch returns multiple rows
 
EXPECTED BEHAVIOR
-----------------------
System should allow posting "ACC_NON_PRIM_STA_MAINT" monetary transaction to disable the customer

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select an account with Prim and Secondary relationship.
2. Post non-monetary transaction (DISABLE/ENABLE NON PRIMARY CUSTOMER RELATIONSHIP) to disable the customer who has secondary relationship.
3. Next day add a new customer with the secondary relationship to this account  by posting a non-monetary transaction
4. Now try to disable this new secondary customer by posting the "DISABLE/ENABLE NON PRIMARY CUSTOMER RELATIONSHIP"
5. System throws an error exact fetch returns multiple rows.
 
BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users not able to disable customer in the system

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.