SAP Knowledge Base Article - Preview

1821889 - FIM - Error when importing files with comma as decimal separator

Symptom

When importing a flat file with comma as a decimal separator from SAP FIM to SAP Financial Consolidation or other EPM Applications the following error is displayed:

Error during the action: 'Get imported lines without mapping errors' -
while executing an SQL statement against the '' table.

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [SELECT * FROM
(SELECT "CA", "DP", "PE", "RU", "AC", "FL", "AU", "CU", SUM(CAST
(REPLACE("AMOUNT", '.', '.') AS FLOAT)) AS "AMOUNT", "COMMENT" FROM
TRANSACTION_14I_STBT WHERE JOB_RUN_ID = 2147482677 GROUP
BY "CA", "DP", "PE", "RU", "AC", "FL", "AU", "CU", "COMMENT") WHERE
ROWNUM <= 200]; nested exception is java.sql.SQLSyntaxErrorException:
ORA-01722: invalid number


Read more...

Environment

SAP Financial Consolidation 7.5

SAP Financial Consolidation 10.0

SAP Financial Information Management 7.5

SAP Financial Information Management 10

Product

SAP Financial Consolidation 10.0 ; SAP Financial Consolidation 7.5 ; SAP Financial Information Management 10.0 ; SAP Financial Information Management 7.5

Keywords

comma,decimal separator,import,rejected,rows,FIM,FC,Data services,language , KBA , EPM-FIM-GEN , General , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.