My Oracle Support Banner

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


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