PERWSHRG: Changing Shift Code gives errors: APP-FND-0156 & ORA-24345
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.
When attempting to change shift code, the following error occurs.
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
The issue can be reproduced at will with the following steps:
1. People > Enter & Maintain > Assignment
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms