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 11.5.10.0 and later Oracle Inventory Management - 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:
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!
