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 types that you can add to each type of data series
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.