PERWSHRG: Changing Shift Code gives errors: APP-FND-0156 & ORA-24345

(Doc ID 2068984.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to change shift code, the following error occurs.

ERROR
-----------------------
APP-FND-01564:ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A Truncation or null fetch error occurred.
The SQL statement being executed at the time of the error was:SELECT LOOKUP_CODE,MEANING VALUE,MEANING DESCRIPTION,
NVL('N','N'),NVL(TO_NUMBER)(NULL),-1),NULL,NVL('Y','Y'),NVL(TO_CHAR(TO_DATE(NULL),'J'),0),NVL(TO_CHAR(TO_DATE(NULL),'J'),0)FROM HR_LOOKUPS WHERE(
LOOKUP_TYPE='XXHR_USHR_SHIFT_TYPE') AND 'Y'='Y' AND TO_DATE(:A00,'YYYY/MM/DD HH24:mi:SS')BETWEEN
NVL(TRUNC(TO_DATE(NULL)),TO_DATE(:A01,'YYYY/MM/DD HH24:MI:SS')) AND NVL(TRUNC(TO_DATE(NULL)),TO_DATE(:A02,
'YYYY/MM/DD HH24:MI:SS')) ORDER BY MEANING and was executed from the file &ERRFILE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. People > Enter & Maintain > Assignment

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms