My Oracle Support Banner

Order Level Manual Modifier Not Available When Promotion Modifier Exists On Any Of The Order Lines (Doc ID 2324754.1)

Last updated on APRIL 13, 2018

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.
Promotional Goods - BOGO
Buy One Get One
Manual Adjustment
LOV - List of Values
Shortname: QPXPRMLS


If an order has a promotional goods modifier applied,
when attempting to select a manual modifier from the sales order header
the following error occurs.

FRM-41830: List of Values contains no entries

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Pricing Manager
2. Navigate to: Modifier > Modifier Setup
     Shortname: QPXPRMLS
3. Query modifier and review its setup
     currency = EUR
  a) modifier no: 22294139
  level = order
  modifier type = discount
  automatic is unchecked
  override is unchecked
  price phase = all lines adjustment

  b) modifier no: 22294140
  level = line
  modifier type = discount
  automatic is unchecked
  override is unchecked
  price phase = all lines adjustment

4. responsibility: Order Management Super User (or equivalent)
5. Navigate to: Orders, Returns > Sales Orders
6. create sales order
7. enter line for item
    promotional goods (lines 2.1 and 3.1) are automatically added
8. update calculate price flag for all lines to calculate price
9. At line, Actions > view adjustments values are shown
10. click on header record
      Actions > view adjustments
      FRM-41830: List of Values contains no entries


 We are upgrading from 11i to 12.2.6 and this works fine in 11i


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.