My Oracle Support Banner

E1: 04: Case Study - P0030G Updating Records Incorrectly by Recognizing Form Mode as Update Mode in Clicking Add Button (Doc ID 2121759.1)

Last updated on MAY 13, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.0 and later
Information in this document applies to any platform.


When adding a new bank account through P0030G (G/L Bank Accounts), Bank Account and Transit Number are being pre-populated with values from an unrelated bank account record in F0030. If you do not change those numbers, the original bank account record is updated with the new account description when the new account is added.

Note that this type of issue (where SV Form_Mode is UPDATE_MODE in adding a new record) can be occurred in your running Address Book Master (P01012) or Item Master (P4101) which has primary key value with '0'. However this document shall not explain why '0' value is stored because there are too many possible scenario for this. So application listed here is a case study only.

Caution: This document may contain information, software, products or services which are not supported by Oracle Support Services and are being provided "as is" without warranty. Before using SQL, be certain to backup any data in the table to prevent data loss or corruption. Please refer to the following site for My Oracle Support Terms of Use:



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

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