APP-FND-01564: ORACLE error 24345 in fdlget, when running register Extra Information Types (EITs) (Doc ID 559992.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 12-AUG-2011***


Symptoms

Review - 06-Feb-2010
====================

Problem Statement:

In 12.0.4 when you run Register Extra Information Types (EITs) with the following parameter :
Table Name : HR_ORG_INFORMATION_TYPES
Then you get the following error :

 

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 being executed at the time of error was:
SELECT FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE, FDFC.DESCRIPTIVE_FLEX_CONTEXT_NAME VALUE,
FDFC.DESCRIPTIVE_FLEX_CONTEXT_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
FND_DESCR_FLEX_CONTEXTS_VL FDFC , FND_DESCRIPTIVE_FLEXS FDF WHERE ( (FDFC.APPLICATION_ID IN (800,
8303) AND FDF.APPLICATION_ID IN (800,8303) AND FDFC.DESCRIPTIVE_FLEXFIELD_NAME =
FDF.DESCRIPTIVE_FLEXFIELD_NAME AND FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE <> 'Global Data
Elements' AND FDFC.ENABLED_FLAG = 'Y' AND ( (FDFC.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Job Info
DDF' AND FDF.APPLICATION_TABLE_NAME = 'PER_JOB_EXTRA_INFO' AND :A0 = 'PER_JOB_INFO_TYPES' AND
FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE NOT IN (SELECT INFORMATION_TYPE FROM PER_JOB_INFO_TYPES ) )
OR (FDFC.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Position Info DDF' AND FDF.APPLICATION_TABLE_NAME =
'PER_POSITION_EXTRA_INFO' AND :A1 = 'PER_POSITION_INFO_TYPES' AND
FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE NOT IN (SELECT INFORMATION_TYPE FROM PER_POSITION_INFO_TYPES ))
OR (FDFC.DESCRIPTIVE_FLEXFIELD_NAME = 'Vehicle Alloc Extra Info DDF' AND
FDF.APPLICATION_TABLE_NAME = 'PQP_VEH_ALLOC_EXTRA_INFO' AND :A2 = 'PQP_VEH_ALLOC_INFO_TYPES' AND
FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE NOT IN (SELECT INFORMATION_TYPE FROM PQP_VEH_ALLOC_INFO_TYPES
)) OR ...

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

1. responsibility Human Resources -> Processes and Reports -> Submit Processes and Reports -> Single Report -> Report Name : Register Extra Information Types (EITs)
2. Parameter Table Name choose HR_ORG_INFORMATION_TYPES
3. I try to choose parameter Information Type and get an error.

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