Technology Stack - EBS (MOSC)

MOSC Banner

Error on accessing a custom value set

edited Aug 20, 2021 11:28AM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center