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.

Symptoms

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.

ERROR
FRM-40831 FRM-40735

STEPS
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

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

Changes

 

Cause

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 hundreds of Community platforms