2 Replies Latest reply on Jul 30, 2020 10:48 AM by Mohammed Ali A. Syed

    Getting error as "APP-FND-01564: ORACLE error 907 in FDFGVD" using table type value set

    AB115

      Oracle Apps Version: 12.2.4

      Oracle DB Version:11.2.0.1

      Hi Experts,

       

      We are trying to create table type value set with below condition but getting error as shown below,

       

      Condition:

      Select meaning from fnd_lookup_values

      WHERE lookup_type = 'WIP_EAM_WORK_ORDER_TYPE'

             AND enabled_flag = 'Y'

             AND language = USERENV ('LANG')

             AND SYSDATE >= start_date_active

             AND meaning = 'Breakdown'

             AND SYSDATE <= NVL (end_date_active, SYSDATE)

      UNION

      (select 'All' from dual)

       

      Error:

      APP-FND-01564: ORACLE error 907 in FDFGVD

       

       

      Cause: FDFGVD failed due to ORA-00907: missing right parenthesis.

       

       

      The SQL statement being executed at the time of the error was: SELECT MEANING,MEANING VALUE, MEANING 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_LOOKUP_VALUES WHERE (     (LOOKUP_TYPE = 'WIP_EAM_WORK_ORDER_TYPE'        AND ENABLED_FLAG = 'Y'        AND LANGUAGE = USERENV ('LANG')        AND SYSDATE >= START_DATE_ACTIVE        AND MEANING = 'Breakdown'        AND SYSDATE <= NVL (END_DATE_ACTIVE, SYSDATE)) UNION (SELECT 'All' FROM DUAL))  AND MEANING = :X and was executed from the file &ERRFILE.

       

      Please suggest.

       

      Thanks