My Oracle Support Banner

FA: SCM: GOP: Collect Planning Data - ESS Process Fails With: ORA-12899: value too large for column "FUSION"."MSC_ST_DEMANDS"."SERVICE_LEVEL" (actual: 31, maximum: 30) (Doc ID 2266638.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Order Management Cloud Service - Version and later
Oracle Fusion Global Order Promising Cloud Service - Version and later
Information in this document applies to any platform.


Collecting Supply data using the - Collect Planning Data - task does not complete successfully.

The Collect Planning Data [Collection Job Set > Extract Master] reports an error for the Sales Order Entity.

SALES_ORDERS : 1379652 : ORA-12899: value too large for column "FUSION"."MSC_ST_DEMANDS"."SERVICE_LEVEL" (actual: 31, maximum: 30)

1. Navigate to the Setup and Maintenance
2. Search for and select the task - Collect Planning Data
3. Collect either - Supply Planning Data - in this instance - Sales Orders - was collected
4. Monitor the collection process which shows that this fails with the error


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.