Keyword Search Not Working For Canadian French Language (Doc ID 1962209.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3 iSupplier / SLM
Keyword Search for Supplier when using French Canadian FRC language preference gives exception SQLException: ORA-29902: erreur d'exécution de la routine ODCIIndexStart(). Similar search in US English language shows expected results.

This occurs after applying [ 12.1.x Patch 19441585:R12.POS.B - Supplier Keyword search is giving inaccurate result ] for a similar issue.


ERROR
## Detail 0 ##
java.sql.SQLException: ORA-29902: erreur d'exécution de la routine ODCIIndexStart()
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [50935],[drpn.c],[1130],[],[]
DRG-00100: internal error, arguments : [50935],[drpn.c],[1492],[],[]
DRG-00100: internal error, arguments : [50935],[drpn.c],[1492],[],[]
DRG-00100: internal error, arguments : [100],[drpn.c],[3170],[],[]
DRG-00100: internal error, arguments : [50611],[drli.c],[2796],[Language code "canadian french" is not supported.],[]


STEPS TO REPRODUCE

US English Language
1. Login as DFELTON
2. Supplier Profile Administrator
3. Keyword
Search = Computer

See the expect results

FRC French Canadian language
4. Login as DFELTON
5. Supplier Profile Administrator
6. Keyword
Search = Computer
- get the error / exception

The keyword search in US English language works, but in FRC language returns error and prevents users from searching with French Canadian FRC language preference

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms