My Oracle Support Banner

Batch-MERCHAPI_REFRESH_ADHOC_JOB Failed With Value Too Large Error (Doc ID 2965681.1)

Last updated on AUGUST 04, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

 MERCHAPI_REFRESH_ADHOC_JOB execution after enabling the Webservices got failed with "Error ORA-12899: value too large for column "RMS01"."MERCHAPI_MERCH_HIER"."MERCH_HIER_LEVEL" (actual: 11, maximum: 10) returned by program unit MERCHAPI_RETAIL_STORE_SQL.REFRESH_MERCH_HIER.".

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.