oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation When Accessing Calendar
(Doc ID 2570086.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Common Applications - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Getting error when accessing Calendar
Error
================
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT DISTINCT CCR.RESOURCE_ID AS RESOURCE_ID
, CCR.RESOURCE_NAME AS RESOURCE_NAME
, CCR.RESOURCE_TYPE AS RESOURCE_TYPE
, CCR.USER_ID AS USER_ID
, FM.MENU_NAME AS MENU_NAME
FROM CAC_CAL_RESOURCES CCR
, FND_GRANTS FG
, FND_OBJECTS FO
, FND_MENUS FM
WHERE FO.OBJ_NAME = 'CAC_CAL_RESOURCES'
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FG.GRANTEE_TYPE = 'USER'
AND FG.GRANTEE_KEY = FND_GLOBAL.USER_NAME
AND FG.START_DATE < SYSDATE
AND (FG.END_DATE >= SYSDATE
OR FG.END_DATE IS NULL
)
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND CCR.RESOURCE_ID = TO_NUMBER(FG.INSTANCE_PK1_VALUE)
AND CCR.RESOURCE_TYPE = FG.INSTANCE_PK2_VALUE
AND FG.MENU_ID = FM.MENU_ID
AND FM.MENU_NAME IN ( 'JTF_CAL_READ_ACCESS'
, 'JTF_CAL_FULL_ACCESS'
, 'JTF_TASK_READ_ONLY'
, 'JTF_TASK_FULL_ACCESS'
, 'CAC_BKG_READ_ONLY_ACCESS'
)
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT DISTINCT CCR.RESOURCE_ID AS RESOURCE_ID
, CCR.RESOURCE_NAME AS RESOURCE_NAME
, CCR.RESOURCE_TYPE AS RESOURCE_TYPE
, CCR.USER_ID AS USER_ID
, FM.MENU_NAME AS MENU_NAME
FROM CAC_CAL_RESOURCES CCR
, FND_GRANTS FG
, FND_OBJECTS FO
, FND_MENUS FM
WHERE FO.OBJ_NAME = 'CAC_CAL_RESOURCES'
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FG.GRANTEE_TYPE = 'USER'
AND FG.GRANTEE_KEY = FND_GLOBAL.USER_NAME
AND FG.START_DATE < SYSDATE
AND (FG.END_DATE >= SYSDATE
OR FG.END_DATE IS NULL
)
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND CCR.RESOURCE_ID = TO_NUMBER(FG.INSTANCE_PK1_VALUE)
AND CCR.RESOURCE_TYPE = FG.INSTANCE_PK2_VALUE
AND FG.MENU_ID = FM.MENU_ID
AND FM.MENU_NAME IN ( 'JTF_CAL_READ_ACCESS'
, 'JTF_CAL_FULL_ACCESS'
, 'JTF_TASK_READ_ONLY'
, 'JTF_TASK_FULL_ACCESS'
, 'CAC_BKG_READ_ONLY_ACCESS'
)
STEPS
-----------------------
1. Select the other technician from the below option in the main dashboard in FSTP
2. Once in the calendar select another Technician in the drop down box
3. Click 'GO' get the error mentioned.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |