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 30, 2017

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.

Symptoms

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: http://www.oracle.com/pls/topic/lookup?ctx=mos_en&id=MOSHP983

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms