Last updated on MAY 02, 2017
Applies to:Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Advanced Benefits
When attempting to specify Organization parameter in Participation Process: Scheduled Concurrent Request, 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 HOU.ORGANIZATION)ID,HOU.NAME VALUE, HOU.NAME DESCRIPTION, NVL('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_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI
WHERE ( HOU.BUSINESS_GROUP_ID = :A0 AND
HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID AND
HOI.ORG_INFORMATION_CONTEXT = 'CLASS' AND
HOI.ORG_INFORMATION1 = 'HR_ORG' ) AND 'Y' = "Y' AND
TO_DATE(A:10, 'YYY/MM/DD HH24:MI:SS') BETWEEN
NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A11, 'YYY/MM/DD HH24:MI:SS')) AND NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A12,
'YYY/MM/DD HH24:MI:SS')) ORDER BY HOU.NAME and was executed from the file %ERRFILE.
The issue can be reproduced at will with the following steps:
1. Go to responsibility US Super HRMS Manager.
2. Navigate to Process and Reports > Submit Processes and Reports > Single Request.
3. Select Request Name "Participation Process: Scheduled" and attempt to specify a value for the Organization.
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