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:

Symptoms

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

EXPECTED BEHAVIOR
Expects values to be returned based on query criteria

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

NOTES
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

STEPS

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

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.