When Entering Quality Inspection Results for a Receving Transaction Collection Plan Seeded Lot Number List of Values Fails With FRM-41830 (Doc ID 2986078.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Symptoms

While attempting to enter Collection Plan results related to a Receiving Inspection transaction, the list of values related to the Lot Number collection element is failing with the following error:

ERROR
-----------------------
FRM-41830: List of Values contains no entries

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

1. (R) Oracle Quality - Create a collection plan with a Plan Type of Receiving Inspection.  In the collection plan, include the seeded Lot Number collection element.
2. (R) Oracle Purchasing - Create and approve a purchase order (PO).
3. (R) Oracle Purchasing - Perform a PO receipt.
4. (R) Oracle Purchasing - Perform a Receiving Transaction for one of the receipts and enter the following fields:
   1. Quantity = 1
   2. Destination Type = Inventory
   3. Select the Lot-Serial button
   4. Enter/Generate the Lot Number
   5. Enter Quantity
   6. Select Done
   7. Select the Quality ribbon button from the menu option
   8. In the Enter Quality Results form, enter the collection elements value required
   9. For the Lot Number field, select the list of values and observe the error

The expectation is that the list of values should contain values for the lot number.

Cause

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