Error APP-FIND-01564 While Choosing Change Orders on "Engineering Change Order Purge program" (ENCECP) (Doc ID 1453555.1)

Last updated on MAY 15, 2024

Applies to:

Symptoms

On : 12.1.3 version, ECO

When attempting to enter parameters when executing concurrent program "Engineering Change Order Purge program" (ENCECP) the following error occurs.

The query being executed is:

SELECT CHANGE_NOTICE,
  CHANGE_NOTICE VALUE,
  DESCRIPTION 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 ENG_ENGINEERING_CHANGES
WHERE ( ORGANIZATION_ID = :A0
AND STATUS_TYPE IN (5,6))
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 CHANGE_NOTICE,
  3

ERROR
-----------------------
APP-FND-01564: ORACLE error 24345 in fdlget

Cause fdlget failed due to ORA-24345: A truncation or null fetch error occurred.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Engineering Responsibility => ECO/delete
2. Run the concurrent program "Engineering Change Order Purge program"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.