[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.
Symptoms
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.
Changes
This issue only applies to environments where SIOCS and MFCS are deployed together on the OCI NextGen architecture.
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 |