My Oracle Support Banner

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 FEBRUARY 27, 2020

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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