My Oracle Support Banner

FA: SCM: SCP: Calendar Load Is Erroring After 20A Upgrade (Doc ID 2642483.1)

Last updated on MARCH 05, 2020

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

User is trying to loaded a few Calendars using FBDI, and facing below error.

ERROR
-----------------------
The Load Entity process started for entity WEEK_START_DATES with refresh number 28495.
ORA-01846: not a valid day of the week
ORA-01846: not a valid day of the week

ORA-06512: at "FUSION.MSC_CALENDAR_API", line 2062

ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "FUSION.MSC_CALENDAR_API", line 2096
ORA-01846: not a valid day of the week
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "FUSION.MSC_CALENDAR_API", line 2096
ORA-01846: not a valid day of the week

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Calendar FBDI provided all the required data in the FBDI
2. Uploaded FBDI in UCM
3. Navigated to Plan inputs>run the Collect data from Flat files and selected uploaded zip and select the net change mode and then submit.

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.