APP-FND-01564 Error When Opening Contact Name List of Values(LOV) on ACA Reporting Requirement
(Doc ID 2039271.1)
Last updated on DECEMBER 05, 2023
Applies to:
Oracle Advanced Benefits - Version 12.1.3 and laterInformation in this document applies to any platform.
This note provides a brief overview of
Symptoms
Problem Statement:
When attempting to open Contact Name LOV in the "ACA Reporting Requirement" form, 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 PF.PERSON_ID,PF.FULL_NAME VALUE, PF.FULL_NAME 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 PER_PEOPLE_F PF, PER_PERSON_TYPES PET WHERE ( PF.BUSINESS_GROUP_ID+0 = :A0 AND PF.EFFECTIVE_START_DATE =(SELECT MAX(EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PPF1 WHERE PPF1.PERSON_ID = PF.PERSON_ID) AND PET.PERSON_TYPE_ID = PF.PERSON_TYPE_ID AND PET.SYSTEM_PERSON_TYPE IN ('EMP','EMP_APL') ) AND 'Y' = 'Y' AND TO_DATE(:A10, 'YYYY/MM/DD HH24:MI:SS') BETWEEN NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A11, 'YYYY/MM/DD HH24:MI:SS')) AND NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A12, 'YYYY/MM/DD HH24:MI:SS')) ORDER BY PF.LAST_NAME, PF.FIRST_NAME
and was executed from file &ERRFILE.
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 PF.PERSON_ID,PF.FULL_NAME VALUE, PF.FULL_NAME 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 PER_PEOPLE_F PF, PER_PERSON_TYPES PET WHERE ( PF.BUSINESS_GROUP_ID+0 = :A0 AND PF.EFFECTIVE_START_DATE =(SELECT MAX(EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PPF1 WHERE PPF1.PERSON_ID = PF.PERSON_ID) AND PET.PERSON_TYPE_ID = PF.PERSON_TYPE_ID AND PET.SYSTEM_PERSON_TYPE IN ('EMP','EMP_APL') ) AND 'Y' = 'Y' AND TO_DATE(:A10, 'YYYY/MM/DD HH24:MI:SS') BETWEEN NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A11, 'YYYY/MM/DD HH24:MI:SS')) AND NVL(TRUNC(TO_DATE(NULL)), TO_DATE(:A12, 'YYYY/MM/DD HH24:MI:SS')) ORDER BY PF.LAST_NAME, PF.FIRST_NAME
and was executed from file &ERRFILE.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Open "ACA Reporting Requirement" form.
(N) Work Structures > Organization > Description > Search for Organization
> Select GRE / Legal Entity > (B) OThers > ACA Reporting Requirement > Open Additional Organization Information DFF structure. - Click on the Contact Name LOV.
- APP-FND-01564 error occurs.
- Click OK in the error window.
- Error "No entries found for List of Values" occurs.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |