I have a BCS External Content Type based on an Oracle connection via a .NET assembly. I've used this to create an External List in SharePoint 2010.
When I try to display the fields in an InfoPath 2010 using the SharePoint External List as my data source, the fields can all be selected, except for the ones with the Decimal data field type. They do not show up in the list to be able to be selected.
I know that I need to change the data type from decimal to something InfoPath can handle, but I don't have any ideas how to do that. For those who might say, edit the schema, the schema does not show the fields of the decimal data type.
Any suggestions for this specific situation or advice where to make the datatype change?