INVTDILT Incorrect Expiry Date When Using Custom INV_CUST_CALC_EXP_DATE. (Doc ID 1604484.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, LOTSERATT

ACTUAL BEHAVIOR
---------------


We are using the custom package INV_CUST_CALC_EXP_DATE to calculate a specific expiry date for finished goods based on the original manufacture date of the bulk product.

This process works correctly except in one circumstance where we use the lot/serial form to generate the lot and expiry date when we transaction (WIP Completion) in the OPM Batch details form. When we generate the finished goods lot number the expiry date uses the custom calculation (see screen shots uploaded).


However when we examine the expiry date in the lots form (INVTDILT) we see that the date is lost and it has reverted to the standard shelf life calcuation.
 

EXPECTED BEHAVIOR
-----------------------
expect INV_CUST_CALC_EXP_DATE to work even with OPM



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, lot expiry date is not correct

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms