User Is Able To Add Same Existing Customer Multiple Times On Same Account (Doc ID 2713108.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

Symptoms

On : 14.8.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
User is able to add same existing customer multiple times on same account

User have setup SYP_AUTO_GEN_CUS_NBR = N. Now, User is able to post "ADD EXISTING CUSTOMER" on the same account multiple times by providing same customer number.
As a result, user can see multiple records in cus_acc_relations table with exact same combination of CAR_CUS_ID, CAR_AAD_ID, CAR_ENABLED_IND.


EXPECTED BEHAVIOR
-----------------------
System should allow same customer adding multiple times with different relation type too.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set the value of SYP_AUTO_GEN_CUS_NBR = N
2. Pick up an account in customer service.
3. Check for any existing customer number and add existing customer by posting a add customer transaction on this account
4.Again, post the same transaction with same customer number but (diff relation type) and verify.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have one existing customer addition in the account.

Cause

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