Pricing Purge Batch Fails with ORA-02431: cannot disable constraint Error (Doc ID 2667656.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

Pricing Purge Batch fails with below error.

ERROR:

oracle.retail.apps.rpm.common.exception.RpmException: Error ORA-02431: cannot disable constraint (RPC_RPC_FK) - no such constraint returned by program unit RPM_PURGE_PRICE_CHANGES_SQL.PURGE_PRICE_CHANGES.
  at oracle.retail.apps.rpm.legacy.model.dao.PastPriceChangePlSqlDeleteOperation.doPerform(PastPriceChangePlSqlDeleteOperation.java:33)
  at oracle.retail.apps.rpm.legacy.model.dao.PlSqlDbOperation.perform(PlSqlDbOperation.java:133)
  at oracle.retail.apps.rpm.legacy.model.dao.PastPriceChangePlSqlDeleteOperation.delete(PastPriceChangePlSqlDeleteOperation.java:42)
  at oracle.retail.apps.rpm.model.dao.impl.PriceChangeDao.purgePriceChanges(PriceChangeDao.java:52)
  at oracle.retail.apps.rpm.model.ejb.BatchServiceEjb.purgePriceChanges(BatchServiceEjb.java:843)
  at oracle.retail.apps.rpm.model.ejb.BatchServiceEjb.lambda$purge$56(BatchServiceEjb.java:462)
  at oracle.retail.apps.rpm.model.common.RpmBaseAppModuleImpl.performTransactional(RpmBaseAppModuleImpl.java:48)
  at oracle.retail.apps.rpm.model.root.applicationmodule.RpmRootAMAccessor.lambda$performWithTransaction$2(RpmRootAMAccessor.java:78)
  at oracle.retail.apps.rpm.model.root.applicationmodule.RpmRootAMAccessor.handleADFContext(RpmRootAMAccessor.java:156)
  at oracle.retail.apps.rpm.model.root.applicationmodule.RpmRootAMAccessor.performWithTransaction(RpmRootAMAccessor.java:73)
  at oracle.retail.apps.rpm.model.ejb.BatchServiceEjb.purge(BatchServiceEjb.java:457)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:6

Steps To Recreate:

1. Run PriceChangePurgeBatch 

Cause

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