Error when using LocateN function

Chris Arnold

I am trying to use the 'LocateN' function by doing using the following formula in OBIEE 12c:

LocateN('.',"PROCESS_LOG"."PROCESS_STEP_NO",3)

I am receiving the error:

[nQSError: 27042] Function LOCATEN is not defined by administrator. (HY000)

I have Googled this error message and I am not finding anything.

Is LocateN not able to be used in 12c?

Andrew Fomin.

That is a documentation bug. Use Locate function instead.

LOCATE(expr1, expr2, integer)

LocateN Function Is Failing With Error "Formula syntax is invalid" in OBIEE 11g (Doc ID 1391254.1)

Chris Arnold

Wow...looks like I need to work on my internet searching skills. I googled but never found that documentation you've provided.

Thank you VERY much. This was a great help.

Andrew Fomin.

You are welcome.

And it's very unlikely that google can crawl and index MOS.