Asset Number Import Concurrent Program Failing FDFGVD failed due to ORA-00936: missing expression. (Doc ID 1329040.1)

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***

Symptoms


On : 12.1.2 version, when attempting to run Asset Number Import program, the following error occurs.

ERROR
-----------------------
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,
TO_CHAR(BATCH_ID) 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
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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms