APP-FND-01564 Error When Opening Contact Name List of Values(LOV) on ACA Reporting Requirement
Last updated on AUGUST 16, 2016
Applies to:Oracle Advanced Benefits - Version 12.1.3 to 12.1 HRMS RUP8 [Release 12.1]
Information in this document applies to any platform.
This note provides a brief overview of
When attempting to open Contact Name LOV in the "ACA Reporting Requirement" form, the following error occurs.
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.
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