My Oracle Support Banner

Custom Source Pricing Attribute Does Not Show In The Price List Maintenance OA_HTML Page Search List of Values (Doc ID 2660245.1)

Last updated on APRIL 26, 2020

Applies to:

Oracle Advanced Pricing - Version and later
Information in this document applies to any platform.
Price List Setup - Shortname: QPXPRLST.fmb


in Price List Maintenance OA_HTML page, custom attribute "XX_ATTR" does not show any values.

Expects values to be returned based on query criteria

One can see the values in the LOV when viewing the same custom attribute  but from within the price list setup form.


Sometimes one may encounter the following error when attempting to bring up the XX_ATTR "value from"  list of values (LOV):
   FRM-40502: ORACLE error: unable to read list of values.

Details shows:
   FRM-40502: ORACLE error: unable to read list of values
   ORA-00933: SQL command not properly ended


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

* Generic non-existing names were substituted for the real custom attribute names
   These were added to help explain the setup involved.  These are not real names.

1) Setup Qualifier Attribute 'XX_ATTR'
  and assign Valueset: XXX_VALUESET

Go into the responsibility: System Administrator
Navigate to: Application > Validation > Set
Enter value set name: XXX_VALUESET
list type: list of values

value validation
validation type: Table

table application: Receivables
table name: hz_cust_accounts hca, hz_parties hp

value: hca.account_number char 20
meaning: hp.party_name char 360
id: hca.cust_account_id Number 15

where/order by:

Responsibility: Oracle Pricing Manager
Navigate to: Price Lists > Price List Setup
Create a price list for testing adding this pricing attribute, XX_ATTR, to a price list line.

2) What does work:

Responsibility: Oracle Pricing Manager
Navigate to: Price Lists > Price List Setup
Query the price list
Place cursor on a price list line
Click on pricing attribute (button)
select pricing attribute = XX_ATTR
for Value From, bring up the LOV using 123%
  12 records are shown
Clear record and exit the form.

3) What needs addressed:

However, in Price List Maintenance OA_HTML page
click on Advanced Search
enter price list name = <select price list name>

under pricing attribute
pricing context: select Pricing Attribute
pricing attribute:XX_ATTR
operator: <null>
Value from: Bring up Search and enter value % and click on Go

   -- no records are shown


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.