Unable to view value set of descriptive flexfeild

Hello All,

We have issue on routing-operation resources form

The issue is occurring only for department 4810 wherever it associated. When we click the operations resources of the department 4810, we are getting the error message

'FLEX-VALUE NOT UNIQUE'.

While clicking Details button of error message, the below message history is showing

FLEX-VALUE NOT UNIQUE
--------------------------------------------------------------
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 BR.RESOURCE_CODE,BR.RESOURCE_CODE VALUE, BD.DEPARTMENT_CODE 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 BOM_DEPARTMENT_RESOURCES BDR,BOM_DEPARTMENTS BD,BOM_RESOURCES BR WHERE ( BDR.DEPARTMENT_ID=BD.DEPARTMENT_ID AND BDR.RESOURCE_ID=BR.RESOURCE_ID AND BD.DEPARTMENT_CODE NOT LIKE '%OSP%' AND BD.ORGANIZATION_ID= :b1 ) AND BR.RESOURCE_CODE = :X and was executed from the file &ERRFILE.