Error in rcv_transactions_interface table when item is set to User-defined expiration date
Hi all,
we are trying to receive some items from rcv_transactions_interface and we're getting this error:
INTERFACE_TRANSACTION_ID - ORA-01403: no data found ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control | INTERFACE_TRANSACTION_ID - WMSINB-22494:Lot/Serial validation failed. Please check log for details.
The items that are stuck with the error are the ones with lot shelf days control. The ones with no control worked fine.
This is how the code is written to pass the date:
LOG(' Create Brazilian lot');
l_rLotInt.lot_number := c.LOT_NUMBER;