My Oracle Support Banner

FRM-40654 or FRM-40735 / ORA-20001 Errors In The Master Item Or Organization Item Form INVIDITM.fmb (Doc ID 1933028.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Item Master - Version and later
Oracle Inventory Management - Version and later
Information in this document applies to any platform.
This document includes all versions or 11i and R12


How to Diagnose and Resolve FRM-40735 and FRM-40654 errors in the Master Item and Organization Item form INVIDITM.fmb.

Normally these errors are caused by data issues in the following tables:


Error Descriptions:

FRM-40735: ON-LOCK trigger raised unhandled exception ORA-20001
   In most cases, this type of error will be seen when an item will has an invalid value (null or no value) for a related attribute column.

FRM-40654: Record has been updated. Requery block to see the change
   This type of error will be seen when there is an invalid character/symbol OR leading/trailing space in any of the attributes of an item.

Troubleshooting Steps

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
Troubleshooting Steps
 A. Backup of key tables.
 B. Identify and Resolve Non-displayable characters in the INVIDITM.fmb form.
 1. Run the afchrchk.sql script.
 2. Manual Scripts.
 D. Fix mismatched Master/Organization level Items Attributes
 E. Check the Leading and Trailing spaces in the Segment and Attribute fields
 F. Check if the value sets values being used for the System Items Key Flexfield KFF have a start or end effective date.
 G. Check that the DUAL_UOM_CONTROL is correct for the INVENTORY_ITEM_ID and ORGANIZATION_ID.
 H. Using copy item functionality, create a new item from the existing problem item.
 I. Use the Item Open Import (IOI) to attempt to Update problematic item with minimal details to enable revalidation.
 J. Review if there are any default attributes showing NULL on the problematic item 

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