My Oracle Support Banner

ADF Throws ORA-04122 Error While Creating Promotions With the Itemlist Upload Option (Doc ID 2424092.1)

Last updated on JULY 24, 2018

Applies to:

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


When attempting to edit an approved promotion and adding a list of items via the upload receiving the the following error occurs.

"ORA-04122: exact fetch returns more than requested number of rows @ RPM_PROMO_OFFER_MAINT_SQL.ADD_MERCH_GTT"

Steps to Recreate :

1. Login into RPM.
2. Navigate to create promotion.
3. Create a promotion with a item.
4. Click on edit and try adding item list via upload.




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.