My Oracle Support Banner

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 26, 2019

Applies to:

Oracle Common Applications - Version 12.1.3 and later
Information 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'
  )


  
 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


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