My Oracle Support Banner

Cannot Log in As SYSADMIN due to Error JBO-27122. Other Users don't Have the Same Problem (Doc ID 2235976.1)

Last updated on FEBRUARY 19, 2019

Applies to:

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


The error message is the following:

After SYSADMIN logs in, the following error appears:

[Feb 7, 2017 6:07:43 AM MST]:1486472863671:-1:-1:<server>.<domain>.com:<IP=XXX.XXX.X.XX>:oacore.default_group.1:143805485:-1:-1:SYSADMIN(0):937523505:Thread[AJPRequestHandler-HTTPThreadGroup-3,5,HTTPThreadGroup]:1486472860:<IP=XXX.XXX.X.XX>:9360:0:9:UNEXPECTED:[fnd.framework.OAException]:oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM ((SELECT m.menu_name as name,
m.user_menu_name as display_name
FROM fnd_menus_vl m, fnd_grants g
WHERE m.menu_id = g.menu_id
AND m.menu_name LIKE 'SESG%'
AND g.start_date <= SYSDATE
AND (g.grantee_type='GLOBAL' OR
g.grantee_key IN
(SELECT WUR.role_name
WHERE WUR.user_name = :1
AND WUR.user_orig_system = :2
AND WUR.user_orig_system_id= :3) OR
g.grantee_orig_system_id IN
(select jrgv.group_id
from jtf_rs_groups_vl jrgv,
jtf_rs_resource_extns_vl jrrev,
jtf_rs_group_members_vl jrgmv
where jrgmv.resource_id=jrrev.resource_id
and jrgmv.group_id=jrgv.group_id
and jrrev.user_name = :4)))union (select 'All','All' from dual)) QRSLT ORDER BY display_name

at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
at _OA._jspService(


## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(


Other users can log in without a problem.

Additional error with the sysadmin responsibility:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.WF_DIRECTORY", line 790
ORA-06512: at line 1

If the query from the error stack is executed from sqlplus, there is no 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.