Error JBO-27122 When Trying To Create Requisitions In iProcurement
(Doc ID 1078882.1)
Last updated on JANUARY 31, 2019
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
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
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Log into iProcurement
2. Add items to cart
3. Click Checkout
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