Asset Number Import Concurrent Program Failing FDFGVD failed due to ORA-00936: missing expression.
Last updated on OCTOBER 27, 2016
Applies to:Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance 24-Feb-2016***
On : 12.1.2 version, when attempting to run Asset Number Import program, the following error occurs.
APP-FND-01564: ORACLE error 936 in FDFGVD
Cause: FDFGVD failed due to ORA-00936: missing expression.
The SQL statement being executed at the time of the errror was:
SELECT DISTINCT(TO_CHAR(BATCH_ID VALUE,
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
MTL_EAM_ASSET_NUM_INTERFACE WHERE (PROCESS_FLAG = 'P')
AND DISTINC(TO_CHAR(BATCH_ID)) = :X and was executed from
the file &ERRFILE
The issue can be reproduced at will with the following steps:
1. Enterprise Asset Management
2. Run Asset Number Import program
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms