PQHWSCET Query Positions Based on Location get APP-FND-01564 ORACLE error 24345 in fdlget (Doc ID 1584966.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When trying to query positions based on location on the position copy form,
get following error :


APP-FND-01564 ORACLE error 24345 in fdlget

cause: fdlget filed due to ORA-24345: A truncation or null fetch error occurred
the SQL statement being executed at the time of the error was:
SELECT LOCATION_ID, LOCATION_CODE ....FROM HR_LOCATIONS ....




STEPS TO REPRODUCE
----------------------------------
Use responsibility : UK HRMS Manager
Navigation :work structures > position > position copy
1.create new position copy record
2. go to original TAB in other criteria
3. enter A% in location field, select location with very long name - get error



WORKAROUND
----------------------------------
Manual creation of positions



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