SAP Knowledge Base Article - Preview

2121858 - Error when loading 'null' data amount with a flat file into BFC - FIM

Symptom

You have the following error during job execution:

(E) (4800:4220) RUN-050802: |Data flow DF_LOAD_BFCJOB|Transform Aggregate
                                                     Cannot convert data <NULL> into type <DECIMAL>. Context: Column <Column AMOUNT>.
(E) (4800:4220) RUN-050304: |Data flow DF_LOAD_BFCJOB|Transform Aggregate
                                                     Function call <to_decimal_ext ( NULL, ., , 38, 10 ) > failed, due to error <50802>: <Cannot convert data <NULL> into type
                                                     <DECIMAL>. Context: Column <Column AMOUNT>.>.
(E) (4800:4220) RUN-050304: |Data flow DF_LOAD_BFCJOB|Transform Aggregate
                                                     Function call <*****> failed, due to error <*****>: <*****>. This message contains some internal system details which have been
                                                     hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional
                                                     privileges to your account.
(E) (4800:4220) RUN-053008: |Data flow DF_LOAD_BFCJOB|Transform Aggregate
                                                     INFO: The above error occurs in the context <|Data flow DF_LOAD_BFCJOB|Transform Aggregate|Column AMOUNT|sum(...) Function
                                                     Parameter-1|to_decimal_ext(...) Function Body|>.


Read more...

Environment

SAP Financial Information Management 10

Product

SAP Financial Information Management 10.0

Keywords

flat file, null, NULL, decimal P_amount, fichier plat , KBA , best practices , 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.