1. Configuring Applications
  2. Support for Decimal Values

Support for Decimal Values

After enabling the decimal quantity for an inventory type, the application starts delivering decimal quantity values to corresponding inventories to the external application (OAC/DBaaS/OIC).

In DBAAS/OAC, the decimal value shows in its database only when the data type of the corresponding column is changed to Float.

You can change this column using these ways:

  • OAC/DBaaS admin user can access the database and change the data type of quantity column from Number to Float. After making this change data received from next data transfer will be saved as a decimal value. There is no change in any of the existing values, All the existing values in the column with Number type remain as number.

  • Oracle Field Service admin user can rename the Quantity field so that it creates a new column on the OAC/DBaaS database. After this change, new quantity values with decimal points are delivered to the new column. The OAC/DBaaS data source has two columns one with number values (existing column) and one with decimal values (new column).

Note: In case of OIC, when you enable the decimal value for inventory quantity, Oracle Field Service transfers only the decimal values. No other configuration changes are required.