When new elastic domain can be select and insert the effective, but in the search of existing assets number, asset class show will be an error,
Error message is as follows:
Existing in the APP - FND - 01564: FDFGVD ORACLE error 1423
Reason: as the ORA - 01423: check the actual extraction of extra error lines
ORA - 01722: invalid number cause the failure of FDFGVD,
错误发生时正在执行的 SQL 语句是 SELECT SUBSTR(FLEX_VALUE,1,2),SUBSTR(FLEX_VALUE,1,2) VALUE, DESCRIPTION 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_FLEX_VALUES_VL T WHERE (T.HIERARCHY_LEVEL=0 AND T.ENABLED_FLAG='Y' AND T.FLEX_VALUE_SET_ID=(SELECT FLEX_VALUE_SET_ID FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME='JIH_EAM_ALL_CATEGORY' AND ENABLED_FLAG='Y')) AND SUBSTR(FLEX_VALUE,1,2)=:X, 并且它是从 & ERRFILE files,
CodePudding user response:
There are no errors in the SQL statements to the database to run, the data is also a,CodePudding user response:
