Quality Collection Results Error On Export ' JBO-27120' (Doc ID 2286493.1)

Last updated on JULY 14, 2017

Applies to:

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

Symptoms

When attempting to export the results of NC plan from Quality Work bench   the following error occurs.

ERROR

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: select 'N' as
"HideShowStatus" , CUSTOMER_NAME, ITEM, PRODUCT, COMPONENT_TYPE, LOT_NUMBER, MOLD_NO, SHIFT_NC_CREATED,
SHIFT_NC_FOUND, LOCATION_NC_CREATED, LOCATION_NC_FOUND, NCR_TYPE, NCR_NO, DEFECT_TYPE, SIDE, SURFACE, EDGE,
NONCONFORM_SEVERITY, POSITION, WIDTH, LENGTH, DEPTH, X_C, PICTURE, CREATED_BY, COLLECTION_ID, LAST_UPDATE_DATE, PLAN_ID,
OCCURRENCE FROM QA_120_EXP_V
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)


STEPS

The issue can be reproduced at will with the following steps:

1. Quality Workbecnh --> NonConfirmances --Colleciton Results

2. Entered The Collection Plan --> CLicked on Go

3. In the table region --> >results are shown --> when pressed on the icon Exported results --> it has thrown an 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