INVIDITM.fmb FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete
Last updated on FEBRUARY 15, 2018
Applies to:Oracle Item Master - Version 126.96.36.199 and later
Information in this document applies to any platform.
Form:INVIDITM.FMB - Define Item Information
This document includes all versions of Oracle EBS 11i and R12 and later
FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete
blocking / blocked sessions locking the mtl_system_items_b
When Multiple users try to create new item master records, the following error occurs:
FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete.
STEPS TO REPRODUCE:
1) Inventory / Items / Master Items
2) Have several users create items at the same time.
3) Sessions become locked and the error is presented.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms