Lots in R12.2 Migrated with Incorrect Expiration Date (Doc ID 2417081.1)

Last updated on MARCH 17, 2021

Applies to:

Goal

Lots in R12.2 Migrated with Different Expiration Date then the ones in 11i.

SQL query below:

SELECT mp.organization_code,
msib.segment1,
iimb.item_no,
mln.lot_number,
ilm.lot_no,
TO_CHAR (mln.expiration_date, 'dd-MON-yy'),
TO_CHAR (ilm.expire_date, 'dd-MON-yy')
FROM mtl_lot_numbers mln,
mtl_system_items_b msib,
mtl_parameters mp,
ic_lots_mst ilm,
ic_item_mst_b iimb
WHERE msib.organization_id = mln.organization_id
AND mln.organization_id = mp.organization_id
AND mp.organization_id = msib.organization_id
AND ilm.lot_no = mln.lot_number
AND mln.inventory_item_id = msib.inventory_item_id
AND ilm.item_id = iimb.item_id
AND lot_no <> 'DEFAULTLOT'
AND iimb.item_no = msib.segment1
AND TO_CHAR (mln.expiration_date, 'dd-MON-yy') <> TO_CHAR (ilm.expire_date, 'dd-MON-yy')

Need a datafix to correct this expiration date in R12.2.
 

Solution

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