Inventory Management - EBS (MOSC)

MOSC Banner

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center