OE_LOCK_ROW_CHANGED Error When Trying To Change Details On Promotional Goods Modifier Line (Doc ID 2004660.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
Define Modifier
Shortname: QPXPRMLS
Define Details

Symptoms

On : 12.1.3 version, Modifiers Setup only

When attempting to change the get item quantity (or make any update) on a promotion modifier, the following error is shown.
For this particular modifier, an incompatibility group value was recently entered.  However issue occurs on other modifier(s) where
the modifier's incompatibility group was not updated.

ERROR
-----------------------
OE_LOCK_ROW_CHANGED

Secondary error message that might be shown:
    FRM-40105: unable to resolve reference to item PRICING_ATTR_GET.SERVICE_DURATION


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 
1. Enter a pricing modifier using the standard Advanced pricing responsibility and form
Navigate: Oracle Pricing Manager > Modifiers > Modifier Setup
2. Create a modifier line of type Promotional Goods. Do not Enter an incompatibility group.
3. Enter the 'get' item details (Click on Define Details button)
4. Save the modifier and exit the screen
5. Re-query the modifier and try to make a change to the 'get' item details, no error will occur.
6. Enter an incompatibility group on the main line. Save.
8. Go back to the 'get' item details and change the 'get' quantity.
Click on the details button. Change the quantity from 3 to 4. Tab and Save. Get the error oe_lock_row_changed
 
 


Changes

Recently applied the following patches:
<Patch 17070407:R12.QP.B> and  <Patch 17671627:R12.QP.B>

Cause

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