PPM NEW UX API-1003 : Could not find resource OBS_BROWSE_FLT_IDEA

Products

• Clarity PPM SaaS

Issue/Introduction

While opening the OBS Department field from the New UX Idea Details page. The following error appears:

API-1003 : Could not find resource OBS_BROWSE_FLT_IDEA.

 

Application logs (app-ca.logs) indications:

App-ca.log:
---------------------
ERROR ... Could not retrieve lookup data for lookup type: 
http://ppm_url/ppm/rest/v1/lookups/OBS_BROWSE_FLT_IDEA/lookupValues?....

 

The OBS Department field is confirmed to be API enabled from studio configuration:

The same Department OBS attribute is looking good on the classic PPM Ideas detail page:

 

Cause

OBS_BROWSE_FLT_IDEA is a deprecated view and should have been ideally upgraded to OBS_BROWSE_FLT_ALL.  The upgrade path found for an affected Clarity PPM SAAS environment was a direct upgrade from release 13.2.0.3 to 15.5.0.19.

Environment

Release : 15.8.0 and 15.7.1

Component : CLARITY PPM SAAS APPLICATION

Resolution

Run the following steps against the PPM DB:

1. Take backup for PPM table odf_custom_attributes 

2. Run update query:

UPDATE odf_custom_attributes SET LOOKUP_TYPE ='OBS_BROWSE_FLT_ALL' 
where LOOKUP_TYPE='OBS_BROWSE_FLT_IDEA'; 

3. Commit the changes after update

commit;

4. Restart PPM services

Department OBS lookup should start to work on the new UX: