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
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.
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 .
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.
When attempting to run the procedure, data_cleanup.clean_level_data the following error occurs.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms