My Oracle Support Banner

Item FRM Errors Received Script to Identify Trailing Or Leading Spaces For Items (Doc ID 245100.1)

Last updated on JULY 13, 2021

Applies to:

Oracle Inventory Management - Version 11.5.4 to [Release 11.5 to 11.5.10]
Oracle Item Master - Version 11.5.4 to [Release 11.5]
Oracle Product Hub - Version 11.5.4 to [Release 11.5]
Oracle Bills of Material - Version 11.5.4 to [Release 11.5]
Information in this document applies to any platform.
This document is for all users of Oracle EBS 11i only, 11.5.4 and later.
Checked for currency on 29-Sept-2014


Oracle Inventory
Item Update Form Errors

This script helps in identifying if there are any Items with rows in MTL_SYSTEM_ITEMS_B or MTL_SYSTEM_ITEMS_TL table that have any trailing or leading spaces in one or
more columns.  This condition will typically raise a message similar to:
FRM-40654:record has been updated. Requery block to see changes

Inputs for this script are INVENTORY_ITEM_ID and ORGANIZATION_ID. See the associated readme file for detailed instructions on how to use this script.

The downloadable files:


This diagnostic script is applicable to EBS 11.5.4 (and higher)


To view full details, 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 a vibrant support community of peers and Oracle experts.