Lot Expiration Date Is Different Between OIF and ROI (Doc ID 2639538.1)

Last updated on JUNE 22, 2021

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 is calculated base on lot expiration control(shelf_life_code) and shelf life days filed of Parent Item,
Even though, EXPIRATION_DATE has value on MTL_TRANSACTION_LOTS_INTERFACE.

Example)
When lot expiration control of parent item is "Shelf life days", expiration date was calculated as below.
MTL_LOT_NUMBERS.EXPIRATION_DATE = MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE＋MTL_SYSTEM_ITEMS_B.SHELF_LIFE_DAYS

But when new LOT create using ROI(RCV_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE),
EXPIRATION_DATE does not calculated,
EXPIRATION_DATE setup same value on MTL_TRANSACTION_LOTS_INTERFACE.

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.
   It does not calculate, it is same value EXPIRATION_DATE of MTL_TRANSACTION_LOTS_INTERFACE

Cause

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