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