My Oracle Support Banner

Sales Order Form Freezes When Attempting To Update Order Lines (Doc ID 298427.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Order Management - Version 11.5.9 to 12.2.9 [Release 11.5 to 12.2]
Information in this document applies to any platform.


Actual Behavior

A Processing Constraint was set up with an UPDATE operation.  It keeps on firing at the time of order entry causing the form to freeze and the user unable to move or exit out of the form.

Expected Behavior

Expect that the processing constraint to not repeatedly get triggered after it is initially fired.


a) You have a processing constraint created on update of Order Lines which has the following details:

Constraints: Operation-Update
Attribute- Blank
User Action-Not Allowed
System Changes-Always
User Changes-Never
Conditions: Group - XXX
Validation Entity-Order Line
Record Set-Line
Validation Template-XHL: Multiple Item Restriction

b) Enter two Order Lines with different items.

c) Update one of the lines to the same item as in the other order line.

d) The processing constraint fires preventing the update of the line.

e) Click on the Order Line DFF.

f) Once the cursor is put in the Order Line DFF, the processing constraint keeps on firing even if user attempts to go to the Ordered Item field to change the item.

g) The form freezes and user is stuck and unable to exit out of the form.




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.