OEXOEADJ: Users Sessions Frequently Getting Locked Out (Doc ID 2420194.1)

Last updated on JULY 19, 2021

Applies to:

Symptoms

Users are frequently locked out in their sessions. No clear pattern observed other than that they are all in the Order Management application.
The DBAs then have to go and release the locks on the database/forms.
They access Item Search from Order Management responsibilities.
Most cases are when the users navigate to Action-> View Adjustment window from the order lines.


ERROR
Some users have reported FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001

STEPS
1. Via the Order Management Responsibility.
2. Navigate: Orders, Returns > Sales Orders
3. Go to the order line
4. Actions->View Adjustments
5. Update the Amount Reduced for an automatic modifier line that has already been applied.
6. Click on Apply
7. Enter Reason and click ok, Form is locked, and eventually get the FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001 error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.