Lots in R12.2 Migrated with Incorrect Expiration Date
(Doc ID 2417081.1)
Last updated on OCTOBER 14, 2022
Applies to:
Oracle Process Manufacturing Systems - Version 11.5.10 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |