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 JULY 08, 2020

Applies to:

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

Purpose

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:

MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
FND_FLEX_VALUES_TL
MTL_DESCR_ELEMENT_VALUES

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
Purpose
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.
References

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