Demantra Calendar Month Upgrade Process Did Partial Split In Inputs Table (Doc ID 1984825.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

12.2.4 in Test

PROBLEM
-------------
Demantra Calendar Month Upgrade process did executed and it did not split many months in inputs table and skipped months arbitrarily


STEPS
--------
Executed below steps

SQL> exec upgrade_to_cal_month.cal_month_split_set_queues;

PL/SQL procedure successfully completed

SQL> exec upgrade_to_cal_month.cal_month_split_set_queues;

PL/SQL procedure successfully completed

SQL> exec upgrade_to_cal_month.main(null,null);

Just a note - last step of calender month upgrade is indexing - and it failed on last step with below error

SQL> exec upgrade_to_cal_month.main(null,null);

begin upgrade_to_cal_month.main(null,null); end;

ORA-20002: -2298 ORA-02298: cannot validate (DP.T_EP_CTO_DATA_1199_FK) - parent keys not found Error in PACKAGE BODY line 2198

  dynamic_ddl( 'ALTER TABLE T_EP_CTO_DATA ENABLE CONSTRAINT T_EP_CTO_DATA_1199_FK')
ORA-06512: at "DP.UPGRADE_TO_CAL_MONTH", line 1021
ORA-06512: at "DP.UPGRADE_TO_CAL_MONTH", line 1137
ORA-06512: at line 1


Cause

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