My Oracle Support Banner

E1: 42: Extended Field Warning When Copying a Record in Sales Order Detail (P4210) (Doc ID 2836298.1)

Last updated on JANUARY 27, 2022

Applies to:

JD Edwards EnterpriseOne Sales Order Entry - Version 9.2 and later
JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When copying a Sales Order and using header Form Extensions (V4210B - Header) where the extended fields are populated, the system will display the following error:

EXTENDED FIELD WARNING
Extended fields will not be saved as the primary keys are not available in Add mode. Try the application/form in Update mode.

The warning does not occur when adding or updating a record.

Steps
1. Add a Sales Order (P4210) where the detail is added first (form W4210A).
2. Click on the Form Extension icon.
3. In Form Extension Manager, make sure the Business View is V4210B - Header and Configuration has Add Mode selected.
4. Add fields User Reserved Reference (URRF) and User Reserved Number (URAB) to the header section of the form and save the changes.
5. Add a Sales Order Detail record where the URRF and ARAB fields are populated; notice the system accepts the order without warning.
6. Re-inquire on the Sales Order and verify that the system saved with the extended fields populated.
7. In Customer Service Inquiry (W4210E), find the Sales Order.
8. Select on the row and click on the copy button; note that when the system calls Sales Order Detail Revisions, all copied from information displays including the extended fields.
9. Before saving, make a change to either of the extended fields.
10. Click on the OK button and notice that the system displays the following message:

EXTENDED FIELD WARNING
Extended fields will not be saved as the primary keys are not available in Add mode. Try the application/form in Update mode.

10. Click OK to finish saving the order.
11. Re-inquire on the new order; notice that the system did keep the update to the changed value in the extended field.

Changes

 

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
Changes
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.