Unable To Deliver Transaction as No LOV For Lot Number FRM-41830 List of Values contains no entries Missing RLS / Generate Button is Greyed Out (Doc ID 1299536.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Inventory Management - Version 11.5.1 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVTXERT.FMB - Enter Receiving Transactions
Form:INVTTELT.FMB - Enter Lot Serial

Symptoms

Find it is unable to Deliver specific Internal Requisition or Inter Org Transfer as there is no List Of Value available for Lot Number.

When selecting Lot Number on Lot entry form the following error message appears

FRM-41830: List of Values contains no entries.


Expected Behavior
Expect LOV to show valid lot number

Steps
The issue can be reproduced at will with the following steps:
. Navigate to Receipts or Receiving Transactions form
. Search for Internal Requisition
. Record with Inventory destination is available to be delivered
. After clicking on Lot - Serial Button
Lot Entry form
for Lot number field does not show any value
Also Generate Lot does not work
(or button is grayed out or when clicking the generate lot, getting "Record must be entered or cleared" message)
. If saving the transaction without entering lot there is a normal error message
APP-PO-14806: Lot number quantities do not match the transaction quantity )

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms