APP-FND-01564: ORACLE Error 24345 In Fdlget Clicking Organization parameter in Participation Process (Doc ID 2061673.1)

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.

Symptoms

On : 12.1.3 version, Advanced Benefits

When attempting to specify Organization parameter in Participation Process: Scheduled Concurrent Request, 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 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.

STEPS
-----------------------
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.
Error occurs.


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