Initial Data Load of Stores From MFCS to SIOCS Fails With 'Error executing stored procedure. SQLException(4063): ORA-04063:' Error Post 23.2.301.0 Update
(Doc ID 2972059.1)
Last updated on SEPTEMBER 04, 2023
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to data seed Store Item Price from MFCS into SIOCS, the following error occurs. This happens after the environment was updated to 23.2.301.0.
ERROR
-----------------------
{"controlId":12383,"logMessage":"Error executing stored procedure. SQLException(4063): ORA-04063: package body \"SIM01_REX.IDLINT_STORE_PKG\" has errors\nORA-06508: PL/SQL: could not find program unit being called: \"SIM01_REX.IDLINT_STORE_PKG\"\nORA-06512: at line 1\n","dataKey1":null,"dataKey2":null,"dataKey3":null,"createTime":"2023-08-29T15:50:28.202790Z","createUser":SIM01_BSI}
Steps to Reproduce:
Prerequisites: MFCS and SIOCS are hosted on NextGen
- Login to the SIOCS web client
- Access Initial Data Seed Screen
- Select Store Module
- Select all stores
- Click in submit seed
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 |