My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2022

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

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