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 laterInformation 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 |