My Oracle Support Banner

Error While Executing RPM_PURGE_ITEMLOC_PAYLOAD_CC_JOB (Doc ID 2909663.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

In RPCS(Retail Pricing Cloud Service) when attempting to execute RPM_PURGE_ITEMLOC_PAYLOAD_CC_JOB, the following error occurs.

Error:

13:33:00.434 Thread:0 Process:262 ClientLoggingUtil Purge-FAILED Purge failed-Couldn't invoke a method public abstract void oracle.retail.apps.rpm.model.service.IPayloadPurgeService.process(oracle.retai
l.apps.rpm.common.batch.ExportPurgeParam) throws oracle.retail.apps.rpm.adfcommon.exception.RpmException ,got an exception OracleDatabaseException: OR
A-06550: line 1, column 14:
PLS-00306: wrong number or types of arguments in call to 'CLEANUP_ALL_PAYLOADS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Steps To Reproduce:
1. Run the RPM_PURGE_ITEMLOC_PAYLOAD_CC_JOB via POM.
2. Notice the batch failed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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