E1: 01: Duplicate Key Error when Creating Multiple Bank Account for Record Type X in P0030A (Bank Accounts by Address) (Doc ID 2982219.1)

Last updated on JULY 23, 2024

Applies to:

Symptoms

Duplicate key error in e1root logs for F0401M (Multiple Vendor Bank Account Status) when creating multiple bank account in P0030A ((Bank Accounts by Address)) for Record Type X.
If an error in F0401M, you should receive a RED error message in the JDE form, and the entry in table F0030 (Bank Transit Master) should not have been saved.

STEPS TO REPRODUCE
==================
1. Go to P01012 and search any supplier without bank account info. Select the supplier and then click on Row/BankAccount
2. Click on form Multiple Accounts (W0030AC)
3. Fill all the fields as needed and use the Record type "X". Clik on save button.
4. Enquiry F0030 by supplier (an8) => one record
5. Enquiry F0401M by AN8 => one record
6. Repeat step 3 with different bank account info but using the same record type "X"
7. Enquiry F0030 by supplier (AN8) => 2 records
8. Enquiry F0401M by AN8 => only one record, but in F0030 you can see 2. In the logs you can see [DUPLICATE_KEY_ERROR] Duplicate key error obtained for table F0401M.

Cause

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