Data_cleanup.Clean_level_data Error ORA-01843: not a valid month. CLEAN DATA (Doc ID 1416743.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-July-2013***

CLEAN DATA PROCEDURES:

Demantra Documentation Library Oracle Demantra Implementation Guide Release 7.3 Part No. E05136-11

Procedure DATA_CLEANUP.clean_schema_temps(commit_point NUMBER DEFAULT DEFAULT_COMMIT_POINT );
Objects Affected DB_EXCEPTION_LOG, INTEG_STATUS, AUDIT_PROFILES, AUDIT_TRAIL, AUDIT_PROFILE_USERS, E1_SALES, E1_BRANCH, E1_CUSTOMER, E1_ITEM, E1_ITEM_BRANCH, T_SRC_ITEM_TMPL, T_SRC_ITEM_TMPL_ERR, T_SRC_LOC_TMPL,
T_SRC_LOC_TMPL_ERR, T_SRC_SALES_TMPL, T_SRC_LOC_TMPL_ERR
Description DROP_TEMPS(0) is the standard procedure to drop temporary tables created by worksheet runs.See additional objects in clean_schema_int.
Command
EXECUTE DATA_CLEANUP.CLEAN_SCHEMA_TEMPS;
COMMIT;

Notes This should not delete the default member 0 in each level.
Procedure DATA_CLEANUP.clean_level_data( commit_point NUMBER DEFAULT DEFAULT_COMMIT_POINT );
Objects Affected SALES_DATA, MDP_MATRIX and the General Level data and matrix tables PROMOTION, PROMOTION_DATA and PROMOTION_MATRIX

Description Recursively deletes all members for level data except protected levels in PROTECTED_OBJECTS table and the default member .
Command
EXECUTE DATA_CLEANUP.CLEAN_LEVEL_DATA;
COMMIT;

Notes These are mainly created by Oracle EBS collections:
Procedure DATA_CLEANUP.clean_schema_int(commit_point NUMBER DEFAULT DEFAULT_COMMIT_POINT );
Objects Affected DISPLAY_UNITS, REAL_VALUES (only update), DCM_PRODUCTS_UNITS, DCM_PRODUCTS_INDEX, INDEXES_FOR_UNITS, AVAIL_UNITS
Description Deletes levels from TGROUP_RES and removes the column from INPUTS.
Command
EXECUTE DATA_CLEANUP.CLEAN_SCHEMA_INT;
COMMIT;


Symptoms

When attempting to run the procedure, data_cleanup.clean_level_data the following error occurs.

Error report:
ORA-01843: not a valid month
ORA-06512: at "DEV7312.DATA_CLEANUP", line 633
ORA-06512: at "DEV7312.DATA_CLEANUP", line 1080
ORA-06512: at line 1
01843. 00000 - "not a valid month"
 
Data_cleanup.Clean_level_data Error ORA-01843: not a valid month. CLEAN DATA

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