My Oracle Support Banner

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

Last updated on MARCH 14, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 to 16.0 [Release 16.0]
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!

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.