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