My Oracle Support Banner

JBO-27122 Error When Selecting A Repair Order From Repair Manager Portal (Doc ID 1435390.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

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

Symptoms


12.1.3

When attempting to select a repair order from the repair manager portal page an error occurs.

ERROR
-----------------------
You have encountered an expected error. Please Contact System Administrator for assistance.

Click the details link and the following details are shown:


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT JNVL.ROW_ID,
JNVL.JTF_NOTE_ID,
JNVL.PARENT_NOTE_ID,
JNVL.SOURCE_OBJECT_CODE,
JNVL.SOURCE_OBJECT_ID,
JNVL.NOTES,
JNVL.NOTES_DETAIL,
JNVL.NOTE_TYPE,
JNVL.NOTE_STATUS,
JNVL.LAST_UPDATE_DATE,
JNVL.LAST_UPDATED_BY,
JNVL.LAST_UPDATE_LOGIN,
JNVL.CREATION_DATE,
JNVL.CREATED_BY,
JNVL.ENTERED_DATE,
JNVL.ENTERED_BY,
JNVL.ATTRIBUTE1,
JNVL.ATTRIBUTE2,
JNVL.ATTRIBUTE3,
JNVL.ATTRIBUTE4,
JNVL.ATTRIBUTE5,
JNVL.ATTRIBUTE6,
JNVL.ATTRIBUTE7,
JNVL.ATTRIBUTE8,
JNVL.ATTRIBUTE9,
JNVL.ATTRIBUTE10,
JNVL.ATTRIBUTE11,
JNVL.ATTRIBUTE12,
JNVL.ATTRIBUTE13,
JNVL.ATTRIBUTE14,
JNVL.ATTRIBUTE15,
1 AS UpdatePrimAccess,
1 AS UpdateSecAccess,
'N' AS UseTwoTextFields,
NULL AS AllNotesText,
JNVL.NOTE_TYPE_MEANING AS NOTE_TYPE_MEANING,
JNVL.NOTE_STATUS_MEANING AS NOTE_STATUS_MEANING,
CAC_NOTES_PVT.GET_ENTERED_BY_NAME(JNVL.ENTERED_BY) AS ENTERED_BY_NAME,
JNVL.CONTEXT
FROM JTF_NOTES_VL JNVL) QRSLT WHERE ((source_object_code =:1 and source_object_id = :2) AND (( created_by = fnd_global.user_id AND note_status = 'P' ) OR ( note_status <> 'P' ))) ORDER BY entered_date desc
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. select Depot Repair responsibility
2. Select the Repair Manager Portal page
3. Select a resource name and the link in 'total' column
4. Select the repair order.
5. The error occurs.

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.