My Oracle Support Banner

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 11.5.10.2 [Release 11.5 to 11.5.10]
Oracle Item Master - Version 11.5.4 to 11.5.10.2 [Release 11.5]
Oracle Product Hub - Version 11.5.4 to 11.5.10.2 [Release 11.5]
Oracle Bills of Material - Version 11.5.4 to 11.5.10.2 [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


Purpose


Oracle Inventory
Item Update Form Errors
(Standalone)

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:
INVItemerr.sql
INVItemerr.sql_readme

Scope

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

Details

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.