My Oracle Support Banner

Apply Hold at Line Level Does Not Work Properly After Cancellation (Doc ID 2677262.1)

Last updated on JUNE 09, 2020

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Transaction Control

After cancellation of 'Apply Hold' action on Sales Order Line, the following errors occur

ORA-01403: no data found
Details: FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-06510

System is working fine when "MO: Default Operating Unit" profile options is set at responsibility level. The error occurs only when the profile option "MO: Default Operating Unit" is not set.

The issue can be reproduced at will with the following steps:
1. Profile option "MO: Default Operating Unit" is not set at Responsibility level.
2. Navigate to Order Management Super User responsibility, query sales order.
3. Go to Line, Action -> Apply Hold -> Cancel. See error "ORA-01403: no data found". Click OK.
4. If customer try to navigate to second line, the following error occurs:
"Operating Unit is required to determine the value of a System Parameter.
ORG ID is required.
ORA-01403: no data found"


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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