Which item data types are compatible with which data series?

When you create a data series, you select a data type for it. When you add items to data series, their types must be compatible.

The following table indicates the item types that you can add to each data series type.

Item type Text Integer Float Date time
Text item Yes No No No
Integer item Yes Yes Yes No
Float item Yes No Yes No
Date time item Yes. You are asked if you want to choose part of the date or the whole date. Yes. You are asked to choose the part of the date. No Yes

Tips:

  • You can add any item to a data series with a text type, but if the data mapping is for a CDD, the value that is provided for an item (in InForm) is saved in the customer-defined database (CDD) as the data type of the data series. Therefore, if you add a float item to a text data series, the float item is saved as a text item in the CDD.
  • In a rule data mapping, Oracle recommends creating data series with a type that matches the type of the item or items that will be added to the data series.