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!