Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

AB115Jul 28 2020 — edited Feb 9 2021

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

Comments

Post Details

Added on Jul 28 2020
#general-ebs-discussion
2 comments
167 views