My Oracle Support Banner

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 later
Information 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

  1. Login to the SIOCS web client
  2. Access Initial Data Seed Screen
  3. Select Store Module
  4. Select all stores
  5. 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


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