My Oracle Support Banner

"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 JULY 14, 2019

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Oracle Agile Product Cost Management - Version 9.3.6.0 and later
Information in this document applies to any platform.

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. Log into 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

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
Goal
Solution
References


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