Lot Expiration Date Was Calculate by SYSDATE + Shelf Life Day on Item Master via ROI, Even Though Transact Date Is Not SYSDATE. (Doc ID 2643296.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

Actual Behavior
When new LOT create using OIF(Open Interface) and ROI(Receiving Open Interface),
EXPIRATION_DATE result is different on MTL_LOT_NUMBERS.

When new LOT create using OIF(MTL_TRANSACTIONS_INTERFACE、MTL_TRANSACTION_LOTS_INTERFACE),
EXPIRATION_DATE was calculate by Transaction Date of MTI + Shelf Life Day on item master.

But when new LOT create using ROI(RCV_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE),
EXPIRATION_DATE was calculate by SYSDATE + Shelf Life Day on item master.

Expected Behavior
EXPIRATION_DATE calculate logic should be same between OIF and ROI.

Steps to Reproduce

1. Create LOT for WIP Completion.
   Insert MTL_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE for new LOT for WIP Completion.
2. To check EXPIRATION_DATE value on MTL_LOT_NUMBERS table.
   It was calculated base on MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE＋MTL_SYSTEM_ITEMS_B.SHELF_LIFE_DAYS
3. Create LOT for Receipt, PO
   Insert RCV_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE for new LOT for Receipt, PO
4. To check EXPIRATION_DATE value on MTL_LOT_NUMBERS table.
   EXPIRATION_DATE does not calculate base on RCV_TRANSACTIONS_INTERFACE.TRANSACTION_DATE,
   it was was calculate by SYSDATE + Shelf Life Day on item master.

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.