Mtl_lot_numbers.d_attribute1 Date Format Is Changing
(Doc ID 2758399.1)
Last updated on JULY 18, 2021
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INV: mtl_lot_numbers.d_attribute1 date format is changing
We store date in d_attribute1 of mtl_lot_numbers in lot screen dff. When we copy data from existing lot and we use it for translate or split. But The mfg date in dff is coming as reverse . If original had 15-sep-20 after interface was run for lot split/ translate its coming as 20-sep-15
Expect that the data attribute value is not getting reversed, but should remain the same.
a) Create a record with a Date dff in MTL_lot_numbers table
b) Create another record in the mtl_transaction_lots_interface, having the d_attribute1 with the correct date. [20-Dec-2015]
c) Once the Launch Interface Manager is run, find that the record in the MTLI is removed and inserted into MTL_lot_numbers having the
d_attribute1 as [15-Dec-0020]. This is incorrect. The date should not be reversed.
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