MFCS Throws An Error Message When Changing The Status Of An Location For An Item.
(Doc ID 3012899.1)
Last updated on MARCH 27, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 to 24.0 [Release 24.0]Information in this document applies to any platform.
Symptoms
On : 24.0 version, Merch - Items
MFCS throws an error message when changing the status of an location for an item in UI
ERROR
-----------------------
PACKAGE_ERROR:ORA-20001: @0PACKAGE_ERROR@1ORA-06502: PL/SQL: numeric or value error@2RMSMFM_ITEMLOC.INSERT_ICL_ITEM_LOC ORA-06512: at "RMS01.EC_TABLE_ITL_AIUDR", line 175 ORA-04088: error during execution of trigger 'RMS01.EC_TABLE_ITL_AIUDR':ITEM_LOC_SQL.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change the status of an Active item location to Discontinued status in MFCS
2. See the error
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 |
| Cause |
| Solution |
| References |