My Oracle Support Banner

How To Maintain Some Duties With ITEM_DELETE_PRIV and others Without ITEM_DELETE_PRIV? (Doc ID 2409484.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


In Release 16.0.025 a new privilege ITEM_DELETE_PRIV was added.

  1. Copy the new privilege ITEM_DELETE_PRIV to the existing RMS_ITEM_MGMT_DUTY.
  2. Navigate to Manage Roles Mapping and add the ITEM_DELETE_PRIV to the RMS_DATA_STEWARD_JOB.
  3. Pick a duty role, for e.g BUYER_JOB who also has access to the RMS_ITEM_MGMT_DUTY.
  4. Try to remove the ITEM_DELETE_PRIV from the Buyer_JOB. Note that the following message appears.

"The selected mapping will be removed from the associated RMS_ITEM_MGMT_DUTY role. Do you want to continue?"

How to maintain some duties with ITEM_DELETE_PRIV and others without ITEM_DELETE_PRIV?


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.