2555699 - maximumFractionDigits is not being respected when information migrated to Odata API or Ad Hoc

SAP Knowledge Base Article - Public

2555699 - maximumFractionDigits is not being respected when information migrated to Odata API or Ad Hoc

Symptom

  •  Customer created a custom-double field and set the "maximumFractionDigits" to be an specific number, for instance "2". When saving data like 1000,4533 in that custom field, the Job Information portlet shows the 1000,45 value in the new record. However when checking information in Ad Hoc or Odata API, the result for that field will be the complete value, for our example it should appear 1000,4533.

Environment

  • SAP SuccessFactors Employee Central - All Versions

Reproducing the Issue

  1.  Go to Job Information portlet
  2.  Insert a New Record and edit the custom double field you have created, insert the value 1000,4533 and hit save
  3.  Go to the new record the system created, you will see that the value of that field is 1000,45. This is correct because you set the maximumFractionDigits to be "2". So the portlet should show only two decimals
  4.  Run ad Adhoc Report or Check the data in Odata API, it will appear 1000,4533 and not 1000,45. The system is not respecting the maximumFractionDigits value.

Cause

  •  It is an expected behavior in Odata API and Ad Hoc. For now, Odata API expose data in database directly and it do not change the data base on the maximumFractionDigits configuration in data model.

Resolution

  • This is currently working by design. The only workaround is to create a rule that will round the value that you are entering and will not allow you to save more than the decimals you specify in the maximumFractionDigits  configuration. For create this rule, please contact your Implementation Partner.
  • Consider that SAP Support do not create Business rules, this is an Implementation Request.

See Also

Keywords

  •  Employee Central , maximumFractionDigits , Odata AP , Decimals
, KBA , LOD-SF-EC-JOB , Job Information & Propagation XML , Problem

Product

SAP SuccessFactors HCM Core 1708