My Oracle Support Banner

E1: 42: How to Cancel or Delete Ship Confirmed Sales Order Detail Lines? (Doc ID 2864631.1)

Last updated on NOVEMBER 01, 2023

Applies to:

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


Customer has a Sales Order with multiple detail lines that cannot be cancelled or deleted. Customer tried manually updating the order status for the detail lines, but it is triggering error message ID: 4470, "Delete Cancel Action Invalid: The quantity for this order has been relieved from the on-hand inventory bucket via Ship Confirmation (P4205) and cannot be deleted or cancelled".
The users already created a new sales order and has entered an Inventory Adjustment to manually update/return the inventory quantity.

Customer reviewed document ID: 2556661.1 which references a resolution for orders in this status, however there are some additional questions:
1. Can one just script out the cancellation of F4211 - SO Detail records records (change the status to 980/999) for the order detail lines lines instead of deleting as per the document?
2. Should there be any updated to the SO header table F4201? Are there any other tables to check, i.e. F42119 - SO Detail History, F42199 - SO Detail Ledger ?
3. Would it be recommended to delete all the F4111 - Item Ledger records for the order number/order type? There are 184 records in the F4111 - Cardex compared to 92 records in the F4211 - SO Detail table.


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.