Error JBO-27122 When Trying To Create Requisitions In iProcurement

(Doc ID 1078882.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle iProcurement - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


When attempting to create a requisition, the following error occurs.

JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning
from fnd_lookup_values
where lookup_type = :1
and language = :2
and (lookup_code = 'EXPENSE' OR
(lookup_code = 'INVENTORY' AND :3 = 'Y') OR
(lookup_code = 'SHOP FLOOR' AND :4 = 'Y'))
order by meaning asc

The issue can be reproduced at will with the following steps:
1. Log into iProcurement
2. Add items to cart
3. Click Checkout


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