Collecting Supply Data Fails With :- ORA-12899: value too large for column "FUSION"."MSC_ST_DEMANDS"."SERVICE_LEVEL" (actual: 31, maximum: 30)
Last updated on MAY 16, 2017
Applies to:Oracle Fusion Order Management Cloud Service - Version 126.96.36.199.0 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms