My Oracle Support Banner

AIF: Running DATA_DELETE_JOB in DATA_DELETE_PROCESS_ADHOC from POM Fails with Error "ORA-06510: PL/SQL: unhandled user-defined exception" (Doc ID 3081917.1)

Last updated on APRIL 15, 2025

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 24.1 and later
Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and later
Information in this document applies to any platform.

Goal

The Process Orchestration and Maintenance (POM) Job, DATA_DELETE_JOB, within DATA_DELETE_PROCESS_ADHOC is failing:

ORA-20001: Error occurred in DATA_DELETE_UTIL.MAIN_START

ORA-20001: Error occurred in DATA_DELETE_UTIL.DELETE_DATA_BY_MCAL

ORA-20001: Error occurred in RI_PROCESS_LOG_UTIL.TRUNC_PART_BY_VAL

ORA-06510: PL/SQL: unhandled user-defined exception

ERROR: Data delete failed

For this particular case, the customer is deleting only Inventory Receipts (INVRC) for a specific date range. However the POM job is failing. The instructions in Oracle Retail AI Foundation Cloud Services Operations Guide (Chapter 7 Support Utilities > Data Delete Utility) were followed.
 

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.