Invalid Combination Of SHIPPABLE_ITEM_FLAG, INTERNAL_ORDER_ENABLED_FLAG, INTERNAL_ORDER_FLAG Item Attributes
Last updated on SEPTEMBER 08, 2017
Applies to:Oracle Item Master - Version 184.108.40.206 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