My Oracle Support Banner

Inconsistent Supplier Lot Number Size Between Forms: Expect 150 Characters But See 30 Limit (Doc ID 2332670.1)

Last updated on NOVEMBER 27, 2017

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.


Inconsistent supplier lot number size between forms  

System accepts a supplier lot number up to 150 characters. But if a long supplier lot number is used, some forms give an error while querying:
- material transaction search & on-hand (material workbench) search: We expect these forms to correctly handle supplier lot number up to 150 characters.

FRM-40831 FRM-40735

1.  On Receiving form > Supplier lot number accepts a long string.  > MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER is varchar2(150)
2.  On View material transactions > Query by supplier lot number > See error FRM-40831 truncation occurred value too long for VENDOR_LOT_NUMBER
3. On  Material Workbench > On-hand (material workbench) search > Query by Supplier lot > form accepts value > But error on search > FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

Due to this issue, users cannot query by supplier lot number . This is required for product recalls etc.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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