SAP Knowledge Base Article - Preview

1816909 - FIM - Values are not taking account of the decimal separator setting when imported

Symptom

Values that contain decimal points as the separator (e.g. '110.33') do not import correctly into a target EPM system (e.g. "SAP Planning & Consolidation'). The values appear to ignore the decimal separator. In the case of the above example value, '110.33' gets imported into PCM as '11,033'.

 When looking at the details of a successful FIM job the following error message is shown:

"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
SUM(CAST(REPLACE("VALUE", ',', '.') AS FLOAT)) AS "VALUE", "VERSION", "PERIOD", "RESPCENTER", "LINEITEM",
"CURRENCY" FROM TRANSACTION_<TransactionID> WHERE JOB_RUN_ID = <JobRunID> GROUP BY "VERSION", "PERIOD",
"RESPCENTER", "LINEITEM", "CURRENCY") WHERE ROWNUM"


Read more...

Environment

  • SAP Financial Information Management 10.0
  • SAP Profitability and Cost Management 10.0
  • SAP Financial Consolidation 7.5 and 10.0

Product

SAP Data Services 4.2 ; SAP Financial Consolidation 10.0 ; SAP Financial Consolidation 7.5 ; SAP Financial Information Management 10.0 ; SAP Profitability and Cost Management 10.0

Keywords

Get imported lines without mapping error, mapping errors, FIM,PCM,FC,financial consolidation,profitability,cost,management,information,errors,values,data,wrong value,decimal separator,seperator,decimal point,period,SQL,import,tomcat,web server,repository,apache,6,6.0,10,regional settings,language,d.user,duser,java,bfc , KBA , EPM-FIM , Financial Information Management (FIM) , EPM-BFC-REP , Data Entry , EPM-PCM , Profitability and Cost Management, EPO, PP, AA, Metify , 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.