Mtl_lot_numbers.d_attribute1 Date Format Is Changing (Doc ID 2758399.1)

Last updated on DECEMBER 01, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
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

EXPECTED BEHAVIOR
Expect that the data attribute value is not getting reversed, but should remain the same.

STEPS
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.

Cause

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