My Oracle Support Banner

Unexpected Error While Openning Task Descriptive Flexfield (Doc ID 2481692.1)

Last updated on MARCH 11, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to open Task descriptive flexfield on the work order, the following error occurs.

ERROR

You have encountered an unexpected error. Please contact your System Administrator for assistance.

Click here for exception details.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT wo.operation_seq_num AS operation_seq_num,
wo.wip_entity_id AS wip_entity_id,
wo.organization_id AS organization_id,
bso.operation_code AS standard_operation_code,
wo.department_id,
bd.department_code AS department_code,
wo.description AS description,
wor.resource_seq_num AS resource_seq_num,
wor.usage_rate_or_amount AS usage_rate,
wor.assigned_units AS assigned_units,

etc.... then see this below detail:

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 13
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4602)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance Super User.
2. Click on Work Orders tab.
3. Query any WO and click on work order number in view mode.
4. Click on Flexfield icon at the Tasks level (Tasks region).
5. Receive the above unexpected error:
6. Click here for exception details. The error stack shows the above exception details:


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.