Error on accessing a custom value set
We are facing error while going to access a value set.
(N) --> Payables --> Setup --> Flexfield --> Descriptive --> Values
Here, on searching a custom value set ‘FTIL DFF LOANS’, following error is faced.
APP-FND-01564: ORACLE error 1422 in FDFGVD
Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.
The SQL statement being executed at the time of the error was: SELECT BANK_ACCOUNT_NUM,BANK_ACCOUNT_NUM VALUE, BANK_ACCOUNT_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 CE_BANK_ACCOUNTS WHERE 1=1 AND BANK_ACCOUNT_NUM = :X and was executed from the file &ERRFILE.