My Oracle Support Banner

Unable to Update Value In Item Orderability Form Throwing Error Message ORA-01403: No Data Found ,FRM-40735 ON-UPDATE Trigger Raised Unhandled Exception in item orderability (Doc ID 2768602.1)

Last updated on JUNE 06, 2021

Applies to:

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

Symptoms



 User is unable to update value in  Item Orderability form.

ERROR:

ORA-01403: no data found

FRM-40735 ON-UPDATE Trigger Raised Unhandled Exception in item orderability




STEPS
-----------------------

1. Responsibility : Order Management Super User
2. Navigate: Created Items in Inventory, assigned to the Master org
3. Setup > Rules > Item Orderability > Operating Unit: XX_OU
4. Place cursor on line and attempt to update > receive error


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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