Enable Disable Non-Primary customer relationship TXN Error (Doc ID 3034977.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Enable Disable Non-Primary customer relationship TXN Error

End user is trying to remove non primary owner from the account by posting the following transaction but is getting an error message.

TXN: ACC_NON_PRIM_STA_MAINT DISABLE/ENABLE NON-PRIMARY CUSTOMER RELATIONSHIP Error Message: Error in: tnmacc_en_100_01.lock_table

EXPECTED BEHAVIOR
-----------------------
System should not throw the Error Message: Error in: tnmacc_en_100_01.lock_table while posting TXN: ACC_NON_PRIM_STA_MAINT DISABLE/ENABLE NON-PRIMARY CUSTOMER RELATIONSHIP transaction.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open UI and go to Setup > Transaction Codes > ACCOUNT NON-MONETARY TXN.
2. Select DISABLE/ENABLE NON-PRIMARY CUSTOMER RELATIONSHIP transaction from the list.
3. Create an account with multiple customers.
4. Post DISABLE/ENABLE NON-PRIMARY CUSTOMER RELATIONSHIP transaction to disable any non-prim customer from the account.
5. Verify system posting transaction successfully without any error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot post TXN: ACC_NON_PRIM_STA_MAINT DISABLE/ENABLE NON-PRIMARY CUSTOMER RELATIONSHIP transaction successfully.

Cause

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