Duplicate Lines In The Category List of Values On the Modifier Setup Form

(Doc ID 2370570.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Advanced Pricing - Version 12 and later
Information in this document applies to any platform.
Modifier Setup Form QPXPRMLS.fmb
LOV - List of Values

Symptoms


ACTUAL BEHAVIOR
Duplicate values are showing in the list of values for item categories
on the modifier setup form, even after application of <Patch 26765920>:R12.QP.C
and confirming the following file versions:
  $QP_TOP/forms/US/ QPXPRMLS.fmb 120.64.12020000.15
  $AU_TOP/resource/QPXCORE.pld 120.8.12020000.12

EXPECTED BEHAVIOR
Expects to see only one record for each item category.

STEPS
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 a modifier
4. Enter a record under the modifier summary tab
  level: line
  modifier type: Price Break Header
  product attribute: Item Category
5. Bring up the list of values (LOV) for Product Attribute Value
    Do find: 49095%
  2 records are returned with:
  value = 49095
  description = FOREIGN SKU, SPANISH
Expects to see only one record with these details.





Cause

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 hundreds of Community platforms