My Oracle Support Banner

[SIOCS NextGen Integrated With MFCS NextGen]: Delete Data for the Item Header Module fails with 'ORA-00942' Error (Doc ID 2939397.1)

Last updated on APRIL 14, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 to 23.1 [Release 23.1]
Information in this document applies to any platform.


When attempting to Delete data for the Item Header module, the following error occurs.

{"controlId":65,"logMessage":"[sqlerrm]ORA-00942: table or view does not exist[stacktrace]ORA-06512: at \"SIM01_REX.IDLINT_ITEM_PKG\", line 14\n","dataKey1":null,"dataKey2":null,"dataKey3":null,"createTime":"2023-03-01T12:10:30.299642Z","createUser":SIM01_MDI}

{"controlId":65,"logMessage":"See server log for details.ORA-00942: table or view does not exist","dataKey1":null,"dataKey2":null,"dataKey3":null,"createTime":"2023-03-01T12:10:30.354134Z","createUser":SIM01_BSI}

Steps To Recreate:

1. Go to Admin>Technical Maintenance>Initial Data Load Select Module 'Item Header'>Delete Data.
2. Note the above error.



 This issue only applies to environments where SIOCS and MFCS are deployed together on the OCI NextGen architecture.


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

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