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 21, 2017

Applies to:

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

Symptoms

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.us.oracle.com:XXX.XXX.X.XX:oacore.default_group.1:143805485:-1:-1:SYSADMIN(0):937523505:Thread[AJPRequestHandler-HTTPThreadGroup-3,5,HTTPThreadGroup]:1486472860: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 NVL(g.end_date, SYSDATE) >= SYSDATE
AND (g.grantee_type='GLOBAL' OR
g.grantee_key IN
(SELECT WUR.role_name
FROM WF_USER_ROLES WUR
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(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3270)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3065)
at _OA._jspService(_OA.java:228)

...

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

 

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.

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