APP-FND-01564 Error When Opening Contact Name List of Values(LOV) on ACA Reporting Requirement (Doc ID 2039271.1)

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 .

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.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  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.
  2.  Click on the Contact Name LOV.
  3. APP-FND-01564 error occurs.
  4. Click OK in the error window.
  5. Error "No entries found for List of Values" 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