My Oracle Support Banner

AIF_APPS_MAINT_DATA_CLEANUP_ADHOC_JOB Fails with Error ORA-44002: invalid object name (Doc ID 3004601.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Oracle Retail Promotion and Markdown Optimization Cloud Service - Version 23.2 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 23.2 and later
Information in this document applies to any platform.

Goal

The process AIF_APPS_MAINT_DATA_CLEANUP_ADHOC_PROCESS to run Job AIF_APPS_MAINT_DATA_CLEANUP_ADHOC_JOB is aborting while cleaning up data with the following errors.

EXT_PROG_SYS_OUT:rse_data_cleanup.ksh: ORA-20001: Error occurred in RSE_MAINT_UTIL.clean_all_rse_data - Error while

EXT_PROG_SYS_OUT:rse_data_cleanup.ksh: ORA-20001: Error occurred in PMO_MAINT_UTIL.clean_all_pmo_data - Error while

EXT_PROG_SYS_OUT:rse_data_cleanup.ksh: ORA-20001: Error occurred in RSE_DDL_UTIL.remove_all_partitions - INVALID Input

EXT_PROG_SYS_OUT:rse_data_cleanup.ksh: ORA-44002: invalid object name

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.