Non Catalog Request Errors With JBO-27122 If Person Type Is Employee Applicant (Doc ID 1634778.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

Non catalog request errors when user has Person Type Employee.Applicant

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING
FROM FND_LOOKUP_VALUES_Vl
WHERE LOOKUP_TYPE = :1
and enabled_flag = 'Y'
ORDER BY MEANING ASC
..
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iprocurement as Person Type Employee.Applicant
2. Go to non catalog request



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