AnsweredAssumed Answered

Invalid Lookup Type

Question asked by TDBecker on Sep 24, 2012
Latest reply on Nov 15, 2012 by gaetano.diluca.1
I just recently upgraded my Dev environment from 12.0.6 to 12.1.1. I noticed an error in my app log "Invalid Lookup type: OBS_BROWSE_FLT_MODE_RES" and Invalid Lookup type: OBS_BROWSE_FLT_MODE_PRJ"

I have been trying to find the reference to these lookups so I can understand why the errors are appearing in my log files. I have not been able to track them down to a particular portlet through the old 'trial and error' method.

These lookups do not exist in the CMN_LOOKUPS table. I would expect them to be standard Clarity lookups by the name "OBS_%".

I found an older post listing a query to find references to lookups, but it seems to be specifically for custom objects. Does anyone have any sql for finding references to out of the box lookups? I'm really struggling to find the references to these two error messages.

Here is the other sql I found.. no luck for me..

SELECT objname.name object_name, colname.name column_name
FROM cmn_captions_nls objname, cmn_captions_nls colname,
odf_custom_attributes custattribs,
odf_objects odfobj
WHERE custattribs.lookup_type like 'OBS_%' -- Provide your lookup ID
AND custattribs.id = colname.pk_id
AND colname.table_name = 'ODF_CUSTOM_ATTRIBUTES'
AND colname.language_code = 'en'
AND custattribs.object_name = odfobj.code
AND odfobj.id = objname.pk_id
AND objname.table_name = 'ODF_OBJECTS'
AND objname.language_code = 'en'


Thanks,
Terry

Outcomes