INVMWBIV: Errors ORA-01403 And FRM-40735 When Viewing On-hand Quantity on Material Workbench With Number Format Changed
(Doc ID 2779310.1)
Last updated on AUGUST 04, 2022
Applies to:
Oracle Inventory Management - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Onhand and Availability
ACTUAL BEHAVIOR
---------------
When user changes the Number format in Preferences page in Settings,
and tries to view On hand information they get the below errors
ORA-01403 no data found.
Press details and see FRM-40735 WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Settings Icon > Preferences> Change the Number format to 10'000, and save
2. Go to Inventory > On-hand, Availability > On-hand Quantity
3.Get error ORA-01403 no data found.
4. Press details and see FRM-40735 WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502.
Changes
Issue happens when validating release name on the form when user has number format 10 000,00 or 10.000,00.
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 |
References |