E1: 44H: Error "H0009 Delete Invalid - Sales record exists Warning" in P44H201 -Lot Master When Attempting to Delete a Lot Master Record for a Lot That Has Been Released For Sale (Doc ID 2950098.1)

Last updated on MAY 19, 2023

Applies to:

Symptoms

Lot Master records for Lots that have been 'Released for Sale' cannot be deleted.

You  have created lots in the lot master (F44H201) and performed the release for sale process which creates a record in the F44H501.  You want to delete this Lot record from the lot master, but because of the existing sales record, you are receiving error 'H0009 Delete Invalid - Sales record exists Warning'.  

What process or program can be used to delete this lot?

The issue can be reproduced at will with the following steps:

1. A Lot is created using Lot Master Revisions P44H201.
2. This Lot is 'Released for Sale' using the P44H201 row exit - Release for Sale. 
3. Attempt to delete this Lot using the Delete Icon in P44H201 - Lot Master and error 'H0009 Delete Invalid - Sales record exists Warning' is generated preventing you from deleting this Lot record.

Changes

Cause

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