Job MERCHAPI_OMNI_ORG_HIER_STR_WH_ADHOC_JOB Fails with ORA-01400 Error
(Doc ID 2953868.1)
Last updated on JUNE 09, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
MERCHAPI_OMNI_ORG_HIER_STR_WH_ADHOC_JOB fails with below error.
ORA-01400: cannot insert NULL into ("RMS01"."MERCHAPI_ORG_HIER"."MESSAGE"
Steps to reproduce:
-------------------
1. In CODE_DETAIL table update the code_des for Org Hierarchy. For e.g, update Area to Zone.
2. Run MERCHAPI_OMNI_ORG_HIER_STR_WH_ADHOC_JOB. Note it fails with above 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 |