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

Last updated on MARCH 08, 2017

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

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