My Oracle Support Banner

Downloading Items From Staging Based on Division Failing (Doc ID 2814494.1)

Last updated on OCTOBER 20, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.


Downloading of items from stage tables by Division, Dept is not working. it fails with below error.
"Entity had already been deleted"

Steps to reproduce:
1- Login to RMS
2- go it items and click on download items from staging
3- click on Advance button
4- input division number and click on search
5- Error appears on the screen "Entity had already been deleted"

Also below error can be noted in the server logs.

oracle.jbo.RowAlreadyDeletedException: Entity had already been deleted.
  at oracle.jbo.server.OracleSQLBuilderImpl.doEntitySelectForAltKey(
  at oracle.jbo.server.BaseSQLBuilderImpl.doEntitySelect(
  at oracle.jbo.server.EntityImpl.doSelect(




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

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