(Doc ID 1676349.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Item Master - Version to 12.2 [Release 11.5 to 12.2]
Oracle Product Hub - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.


When trying to update Shippable flag in the Master Items form (INVIDITM), the following error occurs:

"FRM-40200: Field is protected against update."

The issue can be reproduced with the following steps:

1. Go to: Inventory

2. Navigate to: Items > Master Items

3. Query the related item.

4. Go to Order Management Tab

5. Try to update the item attribute, get error.


Note: Also might encounter below error when trying to update Shippable flag in the Master Items Form:

"The Fields can not be updated as there are open sales orders lines."


New attribute validation: if Internal Ordered flag is "Yes", then Shippable Flag has to be "Yes", was introduced in 11.5.0 through <Bug 5533216>. A generic data fix patch is given through <Bug 8396621> done in 12.0.7, through <Bug 8396860> in 12.1 and changes went internally in to 12.1.2. Existing items might have Internal Ordered flag as "Yes" and Shippable Flag as "No". Such items have to be updated with a valid combination to avoid data discrepancy. 


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 hundreds of Community platforms