Item FRM Errors Received Script to Identify Trailing Or Leading Spaces For Items
(Doc ID 245100.1)
Last updated on MAY 19, 2019
Applies to:Oracle Inventory Management - Version 11.5.4 to 220.127.116.11 [Release 11.5 to 11.5.10]
Oracle Item Master - Version 11.5.4 to 18.104.22.168 [Release 11.5]
Oracle Product Hub - Version 11.5.4 to 22.214.171.124 [Release 11.5]
Oracle Bills of Material - Version 11.5.4 to 126.96.36.199 [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
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!