JBO-27122: SQL Error While Trying To Update A Work Schedule When Searching by Description (Doc ID 2890197.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

When trying to update a work schedule and selecting apply an error message appears:

Error Page
Exception Details.
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT CSVL.SCHEDULE_ID,
  CSVL.OBJECT_VERSION_NUMBER,
  CSVL.TEMPLATE_ID,
  CSVL.SCHEDULE_CATEGORY,
  CSVL.START_DATE_ACTIVE,
  CSVL.END_DATE_ACTIVE,
  CSVL.DELETED_DATE,
  CSVL.SCHEDULE_NAME,
  CSVL.SCHEDULE_DESC,
  1 AS UPDATE_ACCESS,
  1 AS DUPLICATE_ACCESS,
  1 AS REMOVE_ACCESS
FROM CAC_SR_SCHEDULES_VL CSVL
where deleted_date is NULL) QRSLT WHERE (1=1 AND UPPER(schedule_desc) LIKE UPPER(:2) AND ( UPPER(VIEW_ATTR) like UPPER(:2) AND (VIEW_ATTR like :3 OR VIEW_ATTR like :4 OR VIEW_ATTR like :5 OR VIEW_ATTR like :6))) ORDER BY START_DATE_ACTIVE DESC


## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_ATTR": invalid identifier

STEPS

--------

1. Global HRMS – Work Structures – Work Schedules – Maintain Schedules >Schedules
2. Query by DESCRIPTION = 45hrs W1 7.5hrs Mo,We,Fr W2 7.5hrs Mo-WE
3. Click Update Icon
4. Make the changes to the description
5. Click on Apply button.
6. Error stack is displayed.

Changes

Cause

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