My Oracle Support Banner

LOT ORG DATE, EXPIRATION_DATE Is NULL At MTL_TRANSACTION_LOT_NUMBERS And Mtl_LOT_NUMBERS (Doc ID 1558718.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.1.1 version, LOTSERATT

ACTUAL BEHAVIOR
---------------
LOT ORIGINATION DATE, EXPIRATION_DATE is NULL at MTL_TRANSACTION_LOT_NUMBERS and mtl_LOT_NUMBERS


MTL_TRANSACTION_LOT_NUMBERS‘s ORIGINATION_DATE, GRADE_CODE, RETEST_DATE, EXPIRATION_ACTION_CODE, EXPIRATION_ACTION_DATE, ORIGINATION_TYPE is null for some transactions.
mtl_LOT_NUMBERS’s EXPIRATION_DATE, ORIGINATION_DATE, RETEST_DATE, EXPIRATION_ACTION_CODE, EXPIRATION_ACTION_DATE is NULL for some transactions.
it is not against particular item or lot numbers. Same item & lot’s above information is available at some organization while blank at some organization. Attached example.

SELECT count(*) FROM MTL_TRANSACTION_LOT_NUMBERS WHERE ORIGINATION_DATE IS NOT NULL and trunc(transaction_date) > '01-JAN-12'
239766 rows

SELECT count(*) FROM MTL_TRANSACTION_LOT_NUMBERS WHERE ORIGINATION_DATE IS NULL and trunc(transaction_date) > '01-JAN-12'
185362 rows

select count(*) FROM mtl_LOT_NUMBERS WHERE ORIGINATION_DATE IS NOT NULL
312889 rows

select count(*) FROM mtl_LOT_NUMBERS WHERE ORIGINATION_DATE IS NULL
1095 rows

 

Steps :

---------

1.Create new batch for recipe. (Batch # 330)
2.Actions > complete enter wip completion on material exceptions form
3.Enter the new lot per the transaction line and process  (Lot # LL1)

4.Open the transaction and query lot transaction, the lot attributes saying
origination date ,status should be populated.
5. Run the query: select * from mtl_lot_numbers where inventory_item_id =
1010053; Check if dates is populated.

Versions

-------------


/u01/oracle/PROD/apps/apps_st/appl/au/12.0.0/resource/INVMTXFH.pll:
$Header VERT4.pld 120.0 2005/05/07 16:44:21 appldev ship $
$Header VERT4.pld 120.0 2005/05/07 16:44:21 appldev ship $
$Header INVMTXFH.pld 120.51.12010000.102 2012/06/28 04:56:23 ppulloor ship $

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.