My Oracle Support Banner

E1: 76B: F76421 Record Deleted When User Clicks Cancel Button At Time Of Entering 2nd Line (Doc ID 2448552.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When user is attempting to change the sales order by adding a line, at the moment P4210BR W4210BRI form is called and the additional line is displayed in the grid, user cancels it. The header record gets deleted. However there are detail records in the F76422 as well as the other detail lines in F4211. After that happens, if the user hits find no records are displayed and the user is forced to cancel before they click OK. Consequently, the F76421 record gets deleted on the cancel button. This is a header record to the detail table F76422.

Expected Behavior
---------------------------------
This should not delete the header if there are detail records in F76422/F4211.

Business Impact

----------------------------------

It is necessary to manually re-create the F7642 records.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. P4210/P4210BR - Create a sales order and check that F76421 and F76422 data are correctly populated.
2. P4210 - Inquire the sales order just created and in the grid details add a line. Click Ok
3. P4210BR (header) - Click OK
4. P4210BR (Details) - When form P4210BR W4210BRI is called the additional sales order additional information line is displayed in the grid
5. At this moment, if the user cancels at this moment, the header record gets deleted. However there are detail records in the F76422 table for BR Loc. as well as the other lines in F4211 table.
6. If the user clicks find button, no records are displayed and the user is forced to cancel before they click OK.

Cause

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
Symptoms
Cause
Solution
References


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