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

Last updated on SEPTEMBER 02, 2020

Applies to:

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

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