INVMATWB: Supplier Lot Size > 30 Gives FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

(Doc ID 2374215.1)

Last updated on MARCH 15, 2018

Applies to:

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


12.2.4 - Inventory Management

Querying onhand for items in the Material Workbench form (INVMATWB) give the following error for long supplier lot numbers:

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-6502
FRM-40831 truncation occurred value too long for VENDOR_LOT_NUMBER

1. Inventory > Onhand > Material Workbench
2. Query an item known to have a long supplier lot number
3. See the error when the query returns and data is displayed in the form




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