AIF APPS - RSE_MASTER_ADHOC_PROCESS Failure (Doc ID 3037138.1)

Last updated on JULY 26, 2024

Applies to:

Goal

We are refreshing the environment and as part of step import hierarchies to AIF, we executed RSE_MASTER_ADHOC_PROCESS with parameter -pld resulting in the following error

Error message in RSE_MASTER_ADHOC_JOB-12265-job.log;

ERROR while running: ALTER TABLE RSE_PACK_COMP ADD PARTITION P_PACK VALUES (PACK) PCTFREE 0
Error adding partition: RSE_PACK_COMP,P_PACK ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL
Error swapping: RSE_PACK_COMP,TMP$RSE_PACK_COMP$,P_PACK ORA-20001: Error occurred in RSE_DDL_UTIL.add_empty_partition - Error adding partition: RSE_PACK_COMP,P_PACK ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294 ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273 ORA-06512: at "RASE01.RSE_DDL_UTIL", line 356 ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL ORA-06512: at "RASE01.RSE_DDL_UTIL", line 263
Error running load_pack_comp. ORA-20001: Error occurred in RSE_DDL_UTIL.swap_table_partition - Error swapping: RSE_PACK_COMP,TMP$RSE_PACK_COMP$,P_PACK ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294 ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273 ORA-06512: at "RASE01.RSE_DDL_UTIL", line 3089 ORA-20001: Error occurred in RSE_DDL_UTIL.add_empty_partition - Error adding partition: RSE_PACK_COMP,P_PACK ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294 ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273 ORA-06512: at "RASE01.RSE_DDL_UTIL", line 356 ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL ORA-06512: at "RASE01.RSE_DDL_UTIL", line 263 ORA-06512: at "RASE01.RSE_DDL_UTIL", line 3052
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.