"There are no available values for this field. Please contact your Agile administrator. " Error After Setting Advanced Search Query for Parts On Read-through Attributes for PCM Object (Doc ID 2512183.1)

Last updated on MARCH 29, 2019

Applies to:

Goal

ACTUAL BEHAVIOR
When attempting to set a advanced search query on Parts read-through attributes
for Product Cost Management (PCM) object attributes, the following error occurs.

ERROR
There are no available values for this field. Please contact your Agile administrator.

FACT
1. When directly search advanced search query for PCM object this error does not occur
2. Out of the box List like Country of Origin, this error does not occur

STEPS
1. Go to Java Client
2. Go to Admin > Settings > Data Settings > Classes
3. Go to the Published Prices class
4. Go to User Interface Tabs > Price Lines > Attributes: Price Lines
5. Open List01 attribute and set visible to Yes. Set a new list : Price01 with List Type : Simple.
6. Go to Admin > Settings > Data Settings > Classes
7. Go to Parts class
8. Go to User Interface Tabs > Prices tab > Attributes: Prices
9. Open List01 attribute and set visible to Yes.
10. Login to Web Client
11. Create a new Published Price : PRICE00001 with Price Lines having List01 : 1
      Item Number : P00001
12. Go to P00001 and confirm Prices tab List01 : 1
13. Go to Advance Search Criteria window and set the following:

    Items : Part : Object Search
    Prices List01 : In

14. Click the Search to add button. Below error message appear.

There are no available values for this field. Please contact your Agile administrator.
 

Solution

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