Procurement - EBS (MOSC)

MOSC Banner

SLM - Advanced Search - Contains/Ends With

edited Nov 7, 2014 10:00AM in Procurement - EBS (MOSC) 2 commentsAnswered

Hi,

We are using the Oracle SLM Advance Search capability. For a specific search the user selected the option 'Contains' or 'Ends With' and ran a search. Unfortunately there were no results. Also there was a warning issue citing:

An invalid operator was specified. Enter at least one indexed attribute to perform a search and a valid operator to make the 'index' usable. Valid operators for an indexed attribute are : is, starts with, greater than, less than, after, and before. If you choose a 'contains' or 'ends with' operator, the indexing on that attribute is ignored.

My query is, how can we use the 'Contains' and 'Ends With' operators in an advanced search? The field on which we are doing the search is indexed. We can determine that with the '^' sign next to it. I understand that if we use these operators, indexing will be ignored, but why doesn't it return any search result?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Procurement Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center