My Oracle Support Banner

Item Search Errors With JBO-27122 and Catalog Intermedia Index Creation Errors With DRG-13004: language is invalid (Doc ID 1435198.1)

Last updated on FEBRUARY 22, 2021

Applies to:

Oracle iProcurement - Version and later
Information in this document applies to any platform.


On, when attempting to search for an item in iProcurement on environment with multiple languages installed, an error occurs. 

On attempting to correct the issue by running concurrent requests "Rebuild Catalog Item InterMedia Index" and "Catalog Index Create - Intermedia", other errors are encountered.


In the application:

JBO-27122: SQL error during statement preparation

"Rebuild Catalog Item InterMedia Index"

Steps To Reproduce
1. Log into iProcurement
2. Search for an item.
3. Get JBO-27122 error.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.